Перейти к содержимому
Меню
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Этот вопрос был отмечен
Вопрос закрыт по причине: Question / Code not indented по Kabir Khan на 03.06.2024 07:06:42
1 Ответить
1856 Представления

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?

Аватар
Отменить
Лучший ответ

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?

Аватар
Отменить
Автор

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

Автор

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

Related Posts Ответы Просмотры Активность
1
нояб. 24
1218
1
июл. 23
5642
1
мар. 15
5134
5
нояб. 24
14499
2
мар. 25
2402