On 6/13/25 11:23, Tom Lane wrote:
Rachel Roch writes:
This is the error I am seeing:
pg_restore: error: could not execute query: ERROR: permission denied to change default privilegesCommand
was: ALTER DEFAULT PRIVILEGES FOR ROLE "postgres" IN SCHEMA "public" GRANT SELECT ON
TABLES TO "my_dat
I have a pg_dump from a postgres instance that I am attempting to restore onto
a cloud one (i.e. an instance where I don't have access to the postgres
superuser)
The dump was taken with:
pg_dump -Fc --quote-all-identifiers --serializable-deferrable
--no-unlogged-table-data my_database > my_dat
Rachel Roch writes:
> This is the error I am seeing:
> pg_restore: error: could not execute query: ERROR: permission denied to
> change default privilegesCommand was: ALTER DEFAULT PRIVILEGES FOR ROLE
> "postgres" IN SCHEMA "public" GRANT SELECT ON TABLES TO "my_database_ro";
Well, you aren't
