数据库 postgresql psql: error: could not connect to server: 拒绝连接解决

在部署启动postgresql数据库时遇到这样的问题 通过以下方式得以解决

[pg13@machine ~]$ psql -d postgres

psql: error: could not connect to server: 拒绝连接

Is the server running locally and accepting

connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

1.检查并关闭防火墙状态

[root@machine postgresql-13.5]# systemctl stop firewalld.service

[root@machine postgresql-13.5]# systemctl disable firewalld.service

2.检查服务是否启动，我这边是发现并没有启动

[pg13@machine ~]$ pg_ctl status

pg_ctl: no server running

启动

[pg13@machine ~]$ pg_ctl start

***中间省略***

done

server started

3.加载环境变量

[pg13@machine ~]$ source /home/pg13/.bash_profile

[pg13@machine ~]$ source /home/pg13/.bashrc

4.重新连接，成功

[pg13@machine ~]$ psql -d postgres

psql (13.5)

Type "help" for help.

精彩链接