【postgresql】postgresql 启动报错socket:socket “/postgresql/data/.s.PGSQL.5432“ failed: No such file o
【代码】【postgresql】postgresql 启动报错socket:socket “/postgresql/data/.s.PGSQL.5432“ failed: No such file o。
·
1.pg登陆报错。
[pgsql@oracle1:/postgresql/data]$psql -U postgres
psql: error: connection to server on socket "/postgresql/data/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
vi postgresql.conf
--如下这行去掉注释。
unix_socket_directories = '/postgresql/data'
2.重启
[pgsql@oracle1:/postgresql/data]$pg_ctl start
waiting for server to start....2024-08-30 16:33:42.186 CST [54512] LOG: starting PostgreSQL 15.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
2024-08-30 16:33:42.186 CST [54512] LOG: listening on IPv6 address "::1", port 5432
2024-08-30 16:33:42.186 CST [54512] LOG: listening on IPv4 address "127.0.0.1", port 5432
2024-08-30 16:33:42.188 CST [54512] LOG: listening on Unix socket "/postgresql/data/.s.PGSQL.5432"
2024-08-30 16:33:42.192 CST [54515] LOG: database system was shut down at 2024-08-30 16:33:40 CST
2024-08-30 16:33:42.196 CST [54512] LOG: database system is ready to accept connections
done
server started
3.登陆
[pgsql@oracle1:/postgresql/data]$psql
psql (15.3)
Type "help" for help.
postgres=#
更多推荐
所有评论(0)