【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=#
开放原子开发者工作坊旨在鼓励更多人参与开源活动,与志同道合的开发者们相互交流开发经验、分享开发心得、获取前沿技术趋势。工作坊有多种形式的开发者活动,如meetup、训练营等,主打技术交流,干货满满,真诚地邀请各位开发者共同参与!
更多推荐
已为社区贡献10条内容
所有评论(0)