PostgreSQL: Role postgres does not exist?

Question

I have install Postgres 9.3 with pgAdmin form EnterpriseDB on ubuntu,

that is working fine . i create user name is postgres and password is also postgres .

then install odoo 8 from bitnami after that my postgres 9.3 (previous) server is not connecting and giving following error :

PostgreSQL: Role postgres does not exist

i dont remeber actually . I have created python script that connect to that database . from their i found the user name postgres and password is also same and database name is eko — Shubham Batra
– Shubham Batra, Commented Oct 26, 2015 at 7:53

Bhavesh Odedra · Accepted Answer · 2021-05-07 17:44:32Z

3

This type of error came when System User don't have access rights to start Odoo server/ Postgres server.

To avoid those kind issue, we should alter role for System User.

Try with this:

answered Oct 26, 2015 at 8:25

Bhavesh Odedra

11.2k12 gold badges37 silver badges58 bronze badges

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

2 Comments

when i am trying 3rd command psql template1 then it is giving error : psql: FATAL: role "postgres" does not exist

that'y I ask for a system user name. Try with updated answer. Start odoo server with postgres system user.