Pgpool-II is a middleware between PostgreSQL servers and clients for connection pooling, replication and load balancing
Questions tagged [pgpool]
225 questions
0
votes
1 answer
pcp_recovery_node command hangs while recovering standby
Its a sub-part of cluster , I am building. When I am executing pcp_recovery_node on master to build standby from scratch with the command
pcp_recovery_node -h 193.185.83.119 -p 9898 -U postgres -n 1
Here, 193.185.83.119 is vip.
It successfully…
user3792812
- 155
- 1
- 4
- 13
0
votes
1 answer
Pgpool Log error: Primary 0 owns only 0 standbys out of 1
I have pgpool-II v4.0.2 running on an app server managing two PostgreSQL 11.2 database nodes (0 - primary and 1 - standby). The psql -c 'show pool_nodes' command shows both nodes being up:
$ psql -c 'show pool_nodes'
node_id | hostname | port |…
demisx
- 7,217
- 4
- 45
- 43
0
votes
1 answer
How to check whether a query is directed to node 1 or node 2 in postgres cluster configured with pgpool?
I have configured pgpool with 2 nodes Postgres in replication mode. I would like to check the functionality of load balancing. So, I want to know if there is a way to check which query is redirected to which node in Pgpool -II. Thanks
Ranjan
- 91
- 8
0
votes
1 answer
pgpool and postgresql lots of idle connection
I'm using postdock (https://github.com/paunin/PostDock)
Postgres version: 10
Pgpool version: 3.7
1 pgpool
1 master
1 slave
1 backup (barman)
My application is connecting with pgpool ( I'hv 1 databases and 7 user/app) and I'hv seen from background…
Tarikur Rahaman
- 107
- 4
0
votes
1 answer
PGPool II + Django w/ psycopg2 load balancing
I've a pool of applications running django 1.6 with psycopg2 on top of a PGPool II with two backends PostgreSQL servers. But all queries (read and/or write) are going to master PostgreSQL even SELECT.
As we can see on PGPool II documentation, if we…
Italux
- 95
- 1
- 2
- 9
0
votes
1 answer
postdock for postgres on dockers for windows - PGPOOL not connecting dbs
I have been trying to implement this and I cannot figure out why this will not work. I have read many people downloading and running as is, but the pgpool never connects to the master or slave. I pulled the docker file from paunin's example in…
thePetester
- 31
- 4
0
votes
1 answer
pgpool-II 3.7.5 not caching PG connections
Shouldn't pgpool cache PG backend processes? After disconnecting and reconnecting pool_backendpidchanges.
Relevant parameters:
num_init_children = 1
max_pool = 1
child_life_time = 300
child_max_connections = 0
connection_life_time =…
0
votes
1 answer
PGPool not working with HikariCP in SpringBoot application
I have enabled replication for Postgresql and I am using PGPool to make load balancing.
I am having issues to connect to Postgres using HikariCP and even with Apache DBCP.
Is there a way to use PGPool in SpringBoot application?
Please find the…
Munish Dhiman
- 511
- 1
- 7
- 22
0
votes
1 answer
why does it states that my sql statement needs no parameters
`do $$declare temp_id integer;
begin;
insert INTO public.logindetails(email, pass, dept, designation, status) VALUES($1, $2, $3, $4, $5);
select login_id into temp_id from public.logindetails where email = $1;
INSERT INTO…
OMKAR AGRAWAL
- 128
- 1
- 9
0
votes
0 answers
pgpool connection to postgresql status: "The node is in operation. There is connection. postgres: Down"
i have try configure PostgreSQL with PGPool to manage loa balance and replication, but i have error like this:
image
The node is in operation. There is connection. postgres: Down
from postgreSQL service is up:
root@n43sl:/var/www# service…
user6587282
0
votes
0 answers
How to lock database rows with pgpool master - slave?
I have a Pgpool system with several nodes working on master-slave mode. I also have some resources that have a high level concurrency and there are too many rollbacks.
I was thinking in two solutions:
Use SELECT ... FOR UPDATE queries to block…
Serginho
- 7,291
- 2
- 27
- 52
0
votes
0 answers
Running into an odd issue with postgres jdbc driver
I am using the Postgres jdbc driver with pgpool. Running into this really odd issue which doesn't give me a lot of information on what its complaining about.
Here is the stack trace. Any ideas on how to resolve this?
Apr 19, 2018 3:28:39 PM…
0
votes
1 answer
pgpool-ii 3.7.1 segfaults, connecting to Aurora Postgres
I have configured a new aurora postgres cluster, I compiled my own pgpool-ii 3.7.1 (./configure --with-openssl, linked against libpq for 9.6.5), and I followed the aurora pgpool instructions. I have been unable to connect to my aurora cluster.
I…
Philip C
- 691
- 7
- 18
0
votes
1 answer
After call pg_restore I can not access the database through pgpool2
I wrote script for daily backup DB. Simply steps:
dump
pg_dump -Fc --blobs --section pre-data --section data --section post-data --encoding UTF8 --verbose -h localhost -p 5433 -U username DB -f /home/db.backup
drop and create daily DB
psql -h…
Musketyr
- 745
- 1
- 16
- 37
0
votes
1 answer
High concurrency on PgPool + PostgreSQL Cluster
I have a PgPool II cluster with 2 PostreSQL 9.5 backends (4vCores, 8gb ram) doing loadbalacing+replication. My use case is a website that provides just SSO-login/Registration, is a relative small database, the queries are very simple but it needs to…
agusluc
- 1,445
- 2
- 16
- 24