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

İlgili Gönderiler	Cevaplar	Görünümler
how do I setup postgresql using pgadmin4 to connect to test database? Çözüldü database postgresql remote	2 Haz 19	11859
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 Şub 25	2856
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 Oca 25	10012
Odoo backend to Google Data Studio Çözüldü postgresql	2 Oca 24	10139
Reason why Odoo being slow when there is huge data inside the database postgresql	7 Oca 24	50847

Bu soru işaretlendi

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