Skip to Content
Menu
This question has been flagged
1 Reply
8592 Views

When I try to connect to a remote postgresql I get the error

"Is the server running on host "192.168.100.223 and accepting

TCP/IP connections on port 5432?"


I set "listen_addresses='*' in postgresql.conf

In pg_hba.conf I have the line "host all all 0.0.0.0/0 md5"

And the openerp-server.conf is configured with:

db_host=192.168.100.223

db_port=5432

What am I missing?

I'm using Odoo8 an Postgresql 9.3


Avatar
Discard

Did you restart the PostgreSQL to use those changes? Check for a firewall in the PostgreSQL server that could be block the 5432 port. Check if that it's the IP address of the PostgreSQL server that the Odoo server see. Just a few notes about that

Best Answer

Apreciado Juan,

Mira el siguiente enlace:

http://poncesoft.blogspot.com.es/2014/06/utilizar-un-servidor-independiente.html

Espero que te baya bien, recibe un cordial saludo.


Avatar
Discard
Author

Seguí justamente ese tutorial hasta llegar al punto final, donde me salta el error. Gracias, un saludo

Apreciado Juan, Están bien hermanados ambos servidores, es decir, ¿en el /etc/hosts tienes bien puestas la IP del otro servidor? Saludos cordiales

This is an english forum, please respect the guidelines and use english.