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

pgpool failover command issue

After staring two postgres nodes (node 0 primary and node 1) and setting pgpool. Pgpool failover command by default takes node0 as primary. My question is if failover occurs and make node 1 as primary and after some time if failover occurs on node 1…
venky
  • 1
0
votes
1 answer

postgres redirect queries to standby?

I am trying to create a connection pooling system with load balancing. From what I unsderstand PGbouncer doesn't have a load balancing option and all I can do is to create a file with all the users+pass and configure the dbs/clusters. but in this…
hello
  • 11
  • 1
0
votes
1 answer

Solr Importing database field issues . how to I use postgres pgpool connection?

I am using postgres database and pgpool . Postgres database port : 5432 is woking fine. But I am using Pgpool port : 9999 is Not Working. MY importing xml file (myproduct.xml) Working
Saran
  • 3
  • 1
  • 4
0
votes
0 answers

Multiple bitnami pgpool-II container

Need clarification if this is doable. I have successfully ran Postgres with 2 containers namely master and slave. I would like to know if I can run more than one pgpool container ? If yes, is there any specific environment variables i need to…
jlim
  • 909
  • 2
  • 12
  • 24
0
votes
1 answer

Pgpool fails to start on kubernetes as a pod

I have hosted pgpool on a container and given the container config for kubernetes deployment - Mountpaths - - name: cgroup mountPath: /sys/fs/cgroup:ro - name: var-run mountPath: /run And Volumes for mountpath for the cgroups are mentioned…
Joy
  • 6,438
  • 8
  • 44
  • 75
0
votes
0 answers

pgpool second standby shows "down" in status

I have setup pgpool with 3 nodes. Lets say node1 as primary and node2,node3 and secondary. When I stop the database service on node1, the node2 becomes primary as expected but node3 is being shown as "down" in show pool_nodes command. It is showing…
makhshif afiniti
  • 55
  • 1
  • 8
0
votes
1 answer

Pgpool-II: Delegated IP is not available when disconnected Primary or Standby Node Failed

I'm trying to setup postgres cluster of two nodes (primary and standby). In order to activate automatic failover, I'm using pgpool-II. I followed the following article: https://www.pgpool.net/docs/41/en/html/example-cluster.html and the only thing…
Belokonev Alexnadr
  • 71
  • 3
  • 10
0
votes
1 answer

Can't Connect on postgresql pgpool "invalid backend response. Response does not replied with "R"

I'm trying to connect on My pgpool install (3 Nodes) I'm using a virtual IP adress to connect to my master server. If i reach directly Postgresql, it works: psql -h *virtual IP* -U postgres -p 5432 but as soon as i try psql -h *virtual IP*…
Rakath
  • 1
  • 3
0
votes
1 answer

Master - Master setup on Postgresql 10 + Ubuntu 18.04 + Pgpool II

Does anybody have experience in configuring Pgpool II with Postgresql 10 on Ubuntu 18.04? I am trying to setup Master - Master setup on Postgresql 10 + Ubuntu. I am trying to use Pgpool II I will have two or more mater DB servers running on…
Umanda
  • 4,737
  • 3
  • 23
  • 28
0
votes
2 answers

pgpool-II Session to Watchdog Delegate Ip Terminated When Either Primary or Standby Node Failed

I'm trying to setup postgres cluster of two nodes (primary and standby). In order to activate automatic failover, I'm using pgpool-II. I followed the following article: https://www.pgpool.net/docs/41/en/html/example-cluster.html and the only thing…
dani
  • 33
  • 1
  • 4
0
votes
1 answer

pgpool 4.1.0 healthcheck getsockopt() detected error "Connection refused"

I am trying to setup a pgpool loadbalancer for a Postgresql streaming replication cluster. I am using postgresql-12 and pgpool2-4.1.0 from the Postgresql repo https://apt.postgresql.org/pub/repos/apt/ on Debian 10.2 (latest stable). I have setup…
R.Giskard Reventlov
  • 1
  • 3
0
votes
1 answer

Kubernetes postgres replication with pgpool

Trying to deploy postgres in kubernetes (https://github.com/paunin/PostDock/tree/master/k8s/example2-single-statefulset), Used pgpool-II(2 replicas) along with 1 postgres-master pod & 2 slave pods. kubectl get pods -n postgres NAME …
Sandy
  • 946
  • 11
  • 14
0
votes
1 answer

JAXRS Service using Vert.x

I'm implementing a JAX-RS Service in an Application Server using Vert.x to store data in combination with Vert.x Pg pool. Storing data is quite straightforward as there's nothing to return to the client. However when it comes to a HTTP GET Request…
Carla
  • 3,064
  • 8
  • 36
  • 65
0
votes
1 answer

pgpool2 ip_up config error: socket(::) failed: "Address family not supported by protocol"

I am trying to configure the if_up_cmd in pgpool.conf while setting up a prod cluster of PostgreSQL 9.5.14 along with pgpool 4.0.4. Config I am trying to use for this is : 'ip_w addr add $_IP_$/32 dev ens192 label ens192:0' I am aware that RHEL7+…
user3792812
  • 155
  • 1
  • 4
  • 13
0
votes
1 answer

Create failover postgresql cluster if you have 2 virtmachine without load balancing server

Whats recommendation can you give me on setting up a database failover postgresql cluster? I have only 2 virtual machine. Right now i read this https://wiki.clusterlabs.org/wiki/PgSQL_Replicated_Cluster I have some questions about it: Where is it…
Hansolos
  • 1
  • 1
1 2 3
…
14 15