pg_baseback could not connect in AWS linux 2

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
bvo
Reply | Threaded
Open this post in threaded view
|

pg_baseback could not connect in AWS linux 2

bvo
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?

v/r,


Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more.EmojiEmojiEmoji
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


Reply | Threaded
Open this post in threaded view
|

Re: pg_baseback could not connect in AWS linux 2

Peter Eisentraut-7
On 2021-02-12 23:18, Pepe TD Vo wrote:
> 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.

Check your listen_addresses setting in postgresql.conf.