Pgpool-II is a middleware between PostgreSQL servers and clients for connection pooling, replication and load balancing
Questions tagged [pgpool]
225 questions
1
vote
1 answer
How do I get a response/information from a hanging pgPool.connect()?
I am using the pg package (node.js), and for some reason the connect function gives me nothing. My code gets hung up on that line and I'm unable to see any errors, what's wrong, or what's happening.
i.e.
console.log("HERE");
await…
singmotor
- 3,930
- 12
- 45
- 79
1
vote
1 answer
Postgresql Master-slave replication lagged but pgpool was sending traffic to both db (master n slave)
We do database load balancing using pgpool2 framwork (master + 1 slave).
Yesterday I got few database errors on test server saying - 'column X does not exist'
Upon debugging we found that master-slave replication has stopped or lagged due to which…
Rajat Jain
- 201
- 3
- 12
1
vote
1 answer
1 db connection for all functions in API call
I have a route that handles API calls for timepunches. One of the calls is to "clock_in".
router.route('/clock_in').post(managerCheck, startTimeCheck, isClockedIn, clockIn);
Each of these functions will perform it's own db connection, query the db…
Philip Jay Fry
- 105
- 1
- 6
1
vote
3 answers
Cursor error with postgresql, pgpool and php
Hey, I am struggling a bit to determine the exact cause of an error that has been popping up in our release environment. There does not seem to be much dealing with this particular error on Google.
This is the error message we are…
elyzion
- 133
- 2
- 8
1
vote
0 answers
Spring Boot application with HikariCP and PgPool-II
I need to configure a failover cluster for Postgres. I want to use PgPool-II as failover for the failed instance of DB.
My application runs on Spring Boot 2 and uses HikariCP as datasource. HikariCP is a connection pool by itself, and PgPool uses…
Алексей Романов
- 198
- 1
- 11
1
vote
0 answers
pgLoader connects but then hangs when connected to pgPool and not directly
So I am implementing HA on PostgreSQL 11. I have 2 VMs, and I am using pgPool to manage it. So far so good. Now, on the original DB1 VM I also had a few CSV files getting loaded using pgLoader. If I point pgLoader directly to the DB1 or 2 box it…
AstarAndy
- 121
- 1
- 8
1
vote
1 answer
Settings for Pgpool-2 and 2 read replicas, goal is to split connections evenly between two replicas
My setup:
pgpool-2 V4.0.2
OS Ubuntu
2 aws rds read replicas (master db not included in the setup)
pgpool mode: master_slave mode + sub-mode streaming replication
Purpose of using pgpool (have not achieved)
Evenly split incoming db connections…
druidccsos
- 63
- 8
1
vote
1 answer
pgpool-II does not cache some queries even though it should
I have a PostgreSQL server running on 10.6 with an openSUSE distribution of Linux, and I just set up pgpool-II, to allow me to cache queries. It works mostly fine, but for unknown reasons, sometimes I get this warning message :
WARNING: memcache:…
Adrien
- 73
- 1
- 9
1
vote
1 answer
How to scale the total number of connection with pgpool load balancing?
I have 3 postgresql database (one master and two slave) with a pgpool, each database can handle 200 connections, and I want to be able to get 600 active connection on the pgpool.
My problem is that if I set pgpool with 600 child process, it can open…
David Amen
- 11
- 2
1
vote
1 answer
PostDock (Postgres + Docker) shutdown after a few minutes
I'm using Postdock for load-balancing between Postgres master-slave.
PostDock
I pull latest version of github repo and run docker-compose -f ./docker-compose/latest.yml up -d pgmaster pgslave1 pgslave2 pgslave3 pgslave4 pgpool backup
At first, the…
Thành Long Nguyễn
- 11
- 3
1
vote
1 answer
pgpool2 Watchdogs are crashing when trying to connect to each other using a docker-compose setup
I've been trying to get pgpool2 + watchdog running in a local docker stack. It's actually pretty easy without watchdog, and I was able to follow the docs and have pgpool doing its thing for load balancing in master-slave mode.
The trouble comes…
bluescores
- 4,437
- 1
- 20
- 34
1
vote
2 answers
Install pgpool from RPM
I am installing pgpool-II on rhel 7. I want to install pgpool-II using RPM package for postgreSQL 9.2.
pgpool docs have below line mentioned
yum install pgpool-II-pg96
pg96 means PostgreSQL 9.5.
Does it mean pgpool-II-pg93 means pgpool for…
YogeshR
- 1,606
- 2
- 22
- 43
1
vote
1 answer
pgpool HA + repmgr for Postgresql 9.6
I'm trying to conifure pgpool in my postgresql environment (2 postgresql servers + 1 pgpool) to do HA while repmgr is responsible for the replication.
I'm getting the next messages in the log :
017-12-03 19:27:07: pid 19033: DEBUG: pool_flush_it:…
JeyJ
- 3,582
- 4
- 35
- 83
1
vote
1 answer
How to up a down backend in pgpool, without restart
Is there a easy way to UP a DOWN backend, withour restart pgpool? A command line or something...
for example, when /var/log/postgresql/pgpool_status turn:
up
up
up
into:
up
down
up
alvesoaj
- 512
- 5
- 16
1
vote
3 answers
Pgpool master-slave replication with load balancing - prepared statement "S_380" does not exist
We are using pgpool to run 2 postgresql servers in master-slave mode with load balancing.
Sometimes (it is inconsistent, it works fine other times), I see this exception in the application logs -
09-10-17 01:35:01:627 - {ERROR}…
Mahesh H Viraktamath
- 818
- 3
- 14
- 34