0

at first, I want a HA PostgreSQL by repmgr

subnet its 10.0.30.0/24

da1 server 10.0.30.7 -- master da2 server 10.0.30.6 -- worker so i get error

postgres@da2:~$ repmgr -h 10.0.30.7 -U repmgr -d repmgr -f repmgr.conf standby clone --dry-run NOTICE: destination directory "/var/lib/postgresql/15/main" provided INFO: connecting to source node DETAIL: connection string is: host=10.0.30.7 user=repmgr dbname=repmgr ERROR: connection to database failed DETAIL: connection to server at "10.0.30.7", port 5432 failed: No route to host Is the server running on that host and accepting TCP/IP connections?

i can ssh

postgres@da2:~$ ssh postgres@10.0.30.7 postgres@10.0.30.7's password:

My postgresql.conf file: `listen_addresses = '*' port = 5432

`

the da1 server - master - pg_heba.conf

da1 : 

# Database administrative login by Unix domain socket
local   all             postgres                                peer
local   all             repmgr                                  peer 
# TYPE  DATABASE        USER            ADDRESS                 METHOD
host    all             all             10.0.30.0/24            md5
# "local" is for Unix domain socket connections only
local   repmgr          repmgr                                  trust
local   all             all                                     peer
# IPv4 local connections:
host    repmgr          repmgr          10.0.30.0/24            trust
host    all             all             10.0.30.0/24            md5
host    all             all             0.0.0.0/0               md5
# IPv6 local connections:
host    all             all             0.0.0.0/0               md5
host    all             all             ::1/128                 scram-sha-256
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     repmgr                                  trust
local   replication     all                                     peer
host    replication     repmgr          10.0.30.0/24            trust
host    replication     replicador      10.0.30.0/24            md5
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256

and da2 :

the da2 : 

# Database administrative login by Unix domain socket
local    all             postgres                                peer
#local   all             repmgr                                  peer 
# TYPE  DATABASE        USER            ADDRESS                 METHOD
host     repmgr         repmgr         10.0.30.7/24              md5
host      all           all            10.0.30.0/24              md5
# "local" is for Unix domain socket connections only
local   all             all                                      peer
# IPv4 local connections:
host    all             all             10.0.30.0/24             md5
# IPv6 local connections:
#host    all             all                             md5
host    all             all             ::1/128                 scram-sha-256
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256

I check almost everything still unable to connect

eman Feah
  • 23
  • 3
  • This is a network problem, but it is hard to explain why it is a problem for repmgr but not ssh. Are you sure you are running both from the same machine? Try a simple connection with psql rather than repmgr. – jjanes Aug 02 '23 at 15:10
  • not work for me – eman Feah Aug 06 '23 at 08:28

2 Answers2

0

have you check your firewall rules? can you do telnet from da1 to da2 on port 5432? Please in the two server, please run: netstat -plntu and return the result (you must install net-tools to run netstat)

wmeft
  • 23
  • 7
  • ubuntu@da1:~$ telnet 10.0.30.6 5432 Trying 10.0.30.6... telnet: Unable to connect to remote host: No route to host – eman Feah Aug 06 '23 at 08:41
  • please note that your iptables rules have mistakte on OUTPUT, you should specifie ``sport`` and not ``dport`` from the OUTPUT, ``sudo iptables -A INPUT -p tcp --dport 5432 -j ACCEPT sudo iptables -A OUTPUT -p tcp --sport 5432 -j ACCEPT 86 sudo ufw allow 5432 87 sudo ufw allow 5432/tcp`` – wmeft Aug 07 '23 at 07:46
0

The error No route to host suggests that there is no route for the server IP address in the client's routing table. Are you able to ping the server's IP address? You most likely will not be able to and ping would say that the server is not reachable. If so, then this error has nothing to do with your configuration, you are probably running into a network connectivity issue. You might want to check your firewall rules.

Nnaemeka Daniel John
  • 333
  • 1
  • 7
  • 83 sudo iptables -A INPUT -p tcp --dport 5432 -j ACCEPT 84 sudo iptables -A OUTPUT -p tcp --dport 5432 -j ACCEPT 86 sudo ufw allow 5432 87 sudo ufw allow 5432/tcp – eman Feah Aug 06 '23 at 08:36