0

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

2
  • With which name you are create PostgreSQL user? Commented Oct 26, 2015 at 6:47
  • 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 Commented Oct 26, 2015 at 7:53

1 Answer 1

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:

  1. Open Terminal and fire this command => sudo su postgres
  2. Enter password for postgres System user
  3. createuser postgres -s
  4. psql template1
  5. alter role postgres with password 'postgres';
  6. \q
  7. Restart Odoo server
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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.