All Questions
Tagged with postgresql pgpool
77 questions
0
votes
0
answers
19
views
Failover command is incorrectly triggered on standby backend failure in v4.3.1
I am experiencing an issue with Pgpool-II version 4.3.1.
Environment:
Pgpool-II Version: 4.3.1
PostgreSQL Nodes: 2 nodes
Mode: Streaming Replication
Configuration: load_balance_mode is on.
...
- 1
2
votes
2
answers
149
views
Can pgpool handle read queries while the primary is down?
I am trying to configure pgpool to distribute the traffic over two Postgres clusters. One cluster has the primary node, and the other is a replica cluster with a designated primary node that follows ...
- 41
0
votes
0
answers
57
views
pcp_attach_node: username and/or password does not match for user "postgres"
I am setting up pgpool for the first time, using a two-node cluster. The primary node is on 10.6.1.129 and the secondary node is on .131.
backend_hostname0 = '10.6.1.129'
backend_port0 = 5433
...
0
votes
1
answer
236
views
Password authentication with Pgpool
I'm trying to figure out if I'm misunderstanding Pgpool or configuring it incorrectly. I have a database that various users connect to. I want to set up Pgpool to act as a load balancer, and perhaps ...
0
votes
0
answers
48
views
Issues with High Write Transactions in PostgreSQL Cluster with Pgpool Load Balancer
I am currently managing a 3-node PostgreSQL asynchronous streaming replication cluster setup, which includes one master node and two standby nodes, all sitting behind a pgpool load balancer. During ...
1
vote
0
answers
98
views
Why is the replication delay in pgpool showing a very large number?
To calculate replication delay in pgpool, the value is obtained from the view pg_stat_replication.replay_lag.
However, sometimes when executing show pool_nodes, it displays a significantly larger ...
-1
votes
1
answer
122
views
pgpool-II connection pooling (only) but for long running transactions, can it even be done?
I have a job queue management system where workers fetch a job from a queue and maintain that job record locked, they use save-points to make other database changes and, on error, roll back to that ...
- 523
0
votes
1
answer
172
views
PostgreSQL: Database Layer Pooling v/s Application Layer pooling
I would like to have some recommendations about connection pooling in PostgreSQL. We already have connection pooling using Pgbouncer behind an Azure LB. The pgbouncer itself is working pretty much ...
- 625
0
votes
1
answer
104
views
PGPOOL Load Balancing: Create Sequence is going to replica
I created a pgpool instance which can connect to one master database(primary for write) and one read replica.
I have enabled below parameter:
disable_load_balance_on_write='dml_adaptive';
Now my ...
- 312
1
vote
2
answers
6k
views
How to fix authentication through pgpool?
I have a cluster that consists of:
pgpool
master
slave
Using pgpool-II version 4.3.2 and
Postgres 14.4
Several users have been created, all are authenticated through pgpool.
There was a need to ...
- 141
1
vote
1
answer
4k
views
Is it good practice to use both PGBouncer and PGPool together?
We have setup a streaming replication on Postgres 13 and it all works fine. Current setup is as follows.
We have one Primary Postgres and one Secondary Postgres connected via streaming replication. ...
- 111
1
vote
1
answer
598
views
pgpool 4.2.1 and postgres 11 streaming replication problem
I've setup a 2+2 pgpool and postgresql cluster.
two pgpool nodes in active/standby configuration and a streaming replication between databases
All seemed work fine until after some failover and ...
- 11
0
votes
1
answer
709
views
support of multiple databases on different hosts by pgpool2
Let's assume We have 2 databases:
Database1 is located on host1 and host2
Database2 is located on host3 and host4
If I'll use pgpool2 to connect to these 2 databases with single pgpool config for ...
- 135
1
vote
0
answers
2k
views
Postgres Replication - WAL sender throw connection reset by peer
Good morning everyone,
I hope containment is going well for you.
For my part, I use this time to set up a Postgres 11 cluster on my servers, but I have some problems. Can you help me?
I've got ...
- 11
0
votes
1
answer
1k
views
pcp_attach_node not working in pgpool 2
I've been working on pgpool2 setup with 2 DB node and I need to attach on the node, which os currently down. when I run
postgres@pg-pool:~$ pcp_attach_node -p 9898 -n 1 -U postgres
I get following ...
- 111