Sheikh Wasiu Al Hasib
Sheikh Wasiu Al Hasib
Here issue is that after doing PITR for specific time wal replay resume at all node. For primary when I run pg_wal_replay_resume() that issue gone. When I clone from primary...
When I did switchover from node1 to node 2 it switch over successfully as like below. Here issue is that node1 is not attached with it. ``` [postgres@node2 ~]$ repmgr...
Node1:pgPrimary:192.168.1.11 Node2:pgStandby1:192.168.1.12 Node3:pgStandby2:192.168.1.13 Node4:pgWitness:192.168.1.14 @ibarwick @fanf2 @martinmarques 1. Here node1 was primary where node2 and node3 as standby node and witness node was node4. It was working fine. 2. Next...
I did configure with pgBackRest with repmgr. Till backup it was working well but when I am trying to recover I am not able to do it. I need to...
[postgres@node2 data]$ systemctl restart postgresql-12.service ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ==== Authentication is required to restart 'postgresql-12.service'. Authenticating as: osboxes.org (osboxes) Password: ==== AUTHENTICATION COMPLETE ==== Job for postgresql-12.service failed because...
node1: primary (postgresql server & client,barman,barman-cli,repmgr) node2: standby (postgresql server & client,barman,barman-cli,repmgr) node3: Barman Server (barman,barman-cli,postgresql-client) To recover my database I did following steps whether below steps are correct for...
I am trying to do SCRAM authentication with pgpool it said "SASL authentication failed" error like below image. I am trying to authenticate pgbouncer to pgool to postgresql but pgbouncer...
I have tried several way to run pg_corn but unable to do that. Did not found any log. Somewhere it said entry on on .pgpass and hba.conf file but not...
Basically, I am loading balance data using pgpool but I am fear that if primary node(node1) down then another node (node2) will be the new primary then how can I...
Unable to start repmgr-15.service on boot. I am not sure why it is not started. As per service file it should start after postersql-15.service but it is not started. Somehow...