python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - pgpool

How to configure pgpool with repmgr to make node information sync?

I am trying to configure pgpool with postgresql and repmgr. But after configuring that I found it is not working as expected. When I switchover standby to primary using repmgr it is working expected b...
test-img

Sheikh Wasiu Al Hasib

postgresql

load-balancing

database-administration

postgresql-12

pgpool

Votes: 0

Answers: 1

Latest Answer

If you are making repmgr handle automatic failover, you need to add another step in follow_command parameter in repmgr.conf file as follow: follow_command='/usr/bin/repmgr standby follow -f /etc/repmg...
test-img

Taha Adel

Install Pgpool on a server different from the DB server

I have 3 server (PgPool-II installed) and 2 Db (PostgreSQL installed) server. I followed https://www.pgpool.net/docs/43/en/html/example-cluster.html But can't execute psql template1 -c "CREATE EX...
test-img

Jae

postgresql

server

psql

high-availability

pgpool

Votes: 0

Answers: 1

Latest Answer

You need to install Pgpool-II extension on the Postgresql machine to execute following command. psql template1 -c "CREATE EXTENSION pgpool_recovery" see details here: https://www.pgpool.net...
test-img

Umar Hayat

How pgpool-II getting node information?

I want to know where from pgpool getting those node information. I am getting node information using below command but unable to find from where it is getting those data. Is there any database or tabl...
test-img

Sheikh Wasiu Al Hasib

postgresql

database-administration

postgresql-13

pgpool

Votes: 0

Answers: 1

Latest Answer

Pgpool-II intercept this(i.e SHOW) query and return this information. It is not store in database are table, Pgpool-II itself of this information.
test-img

Umar Hayat

Pgpool standby server's status is "down" some time after starting replication with online recovery

I have setup a 2 server cluster system using this configuration examples. They are in the same LAN. Master is node 0 on 192.168.1.31, slave is node 1 on 192.168.1.32. The problem is that approximatel...
test-img

Ozan Başkan

cluster-computing

master-slave

pgpool

postgresql-14

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs