Re: Drop Default Privileges?

Hi Louis,

I think 'alter user' can do the job for you.

https://www.postgresql.org/docs/current/static/sql-alteruser.html

Else, as alternative: before running pg_restore, you could edit the dump and replace the string 'ROLE postgres' with the correct user on the RDS instance.

regards,

fabio pardi

Is it possible to drop default privileges?

I’m attempting to run a pg_restore into an RDS instance, which doesn’t have a “postgres” user.

I encounter many messages like so:

ALTER DEFAULT PRIVILEGES...

pg_restore: [archiver (db)] Error from TOC entry 10182; 826 253752252 DEFAULT ACL DEFAULT PRIVILEGES FOR TABLES postgres

pg_restore: [archiver (db)] could not execute query: ERROR:  role "postgres" does not exist

    Command was: ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA abc_schema REVOKE ALL ON TABLES  FROM PUBLIC;

I’d like to remove these default privileges on the source database to avoid this error message, but I can’t find the syntax in the documentation (or if it’s possible). I only see GRANT/REVOKE options.

Thanks,

Louis