"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?

Post Terkait	Replies	Tampilan
how do I setup postgresql using pgadmin4 to connect to test database? Diselesaikan database postgresql remote	2 Jun 19	11840
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 Feb 25	2818
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 Jan 25	9952
Odoo backend to Google Data Studio Diselesaikan postgresql	2 Jan 24	10139
Reason why Odoo being slow when there is huge data inside the database postgresql	7 Jan 24	50786

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!