CODEWITHSUNDEEP
postgresqlubuntuodoopostgresql-9.3
Shubham Batra
Shubham Batra

Reputation: 2375

PostgreSQL: Role postgres does not exist?

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

Upvotes: 0

Views: 10931

Answers (1)

Bhavesh Odedra
Bhavesh Odedra

Reputation: 11143

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

Upvotes: 3

Related Questions