Stack Overflow
Stack Overflow

Questions tagged [pgpool]

Pgpool-II is a middleware between PostgreSQL servers and clients for connection pooling, replication and load balancing

pgpool wiki

225 questions
3
votes
3 answers

Query to PgPool-II and command show pool_nodes not working

I have an net core application that connects to PostgreSQL servers through a PgPool-II cluster. It works very well, exept when I try to use the pgpool sql commands, such as "show pool_nodes", the commands seems to pass by pgpool and instead enter…
Anthon Nilsson
  • 113
  • 1
  • 7
3
votes
0 answers

PostgreSQL/PostDock: Auto recovery failed in master node

I use Docker service and Docker swarm to deploy the PostDock cluster This is my docker-compose.yml setup: version: "3.3" networks: postdock: external: true services: pgmaster: image: postdock/postgres environment: …
moeman
  • 119
  • 4
3
votes
1 answer

Pgpool executes queries on standby nodes instead of master when replication is behind in standby

I have a postgresql 10 master db with 2 hot standby servers with streaming replication, and the replication is working correctly. The synchronous_commit is setted to remote_write Also I have a pgpool 3.7.5 configured with the params: delay_threshold…
sabadow
  • 5,095
  • 3
  • 34
  • 51
3
votes
1 answer

What are other middleware alternatives for PgBouncer and PgPool II?

I am trying to find what are the different middleware available to work with Postgres DB. Every one is recommending about PgBouncer and PgPool II. What are the list of other middleware that I can work with.
Jagadeeswar
  • 311
  • 2
  • 5
  • 14
3
votes
2 answers

PgPool-II and repmgr Automatic Failover

I have pgpool-II for HA and repmgr for automatic failover. Pgpool-II also can also run failover I am just wondering doing automatic failover using pgpool or repmgr? If pgpool can do the failover do I need to use repmgr? and use shell scripts to the…
varun7447
  • 574
  • 1
  • 6
  • 27
3
votes
3 answers

PostgreSQL - Fail to start delegate ip address on pgpool 2

I try to set up a pgpool server on ubuntu server and following this link : pgpool-II Tutorial [ Watchdog ]. But when I to start a pgpool service, the delegated IP doesn't start. I have seen in a log file on syslog and got some error like this. …
chatree kunjai
  • 31
  • 1
  • 3
3
votes
1 answer

Pgpool not regaining connection

I have a set of 4 vagrant systems. web1 (Main db) web2 (db replicated from web1) mgmt (a node from which Im connecting from) web3 (pgpool is running) My pgpool is setup to load balance between the databases on web1 and web2. It works well and I…
leoOrion
  • 1,833
  • 2
  • 26
  • 52
3
votes
2 answers

pgpool num_init_children with 10000 Concurrent connections

Yesterday I have test pgpool with pgbench : pgbench -c 30 -T 20 -r pgbench -p9999 -h192.168.8.28 Concurrent connections is 30, pgpool default num_init_children is 32. So, when I set -c 33 ,test will blocked unless I break out. My question is :…
scofier
  • 31
  • 1
  • 3
3
votes
1 answer

Django CONN_MAX_AGE failures with postgresql max_connections

Since I'm using CONN_MAX_AGE: 300 on my Django servers, request fail with errors because PostgreSQL exceeds the max_connections limit (which is 100 by default). What is the best strategy to solve this? I've tried using pgpool2, but this didn't solve…
vdboor
  • 21,914
  • 12
  • 83
  • 96
3
votes
1 answer

Can't connect to pgpool

I'm playing around pgpool2. I'm connecting to postgresql which is running on port 5432 with command psql -U postgres -p 5432 and it's connecting normally. When I'm connecting to pgpool2 running on 9999 port with command psql -U postgres -p 9999 -…
Nikolay Fominyh
  • 8,946
  • 8
  • 66
  • 102
3
votes
2 answers

Connection Pool for a Single Threaded Application

Is there any reason to maintain a pool with more than one connection when running a single-process, single-threaded application?
onk
  • 65
  • 1
  • 4
3
votes
1 answer

php5 + pdo + postgres + pgpool-ii: error without log

I use pgpool-ii 3.2.1, php 5.3.3-7+squeeze14, postgresql 8.4.13. I have some trouble with an insert query made by PDO, but I don't understand where the problem is because no log was written (postgres, apache2, pgpool-II). The query is very simple,…
rvandoni
  • 3,297
  • 4
  • 32
  • 46
2
votes
2 answers

What permissions does the health_check_user for pgpool-II need?

I'm confused about a point of pg_pool-II's documentation. The health_check_user is used to determine the health of DB cluster servers, but what abilities does the health_check_user need? As there are no configuration options to get a password for…
troutwine
  • 3,721
  • 3
  • 28
  • 62
2
votes
1 answer

PostgreSQL Default Result Limit

I'm using Grafana and PostgreSQL 13 for visualizing. There are many users in the Grafana and they could send queries to their own databases. I need to set a default result limit for sent queries. (Like 1000) But I couldn't find a solution. I…
enesgur
  • 35
  • 9
2
votes
2 answers

How to keep long lived connection alive even when the Kubernetes pod get killed?

I have the following architecture for the PostgreSQL cluster: Here, there are multiple clients that interacts with PostgreSQL pods via pgpool, the issue is, when the pod (could be pgpool or PostgreSQL pod) terminates (for multiple reasons) the…
Vishrant
  • 15,456
  • 11
  • 71
  • 120
1 2
3
…
14 15