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
2
votes
0 answers

Postgres basebackup - cannot execute SQL commands in WAL sender for physical replication

Good Morning all, I have an HA setup consisting of 2 Postgres servers with pgpool on top of them. The setup is working fine. I am trying to replicate data of this cluster to a third Postgres server(outside the current cluster) using the…
Striker
  • 67
  • 7
2
votes
1 answer

How to reload pool_hba.conf in pgpool without restart?

How can we reload pool_hba.conf after a config change, is there a way without restarting?
Rahul
  • 895
  • 1
  • 13
  • 26
2
votes
0 answers

What is this "failed to authenticate" error when starting pgpool?

I have configured two EC2 instances, one running postgres, and one running pgpool in hopes of leveraging pgpools connection pooling capabilities. As part of my config for pgpool, I set the auth-method in both my pg_hba.conf and my pool_hba.conf to…
CharStar
  • 427
  • 1
  • 6
  • 24
2
votes
1 answer

pgpool lost master after pcp_attach_node

I have 3 Postgresql DB nodes (node0, node1, node2, version 9.4) and 1 pgpool node (version 3.7) Step 1: 1.1) node0 is primary, node1 and node2 are standby. 1.2) "show pool_nodes" and "select * from pg_stat_replication" works as expected. 1.3)…
xudesheng
  • 1,082
  • 11
  • 25
2
votes
1 answer

Replicate via pglogical on a hot_standby setup

I am running two databases (PostgreSQL 9.5.7) in a master/slave setup. My application is connecting to a pgpool instance which routes to the master database (and slave for read only queries). Now I am trying to scale out some data to another…
Youri
  • 81
  • 4
2
votes
1 answer

PgPool2 load ballance

I have 2 PG servers, one master, the other one slave - normal stream replica that works great. I need to put pgpool before them, that would make the load balancer on both machines - just select queries, because of the high traffic. But as I…
Jiří Bendl
  • 21
  • 3
2
votes
1 answer

PostgreSQL performance tuning and max connections (practically)

For the past few weeks I've been tuning and messing with PostgreSQL which I'm going to use with my next project. My Specs are: DigitalOcean 8 Cores 16GB SSD x2 (One for DB, another for Web) Centos 7 PHP5 , Nginx The things that I've…
Lim SY
  • 175
  • 2
  • 15
2
votes
0 answers

Equivalent of pgpool-II for MySQL

Is there any tools which is equivalent to pgpool-II (which is for PostgreSQL) for MySQL db? Of particular importance for me is the feature - Load Balalce Load Balance If a database is replicated, executing a SELECT query on any server will …
Srikar Appalaraju
  • 71,928
  • 54
  • 216
  • 264
2
votes
1 answer

Issue with pgpool 3.5.4 and JDBC

I have a pgpool 3.5.4 with memcache enabled, and I use it to connect to Redshift. I wrote two simple programs, one in Java (JDBC postgresql-9.4.1212.jre6.jar) and another one in Python (using psycopg2 postgres package) that just connects to pgpool,…
Felipe Garcia
  • 2,263
  • 1
  • 16
  • 19
2
votes
3 answers

How do I get pcp to automatically attach nodes to postgres pgpool?

I'm using postgres 9.4.9, pgpool 3.5.4 on centos 6.8. I'm having a major hard time getting pgpool to automatically detect when nodes are up (it often detects the first node but rarely detects the secondary) but if I use pcp_attach_node to tell it…
vmos
  • 109
  • 1
  • 2
  • 10
2
votes
1 answer

No load balance comment in Java Hibernate Query

We are using pgPool in our Java project to do load balancing in our Postgres database. pgPool sends read only queries to slave servers and write queries to the master. That is ok. But there are very specific cases in our application when we need the…
computeiro
  • 583
  • 5
  • 6
2
votes
1 answer

primary lagging behind recovery in postgres streaming replication

I was doing a streaming replication between 3 nodes of postgresql-9.5 . 1 master and 2 slaves I was trying to configure auto failover but when i switched back to my original master, and restarted the postgres service, I am getting the following…
subhojit_paul
  • 31
  • 1
  • 5
2
votes
1 answer

Pgpool prints "unable to parse query" to certain more complex queries

I'm using one pgpool server and 2 RDS servers in load-balance master-slave mode. It's all going well but I have this one problem i can't find a solution. I have one query that does only SELECTs with a some joins and etc. However, when I execute this…
Guilherme Rodriguez
  • 184
  • 1
  • 12
2
votes
1 answer

pcp_attach_node gives EOFError in pgpool

I have successfully setup replication for my Postgres database using pg_pool. Then I stopped the master server and checked the pool status. It is as like below postgres=# show pool_nodes; node_id | hostname | port | status | lb_weight | role …
Priyesh Karatha
  • 604
  • 5
  • 18
2
votes
1 answer

Multiple pgpool-II on same Postgres instances

Can you run multiple instances of pgpool-II on same Postgres databases? My idea that I want to have really redundancy, so if pgpool-II went down, I can easily access another one without any downtime, data loss as databases will still be running. Do…
Tom
  • 363
  • 7
  • 17
1 2 3
…
14 15