Skip to Content
This question has been flagged
1 Reply
3614 Views
Avatar
Jan Carlo Aterrado

Odoo's support gave us this response:

Odoo support's response: The master password is related to your PSQL user. 


Apologies if my question maybe dumb but I know we have a master password (admin_passwd in config) for managing databases in Odoo (backup, delete, etc.) and each database could have their own password (db_password in config) but does postgres have its own 'master' password?

As a side note, this was installed as enterprise package installer where it uses the default odoo postgres user. I may not have set a password for the database.


Thanks,

Avatar
Discard
Avatar
Paresh Wagh
Best Answer

Hi Jan:

If you are using Linux and you want to connect to the database, just switch to the postgres user from the root user like so:

$ su postgres

Once you are connected as postgres, you can use psql to connect to the database like so:

$ psql -d YOUR_DATABASE_NAME

You can refer to the psql documentation for other commands that you need. Here's a link to the psql documentation.

https://www.postgresql.org/docs/9.6/app-psql.html

Avatar
Discard