Pgpool-II is a middleware between PostgreSQL servers and clients for connection pooling, replication and load balancing
Questions tagged [pgpool]
225 questions
2
votes
1 answer
pgool2 watchdog not listening on Virtual IP interface
I have set up a pgpool in replication mode with watchdog having a Virtual IP (unused one).
The pgpool and watchdog startup completes successfully.
Virtual eth0:0 interface is created with the specified IP 192.168.143.95. pgPool is configured to run…
mmm.gti
- 43
- 4
2
votes
1 answer
pgpool-II connection pooling - ERROR: "MD5" authentication with pgpool failed
Using the following for just connection pooling no master_slave or replication: rhel 6, postgresql 9.1.9, & pgpool-II 3.1.3 (also tried 3.2.5)
Followed solution suggested in http://www.pgpool.net/pipermail/pgpool-general/2013-May/001773.html
After…
durbin510
- 21
- 1
- 3
2
votes
1 answer
Pgpool in parallel mode does not work in java
We are trying to use pgpool 3.2.1 in parallel mode to split a database table across multiple servers. However, when using java, it seems to only do replication mode and not parallel mode.
In testing, we are using 3 backend servers running Postgres…
anln
- 21
- 2
1
vote
0 answers
PostgreSQL HA + Load Balancing + Pooling setup
I'm facing dilemma regarding which method to achieve HA + Load Balancing + Pooling for postgreSQL.
Currently I'm in the phase of POC, and I had setup a cluster of 3 nodes which consists of 1 master and 2 slave. This cluster also setup with repmgr…
Xonos
- 103
- 10
1
vote
0 answers
bitnami PGPOOL pod won't start : /opt/bitnami/pgpool/conf/pool_hba.conf: Read-only file system
I'm trying to deploy pgpool using docker.io/bitnami/pgpool:4.2.3-debian-10-r38 image but the container fails to start due to this error
pgpool 09:10:02.55 INFO ==> Initializing Pgpool-II... pgpool 09:10:02.59 INFO ==> Generating pg_hba.conf…
ls96
- 11
- 1
1
vote
0 answers
How can PGPool be used for a HA Postgres Cluster for K3S?
In order to run a HA K3S (3-node) cluster I need an HA external database (e.g. PostgreSQL). I have 2 Postgres Servers A and B running in streaming replication mode but I can only point K3S at the master A because only the master allows writes. If A…
Marc
- 13,011
- 11
- 78
- 98
1
vote
1 answer
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 table or function for pgpool from where it is getting…
Sheikh Wasiu Al Hasib
- 450
- 5
- 18
1
vote
1 answer
Pgpool failed to authenticate with backend using md5, valid password not found in kubernetes
I am trying to use pgpool in kubernetes without specifying passwords in pool_passwd, but I am unable to use md5 as authentication method, I am using the Spilo image:
pgpool.conf:
listen_addresses = '*'
port = 5432
socket_dir =…
Matteo
- 2,256
- 26
- 42
1
vote
1 answer
Use of wal files in archive directory of postgres
I have a 2 node PostgreSQL 13.4 HA setup. I have kept the archive_mode=on. With this configuration the wal files are moved from pg_wal dir to archive directory. Also, I am using streaming replication for syncing the master and standby nodes.
I want…
Striker
- 67
- 7
1
vote
0 answers
How to disable all connection pooling in Spring Boot?
Context
By default our SpringBoot application uses HikariCP for its connection pooling.
We are currently investigating how to increase the performance of our application, and want to check out how our load tests behave when using PgPool instead.
It…
payne
- 4,691
- 8
- 37
- 85
1
vote
2 answers
pgpool/postgres - replication_delay is too high, how to reset?
in our setup the show pool_nodes shows a very high replication_delay and it keeps increasing, becuase of which any new queries are not replicated in the slave
following is the output of show pool_nodes command, is there a way to reset this, data…
Harsha Aithal
- 103
- 1
- 1
- 8
1
vote
1 answer
PGPOOL slave node on 'waiting' status
I am trying to configure a simple pgpool with master and slave (all on the same machine - different ports).
whenever I enter the pgpool via psql -p 9999 and run show pool_nodes; I see the master and slave clusters but the slave status is waiting…
user1743176
- 13
- 3
1
vote
2 answers
PgPool-II Sorry, too many clients already
Background
I have a PgPool-II cluster (ver 4.1.4) running on 3 centos 8 machines (virtual); SQL1, SQL2 and SQL3 (each on different hardware). On SQL1 and SQL2 PostgreSQL-12 are running (currently SQL1 is master and SQL2 in streaming replication…
Anthon Nilsson
- 113
- 1
- 7
1
vote
0 answers
Do you need watchdog on pgpool when using repmgr?
I'm using docker swarm and was hoping to use these containers https://github.com/bitnami/bitnami-docker-pgpool and https://github.com/bitnami/bitnami-docker-postgresql-repmgr.
For postgres, I'm going to configure 3 different services and repmgr…
FatalCatharsis
- 3,407
- 5
- 44
- 74
1
vote
1 answer
How do I parameterize a Postgres array value in Node / pg-pool
I am querying an array column (style text[]) using the contains operator @>. My raw query is:
SELECT * FROM songs WHERE style @> '{Acoustic}'
When I drop this into node (using pg-pool) and attempt to parameterize it, the braces surrounding the…
rotarydial
- 2,181
- 2
- 23
- 27