Hello,
I got an error issue with pg_basebackup from sql01 to sql02. I Initdb on sql01 fine and created replicauser, set all parameters in postgresql.conf, and authenticate connection in pg_hba.conf. When I run pg_basebackup, could not connect to server: connection time out. Is the server running on host "x.x.x.204" and accepting TCP/IP connections on port 5432.
I see the listen for port 5432 on sql01 but not in sql02.
$netstat -nlp | grep 5432
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 5295/postmaster /var/run/postgresql/.s.PGSQL.5432
tcp6 0 0 :::5432 :::* LISTEN 5295/postmaster /tmp/.s.PGSQL.5432
unix 2 [ACC] STREAM LISTENING 33401 5295/postmaster /var/run/postgresql/.s.PGSQL.5432
unix 2 [ACC] STREAM LISTENING 33940 5295/postmaster /tmp/.s.PGSQL.5432
but netstat is not listened in sql02.
pg_hba.conf in sql01:
# local
local all all peer
# IPv4
host all all 127.0.0.1/32 ident
local all postgres trust
# IPv6
host all all ::1/128 ident
#replication privilege
local replication all peer
host replication all 127.0.0.1/32 ident
host replication all ::1/128 ident
host replication all sql01_ip/32 trust
host replication all sql02_ip/32 trust
any ideas my setting wrong?