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
1
vote
0 answers

How to do Loadbalancing with BDR

I'm planning to use BDR (by 2ndQuadrant) in my Database Environment to achieve a multi master cluster for my PostgreSQL Database. Since i would have many nodes in my cluster and all able to read & write i want to make the cluster transparent to its…
RootOfProblem
  • 357
  • 1
  • 3
  • 11
1
vote
0 answers

PGPool Config reload with watchdog

I have a Master/Slave pgpool set-up with watchdog. I'm trying to reload PGPool config (pgpool.conf) file with some changes whenever a backend failover happens. I'm able to reload the config only in the pgpool instance that runs the failover script .…
Sahana
  • 53
  • 1
  • 6
1
vote
0 answers

Virtual IP for PGPool 2 not working

I am currently following this guide to setup a PG HA cluster. https://www.itenlight.com/blog/2016/05/18/PostgreSQL+HA+with+pgpool-II+-+Part+1 The problem I am having is the Virtual IP for the cluster doesn't get added in my network interfaces. I…
RyterINC
  • 104
  • 1
  • 12
1
vote
0 answers

load balancing using pgpool vs rails octopus?

Recently we thought of using Heroku postgres Follower/slave database for our read requests. Now I am confused between the below 2 approaches. Use octopus rails gem to load balance between various slaves/followers. Using pgpool for load balancing.…
Deepak Kumar Padhy
  • 4,128
  • 6
  • 43
  • 79
1
vote
0 answers

How to perform a synchronous query with pg-pool?

I am trying to create a method for a synchronous query. I'm using pg-pool and asyncawait, but I throw the following error: "Error: await functions, yield functions, and value-returning suspendable functions may only be called from within a…
Alexander Gallardo
  • 33
  • 1
  • 5
1
vote
0 answers

Pgpool directing write queries to standby postgres database?

I've got two centos 6.5 servers running postgres 9.4.10 with repmgr and pgpool 3.4.5. For the most part they seem to work fine, but with some tests I get errors in the logs like < 2017-01-24 18:47:14.588 GMT >STATEMENT: SELECT obj.* FROM…
vmos
  • 109
  • 1
  • 2
  • 10
1
vote
0 answers

pgppol2 sends write to both master and slave

I have in issue with pgpool2 and cannot figure out why!!!! my setup is as follows: singe pgpool to do LB for me master slave postgress The issue is as follows, when i send read queries via the pgpool everything is fine, load get distributed between…
mili
  • 11
  • 3
1
vote
1 answer

Automatic recovery of the failed postgresql master node is not working with pgpool II

I am new to Postgresql and Pgpool II setup. I have configured the Postgresql HA/Load balancing using Pgpool and Repmgr. The setup consist of 3 nodes and verison of Application and OS is as mentioned below: **Pgpool node** => 192.168.0.4,…
yravi104
  • 23
  • 1
  • 3
1
vote
1 answer

pgpoolAdmin could not be able to proceed after step 2

I am currently configuring Postgres pgPoolAdmin. . How I can correct?
Titus Rakkesh
  • 31
  • 3
1
vote
2 answers

POSTGRES REPLICATION for new master

We are putting together an architecture to support High Availability for our Postgres 9.5 Database. We have 1 master and 3 slaves Replicating the data of the master. When The master goes down Slave 1 is promoted to new master but Slave 2 and Slave…
subhojit_paul
  • 31
  • 1
  • 5
1
vote
1 answer

pgpool-ii in master/slave mode: How can I most easily trigger a failover?

So I am testing some toy postgresql infrastructure with some local virtual machines to determine how pgpool behaves on failover. I've configured a rudimentary setup where I have two database machines (192.168.0.2 and 192.168.0.3) and a pgpool…
gdoug
  • 715
  • 1
  • 5
  • 16
1
vote
0 answers

Postgresql master node fail after restart with pgpool

I set up pgpool (master-slave mode) + postgresql streaming replication. Then I check the correctness of failover_command. If I turn off the network master node, then pgpool waits specified time, if the master node during this time is not responding,…
alexbel2404
  • 41
  • 1
  • 1
  • 4
1
vote
1 answer

Master slave delay(activate synchronous commit) and pg_xlog in a separate disk

We are preparing to add repmgr to an existant Postgresql 9.3 two nodes streaming replication cluster. Previously we had a serious problem that affected our main business, the problem was the delay between master and slave, which we resolved by…
adilnaimi
  • 209
  • 2
  • 4
1
vote
1 answer

Sqlalchemy and pgpool-II - OperationalError

Today I set up pgpool-II on one of my company servers for database replication purposes and I'm trying to connect to it from my application located on another server. Previously it connected to database on the same server where pgpool is now…
Dev Kośnik
  • 41
  • 1
  • 8
1
vote
1 answer

can you run two pgpool instances on a single host?

Is it possible to run two pgpool instances on a single host? We're working through configuring that now, just wanted to check that there's no commonly known "oh, no that will never work" out there.
Kevin G.
  • 1,424
  • 1
  • 13
  • 22
1 2 3
…
14 15