Re: pg_restore ERROR: permission denied to change default privileges

Rachel Roch <rroch@tutanota.de> writes:
> This is the error I am seeing:
> pg_restore: error: could not execute query: ERROR:  permission denied to change default privilegesCommand was: ALTER
DEFAULTPRIVILEGES FOR ROLE "postgres" IN SCHEMA "public" GRANT SELECT ON TABLES TO "my_database_ro"; 

Well, you aren't going to be able to do that if you're not superuser.

You could undo that ALTER in the source database and re-make the dump,
or edit the dump script to remove this command, or not use
pg_restore's "-1" switch and just ignore this error.

            regards, tom lane