Skip to Content
Menu
This question has been flagged

Greetings,

I am using Windows 10 for normal Odoo package installation and I am trying to install another Ubuntu version for testing purpose (Each one in different port), I am using Ubuntu WSL for windows. Installation went fine and the Service is running.

However, when I try to connect to the Windows installation it works fine, but when I connect to Ubuntu one I get an error:

   psycopg2.OperationalError: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? 

 But PostgreSQL for Ubuntu WSL is installed using port 5433:

Ver Cluster Port Status Owner    Data directory              Log file
10  main    5433 online postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log

I have Changed the db_port in the conf file \etc\odoo-server.conf from False to 5433:

[options]
; This is the password that allows database operations:
; admin_passwd = admin
db_host = False
db_port = 5433
db_user = odoo
db_password = False
logfile = /var/log/odoo/odoo-server.log
addons_path = /opt/odoo/addons,/opt/odoo/odoo/addons

However, I get the same error. Seems Psycopg2 take the value as default port 5432 which is the port for PostgreSQL installed in Windows with the Odoo package.

Any help?

Thanks

Avatar
Discard

Will the db_host field be blank or 'localhost'? Not sure though.

Author

@Thitha Rahaman I am not sure what you mean. If you mean in the .conf file db_host = False

Related Posts Replies Views Activity
2
Mar 19
10769
5
Feb 24
33064
2
Jul 24
47985
2
Jul 20
6194
0
Mar 19
3