Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
Câu hỏi đã đóng với nguyên nhân: Question / Code not indented bởi Kabir Khan trên 03/06/2024 07:06:42
1 Trả lời
1937 Lượt xem

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?

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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?

Ảnh đại diện
Huỷ bỏ
Tác giả

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

Tác giả

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

Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 11 24
1311
1
thg 7 23
5740
1
thg 3 15
5207
5
thg 11 24
14899
1
thg 7 25
3245