How to solve ERROR: must be member of role "postgres"

Question

I am very new to postgres. One of my project is using an RDS postgres instance, the application team created a user and use that user to create the database.

I am trying to grant default privilege to the default postgres user to this application database by running the command below but I am getting an error message.

ALTER DEFAULT PRIVILEGES
FOR USER postgres
IN SCHEMA public
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO postgres;

Error message

ERROR:  must be member of role "postgres"
SQL state: 42501

Please advise how I can grant default privilege to postgres user for the database.

issue is not reproducible in PG 11.4, can you share the PG version. — Vivek
– Vivek, Commented Jul 11, 2019 at 8:57

Laurenz Albe · Accepted Answer · 2019-07-11 09:25:57Z

4

You must connect as a superuser to run this command.

answered Jul 11, 2019 at 9:25

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Captain Vim Over a year ago

Thank you. I misunderstood my case earlier. Apparently, postgres user was the owner of the database not the app user. So I logged in as postgres and executed the command and it works.

Noitidart · Accepted Answer · 2019-11-29 18:50:34Z

1

If you did a pgdump to export the database, and then were getting this error on trying to import it. Use -O when creating the pgdump - https://www.postgresql.org/docs/current/app-pgdump.html

answered Nov 29, 2019 at 18:50

Noitidart

37.6k41 gold badges182 silver badges365 bronze badges

Comments

Captain Vim · Accepted Answer · 2019-07-11 10:13:05Z

0

I misunderstood my case earlier. Apparently, postgres user was the owner of the database not the app user. So I logged in as postgres and executed the command and it works.

answered Jul 11, 2019 at 10:13

Captain Vim

311 gold badge1 silver badge3 bronze badges

Collectives™ on Stack Overflow

How to solve ERROR: must be member of role "postgres"

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related