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

Issues in reading data from postgres DB 9.3 using pgpool version 3.3.1

We are using jdbc to connect to postgresql 9.3 database through pgpool. When we are trying to read the data sent from DB in java, sometimes data is read properly and sometimes we are getting this exception.…
Abhraneel
  • 1
  • 1
0
votes
2 answers

Replication in PgPool2

Anyone help me with this, I want to replicate postgresql data using pgpool in one Vm with other two Vm’s. I am new to this field I installed postgresql-9.3 in three Vm’s and pgpool-II in one Vm’s. Now I want to know how to replicate data between…
Pal
  • 1
  • 2
0
votes
0 answers

Migrate and update data when switch master and slave database postgres

I'm working on postgres replication and pgpool2, it works ok. Suppose that, I have one master and two slave servers, when master(1) down, pgpool will promote one of two slave servers to master(2). So, my issue is the time when I stop master(1)…
Trung Huynh
  • 293
  • 1
  • 5
  • 13
0
votes
0 answers

PgPool-II : "max_wal_senders = 0" on new master after failover

I installed PgPool-II and nodes on Debian virtual machines. I followed instructions written in the user manual. I enabled streaming replication, failover and online recovery features. Here is my network configuration : 192.168.1.111…
Antonin
  • 181
  • 2
  • 11
0
votes
0 answers

Heroku postgres pgpool-II support for read only query load balancing

TL:DR Does Heroku support pgpool-II for master-slave read only load balancing? Other solutions? We are planning to go live with our application on heroku within the next couple of months. The biggest potential scaling hurdle at the moment for us is…
Andrew Potapov
  • 542
  • 8
  • 18
0
votes
0 answers

PostreSQL with PgPool running extremely slow

I'm running tests on PostgreSQL to see if it would be a feasible replacement for MySQL on a rather busy server. I have the following configuration: POSTGRESQL max_connections = 10 PGPOOL num_init_children = 8 max_pool = 100 I have a feeling my…
Kate
  • 712
  • 3
  • 6
  • 23
0
votes
1 answer

pgpool postgresql ec2 instance

I am trying to setup pgpool2 with postgresql. I have both on different ec2 instances. I am going through the tutorial and I am trying to create a database with createdb -U -p -h bench_replication It then prompts me…
user1802143
  • 14,662
  • 17
  • 46
  • 55
0
votes
0 answers

Can not write to PPAS logfile

Now, I am testing query from application to PPAS via PgPool. When I query select a.name, b.name from tb_01 a, tb_02 c where a.id = b.id_ref ... or update/insert, I have to wait for a long time (30 --> 60 seconds). I check in my PPAS log file…
Luan Huynh
  • 358
  • 4
  • 20
0
votes
1 answer

replicate specific partition or tablespace in postgres

I am considering a scenario where different partitions/tablespace are replicated on different slaves. Is it possible to achieve this? If so, by which possible schemes. Thanks.
Kabira K
  • 1,916
  • 2
  • 22
  • 38
0
votes
1 answer

pgpool connections get frozen

I have installed pgpool 3.2.1 with 2 backends in streaming replication mode with load balancing and connections pool.I did some high load tests tring to colapse the pgpool connections. Suposing that this rule is correct : max_pool*num_init_children…
catacs
  • 191
  • 7
0
votes
2 answers

pgpool can't create database

I have started the pgpool using the command sudo pgpool -n & it started giving the following message on the terminal: 2012-05-04 10:54:29 LOG: pid 4109: pgpool-II successfully started. version 2.3.2.1 (tomiteboshi) But when I try to run the…
Abhishek Sagar
  • 1,189
  • 4
  • 20
  • 44
0
votes
1 answer

SSH command in a bash script isn't run when the script is executed by an application

I'm using PG pool, which executes a failover script when a database node goes down. The script needs to touch a certain file on the new master and make some changes on the old master. It works fine when I run it, but it doesn't when run by the…
user705142
  • 461
  • 5
  • 18
0
votes
2 answers

pgpool2 cannot rejoin faild master as the new slave

i have a pgpool2 3.1.3 installed with 2 postgresql 9.1.3 backend configured as master/slave with streaming replication. If the master fails everything is ok, the slave takes over and becomes the new master. The problem is that if i want to rejoin…
Videanu Adrian
  • 972
  • 3
  • 16
  • 41
-1
votes
1 answer

Install Pgpool on a server different from the DB server

I have 3 server (PgPool-II installed) and 2 Db (PostgreSQL installed) server. I followed https://www.pgpool.net/docs/43/en/html/example-cluster.html But can't execute psql template1 -c "CREATE EXTENSION pgpool_recovery" What can i do? Is it possible…
Jae
  • 3
  • 3
-1
votes
2 answers

PgPool Load balancing for Java/JDBC application

After setting up all the possible settings of PgPool on CentOS, when I tested it using my Java application, I found that it is not working. After reading manual on internet (you can find here), I found that it will not work for JDBC statements if…
Naved
  • 4,020
  • 4
  • 31
  • 45
1 2 3
…
14
15