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

Publications associées	Réponses	Vues
how do I setup postgresql using pgadmin4 to connect to test database? Résolu database postgresql remote	2 juin 19	11838
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 févr. 25	2816
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 janv. 25	9939
Odoo backend to Google Data Studio Résolu postgresql	2 janv. 24	10139
Reason why Odoo being slow when there is huge data inside the database postgresql	7 janv. 24	50771

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !