Pgadmin Unable to connect centos7 PostgreSQL problem

First view

1. Use Ps-ef|grep postgres to see if the process has started, as normal:

Postgres 1445 1 0 07:54? 00:00:00/usr/bin/postgres-d/var/lib/pgsql/data-p 5432
Postgres 1853 1445 0 07:54? 00:00:00 Postgres:logger Process
Postgres 2075 1445 0 07:54? 00:00:00 Postgres:checkpointer Process
Postgres 2076 1445 0 07:54? 00:00:00 Postgres:writer Process
Postgres 2077 1445 0 07:54? 00:00:00 Postgres:wal Writer Process
Postgres 2078 1445 0 07:54? 00:00:00 postgres:autovacuum Launcher Process
Postgres 2079 1445 0 07:54? 00:00:00 postgres:stats Collector Process
Root 7135 3247 0 09:08 pts/0 00:00:00 grep--color=auto postgres

2. Use Netstat-tpnl|grep 5432 to see if the port is being monitored, as normal:

TCP 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 1445/postgres
TCP6 0 0::: 5432:::* LISTEN 1445/postgres

3. Use the Iptables-l-n|grep 5432 to see if the port is allowed, as normal:

ACCEPT TCP--0.0.0.0/0 0.0.0.0/0 state NEW TCP dpt:5432

You can use Telnet host_ip 5432 to test if you can connect.

As long as the 3 steps are normal pqadmin can be connected.

Pgadmin Unable to connect centos7 PostgreSQL problem