Search code examples
postgresqlubuntuodoopostgresql-9.3

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


Solution

  • 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