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=# 

Logo

技术共进,成长同行——讯飞AI开发者社区

更多推荐