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
0
votes
1 answer

using pgpool, i got empty value in replication state

I'm trying to use pgpool to postgres HA. node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_bala nce_node | replication_delay | replication_state | replication_sync_state |…
hyungs
  • 1
  • 1
0
votes
1 answer

High Level DR Drill Steps for a PostgreSql clustered setup

I'd like to have some advice on the steps I have to follow to conduct a DR drill for below PostgreSQL setup. Environment Setup I have 2 PostgreSQL servers in my production environment which are clustered using pgpool. ( reference:…
Shan Siriwardana
  • 73
  • 1
  • 5
0
votes
0 answers

PGPool Failover

We have a high available database architecture that contains PGPool cluster with 3 instances, and at the backend PostgreSQL database cluster with 2 instances. Our PostgreSQL and PGPool versions are, respectively, PostgreSQL 10.17 and pgpool-II…
Umut TEKİN
  • 856
  • 1
  • 9
  • 19
0
votes
1 answer

How to configure pgpool with repmgr to make node information sync?

I am trying to configure pgpool with postgresql and repmgr. But after configuring that I found it is not working as expected. When I switchover standby to primary using repmgr it is working expected but at pgpool primary connection info not…
Sheikh Wasiu Al Hasib
  • 450
  • 5
  • 18
0
votes
0 answers

Pgpool standby server's status is "down" some time after starting replication with online recovery

I have setup a 2 server cluster system using this configuration examples. They are in the same LAN. Master is node 0 on 192.168.1.31, slave is node 1 on 192.168.1.32. The problem is that approximately 10 minutes after I started streaming…
Ozan Başkan
  • 51
  • 1
  • 7
0
votes
0 answers

How to stop postgresql PGPOOL replication

I'm trying postgres database backup and restore. The access to postgres is through pgpool. To achieve the back up I am following the official postgres pg_dumpall documentation. Commands taken from postgres website:…
Ninja Flinstone
  • 21
  • 1
0
votes
1 answer

Show specific column from pool_nodes

i'm running show pool_nodes and it's work. What if i want to return just the 4th column(status), using only query. It is possible ? Thanks
Matei Munteanu
  • 23
  • 2
0
votes
1 answer

Pgpool failing to connect to standby postgres server

I'm working on a postgresql HA setup and running into an issue with pgpool. I'm using built in postgres streaming replication and pgpool to monitor the cluster and initiate the failover process. Pgpool has no trouble connecting to the master…
Viettel Solutions
  • 1,519
  • 11
  • 22
0
votes
1 answer

pgpool node detached for no reason?

I have a two-node PostgreSQL cluster running on VMs where each VM runs both the pgpool service and a Postgres server. due to insufficient memory configuration the Postgres server crashed, so I've bumped the VM memory and the changed Postgres memory…
Noam Yizraeli
  • 4,446
  • 18
  • 35
0
votes
1 answer

unable to get results from postgres in nodejs if callled from nested function

I have DB class which has public static query method. There can be multiple connection pools saved in _coonection_pools so I am creating a random number then get the pool and execute the query . this is the code static async query(queryInfo: Query):…
Sunil Garg
  • 14,608
  • 25
  • 132
  • 189
0
votes
0 answers

How to create High Availability cluster with PostgresSQL on Windows Server 2016

I am trying to create an HA environment with PostgresSQL server. I have two nodes with Windows Server 2016 installed on it. Due to client limitations we cannot use Linux servers and I am tasked with creating an HA environment for Postgres SQL. Can…
Pankaj Dalvi
  • 93
  • 5
0
votes
1 answer

Is there any best practice to make audit of Spring Rest application?

I have to improve performance of spring boot app, which is quite classical rest API + hibernate + postgres. we have 250k active users and want to extract some requests to be on slave balanced instances, and probably cache some data. For now i have…
Yevgen Kulik
  • 5,713
  • 2
  • 22
  • 44
0
votes
1 answer

How pgpool handle concurrent sql query if they are the same?

In my case, it's possible that a lot of the same SQL query happen at some moment, so I want to ask that if this thing happens, how pgpool handle it? Will pgpool request a lot of the same querys to the backend postgresql server or it will queue all…
Dean Chen
  • 91
  • 3
  • 5
0
votes
1 answer

pgpool for high availability of rds postgres

RDS Aurora for PostgreSQL Cluster has a writer and 2 reader nodes. When there is huge write activity and when reader node lags in catching up to those changes, aurora stops reader node(s) – catches up to the updates and starts the instance. This is…
nmakb
  • 1,069
  • 1
  • 17
  • 35
0
votes
1 answer

Is it possible to use Pgpool-II just for Load Balancing not for connection pooling?

We have a PostgreSQL 12 cluster with one master and two slave nodes. We are using Pgpool-II to load balance our SQL queries to our cluster. Our write queries go to the master and read queries go to the slave nodes. We have a new Java application…
cgon
  • 1,955
  • 2
  • 23
  • 37
1 2 3
…
14 15