You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello, I've been trying to set up a replication and everything was fine,including the replication itself as the cloning worked and is active, until I tried to register my standby server:
It gives me the following message when I run "usr/bin/repmgr -f /etc/postgresql/16/main/repmgr.conf standby register" :
INFO: connecting to local node "node2" (ID: 2)
INFO: connecting to primary database
ERROR: unable to connect to the primary database
HINT: a primary node must be configured before registering a standby node
Also when I run " /usr/bin/repmgr -f /etc/postgresql/16/main/repmgr.conf cluster show" at the standby server to check the nodes I receive the following message:
ID | Name | Role | Status | Upstream | Location | Priority | Timeline | Connection string
----+-------------+---------+----------------------+----------+----------+----------+----------+---------------------------------------------
1 | node_master | primary |! running as standby || default | 100 | 1 | user=repmgr dbname=repmgr connect_timeout=2
WARNING: following issues were detected
- node "node_master" (ID: 1) is registered as primary but running as standby
But when I run it at the master server there is no issue:
ID | Name | Role | Status | Upstream | Location | Priority | Timeline | Connection string
----+-------------+---------+-----------+----------+----------+----------+----------+---------------------------------------------
1 | node_master | primary |* running || default | 100 | 1 | user=repmgr dbname=repmgr connect_timeout=2
So I don't know what the problem is. This is the repmgr.conf file of the standby server:
All conninfo settings need to have a host associated to it. That's what is missing. When running repmgr locally it works fine because it connects via the local socket, but remote nodes can't use the conninfo to connect to the primary.
Hello, I've been trying to set up a replication and everything was fine,including the replication itself as the cloning worked and is active, until I tried to register my standby server:
It gives me the following message when I run "usr/bin/repmgr -f /etc/postgresql/16/main/repmgr.conf standby register" :
Also when I run " /usr/bin/repmgr -f /etc/postgresql/16/main/repmgr.conf cluster show" at the standby server to check the nodes I receive the following message:
But when I run it at the master server there is no issue:
So I don't know what the problem is. This is the repmgr.conf file of the standby server:
And here is the repmgr.conf file of the master server:
The text was updated successfully, but these errors were encountered: