Database master password

Question

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

Paresh Wagh · 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 [1]

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

This question has been flagged

Enjoying the discussion? Don't just read, join in!