"Database creation error: Access denied" when acessing remote Postgre base

Question

Using Odoo 9.0 and PostgreSQL 9.5.
I want to use Odoo in a remote PostgreSQL server. Both services are in different Cloud servers hosted on Digital Ocean. I already tried:
Changing the pg_hba.conf and postgresql.conf to listen to all addresses and hosts in the PostgreSQL Server machine.
Creating odoo user in postgres with superuser and createdb permissions.
Changing both the openerp-server.conf at /opt/odoo/odoo-server/debian and /etc/odoo/. Adding the db_host, db_port, db_user and db_password a

Marcio Ribeiro · Accepted Answer

I found the solution! When prompted for the Master Password in the moment of creating the db I wasn't inserting the proper one.
Ivan answer in this thread helped me figured it out:
https://www.odoo.com/es_ES/forum/ayuda-1/question/acess-denied-error-while-creating-a-company-database-73979
In this step you are supposed to use the Odoo password for database operations.

@Ermin Trevisan Thanks for your help, appearently the firewall presented no problem at all.

Ermin Trevisan · Answer

Maybe stupid, but did you open port 5432 in the firewall of your Postgres-server?

Gerelateerde posts	Antwoorden	Weergaven
how do I setup postgresql using pgadmin4 to connect to test database? Opgelost database postgresql remote	2 jun. 19	11876
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 feb. 25	2878
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 jan. 25	10034
Odoo backend to Google Data Studio Opgelost postgresql	2 jan. 24	10139
Reason why Odoo being slow when there is huge data inside the database postgresql	7 jan. 24	50872

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!