Pgpool-II is a middleware between PostgreSQL servers and clients for connection pooling, replication and load balancing
Questions tagged [pgpool]
225 questions
0
votes
0 answers
how to set sshd service to start automatically in official postgresql docker image
I am trying to create a postgres pgpool cluster across multiple docker hosts.
I am trying to do something like;
entrypoint: ["bash -c '/usr/local/bin/docker-entrypoint.sh postgres && service ssh start'"]
I added openssh-server to the…
user11236651
- 11
- 3
0
votes
0 answers
PGPOOL ii always stand by server status unused how i can make both nodes work?
i implement streaming async replication between two postgreSQL 14 , and i installed and configure pgpool ii on third server , i try to send quires via pgpool and works fine but all quires returned from master server and stand by server status always…
Ahmed Mostafa
- 65
- 1
- 5
0
votes
0 answers
Connecting to pgpool2 through nodejs
I have a running streaming replication between two "debian 11" virtualBoxes (with bridged network adaptators) running a master/slave postgreSQL configuration. That configuration is correctly accessed through pgpool2. The main configurations points…
MamorukunBE
- 120
- 1
- 9
0
votes
1 answer
What's the Best connections settings for pgpool-4.4.0 with PostgreSQL-12.5
I'm new on the pgpool and I really wants to work on it but just stuck with handling the connections parameters setting with postgres db.
Problem: I'm seeing a huge number of idle connections and it's degrading my DB performance also it creating…
Suraj Sawant
- 29
- 4
0
votes
1 answer
Setup pgpool issue
Trying to setup pgpool 4.4.2, but when tried to config the authentication to use scram-sha-256 it give me the following error:
$ bin/pg_enc -m -k /export/home/postgres/.pgpoolkey -u pgpool -p
db password:
trying to read key from file…
scapy
- 110
- 5
0
votes
1 answer
Pgpool2: unable to read message kind
I managed to configure Pgpool using 3 virtual machines on my pc, but when I repeated the same procedure on a VPS it gives the following error
child pid 5286: ERROR: unable to read message kind
child pid 5286: DETAIL: kind does not match between…
Miqueias Kevison
- 111
- 4
0
votes
0 answers
pg-pool throwing error after successful queries
I am trying to send post request to update state of a record in database. I'm using pg-pool to talk to database. My code is failing in the second query where I get 'This socket has been ended by other party'. Even though I get run state update…
ilaunchpad
- 1,283
- 3
- 16
- 32
0
votes
1 answer
How to get pid of pgpool 2 process in ubuntu
I've installed Postgres 11.18 and pgpool 2 from their Git Repo.
Now I want to get the pid of the pgpool process so that I can attach that to gdb and do my debugging.
Much appreciated!
Muhammad Zahid
- 154
- 8
0
votes
1 answer
pgpool :no such file or directory pgpool.pid
I have installed pg-pool 2 using their GitHub repository
When I use the command:
pgpool -n &
I am getting the following error:
Muhammad Zahid
- 154
- 8
0
votes
0 answers
PgPool, change max password size
I am using pgpool with postgres and to authenticate users I am using PAM with JWT tokens,
however I just discovered that pgpool does not accept passwords longer than a certain value and it seems that this value is hardcoded: (pool.auth.c)
if…
Matteo
- 2,256
- 26
- 42
0
votes
0 answers
What is the backend_data_directory0 in pgpool2?
It's not clear from the documentation what backend_data_directory0 is.
If I run Postgres on Hosts A and B and PGPool on Host C - how am I supposed to point PGPool on Host C at at a directory on Host A?? Am I supposed to mount my database server data…
Marc
- 13,011
- 11
- 78
- 98
0
votes
0 answers
com.zaxxer.hikari.HikariDataSource.getConnection taking too long
I am currently using a micro services architecture and under high load (around 1000 requests per second), the services become drastically slow and most of the components that use database keep restarting due to the…
Ifesinachi Bryan
- 2,240
- 1
- 19
- 20
0
votes
0 answers
Issue in postgresql HA mode switching of Master node
I am new in postgresqlDB configuration. I am trying to configure postgresDB in HA mode with the help of pgpool and Elastic IP. Full setup is in AWS RHEL 8 servers.
pgpool version : 4.1.2
postgres version - 12
Below links I have followed during the…
BanashreeB
- 1
- 1
0
votes
0 answers
The pgpool configuration file pool_hba.conf and pool_passwd cannot automatically synchronize user login information when a new user is created
question:bitnami/postgresql-ha:The pgpool configuration file pool_hba.conf and pool_passwd cannot automatically synchronize user login information when a new user is created, how should I fix this problem?
Details:I have deployed…
HamBerg
- 1
0
votes
1 answer
FATAL: failed to create INET domain socket in PGPOOL2
priyank@infahmcpu0010:/etc/pgpool2$ pgpool -n
2022-06-20 18:48:40.282: main pid 33987: LOG: reading status file: 1 th backend is set to down status
2022-06-20 18:48:40.282: main pid 33987: LOG: health_check_stats_shared_memory_size: requested…
