Pular para o conteúdo
Menu
Esta pergunta foi sinalizada
A pergunta foi fechada por motivo: Question / Code not indented
por Kabir Khan em 03/06/2024 07:06:42
1 Responder
1961 Visualizações

Database creation error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket?

Avatar
Cancelar
Melhor resposta

Normally, PostgreSQL listens on port 5432 and not 8069.

Port 8069 is the default port used for the Odoo web server.

Have you possibly changed the port manually in a configuration file?

Avatar
Cancelar
Autor

odoo@ip-172-31-3-182:~$ exit
logout
ubuntu@ip-172-31-3-182:~$ sudo su - postgres
This account is currently not available.
ubuntu@ip-172-31-3-182:~$ ubuntu@ip-172-31-3-182:~$ sudo su - postgres
This account is currently not available.sudo -u postgres psql
^C
ubuntu@ip-172-31-3-182:~$ sudo -u postgres psql
could not change directory to "/home/ubuntu": Permission denied
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
ubuntu@ip-172-31-3-182:~$ sudo nano /etc/odoo17.conf
GNU nano 6.2 /etc/odoo17.conf
[options]
admin_passwd = mxdk-uy6w-n28u
db_host = False
db_port = False
db_user = odoo1
db_password = False
xmlrpc_port = 8069
addons_path = /opt/odoo17/odoo17/addons
logfile = /var/log/odoo17/odoo17.log

[ Read 9 lines ]
^G Help ^O Write Out ^W Where Is ^K Cut ^T Execute ^C Location M-U Undo M-A Set Mark M-] To Bracket M-Q Previous
^X Exit ^R Read File ^\ Replace ^U Paste ^J Justify ^/ Go To Line M-E Redo M-6 Copy ^Q Where Was M-W Next

Autor

this is my conf

[options]
admin_passwd = mxdk-uy6w-n28u
db_host = False
db_port = False
db_user = odoo1
db_password = False
xmlrpc_port = 8069
addons_path = /opt/odoo17/odoo17/addons
logfile = /var/log/odoo17/odoo17.log

the configuration looks correct, but since xmlrpc_port is 8069 by default, you can remove this setting and check if it works without it.

You could also try adding "db_port = 5432" to tell Odoo the correct port directly

Publicações relacionadas Respostas Visualizações Atividade
1
nov. 24
1333
1
jul. 23
5758
1
mar. 15
5218
5
nov. 24
14970
1
jul. 25
3262