middleware between PostgreSQL servers and clients for connection pooling, replication and load balancing

learn more… | top users | synonyms

2
votes
2answers
2k views

pgpool replication not allowing md5 authentication

I have installed both pgpool and postgresql via apt. In pgpool.conf, I have made the changes necessary to use replication mode, as well as my two postgresql databases (currently all running on the ...
2
votes
1answer
2k views

PgPool 2 with HA Proxy

So, I'm looking to add high availability to a postgresql server. I've looked into some tutorials on the web but, haven't been able to find exactly what I'm looking for. E.g.: PostgreSQL ...
1
vote
1answer
302 views

pgpool-II doesn't execute my failover script

I have been installed pgpool-II 3.3.4 from source. I have two pgpool nodes and I also used the watchdog configuration to get a pgpool services with High Availability. When I stop one, the other wake ...
1
vote
1answer
45 views

Understanding pg-pool in details

I have following problem regarding the pg-pool (3.3.3) When master fails, automatic failover happens and standby is promoted to master. But this new master don't have any replicators. Other slave ...
0
votes
1answer
272 views

Pgpool II : unable to read message length between two network interfaces

Start log file: 2015-03-06 01:57:56: pid 2760: LOG: Setting up socket for 0.0.0.0:9999 2015-03-06 01:57:56: pid 2760: LOG: Setting up socket for :::9999 2015-03-06 01:57:56: pid 2760: LOG: ...
0
votes
1answer
51 views

PgPool fails to auth in master_slave mode

We have two PostgreSQL servers running in master-slave streaming replication mode, behind pgpool. When we activate master_slave mode in pgpool.conf, we get following error: do_md5 failed in slot 1 ...
0
votes
1answer
428 views

pgpool2 not working on my Ubuntu i686 athlon i386 GNU/Linux

I am trying to implement replication and load balancing on my Ubuntu i686 athlon i386 GNU/Linux.for creating database clustures I have installed postgresql contrib 9.1.11 having initially database ...
0
votes
1answer
801 views

pgpool2 setup on master-slave replication using postgreql 9.1

I have already setup 2 ubuntu server 12.04 LTS on my local machine using virtual box and is using the master-slave replication (postgresql 9.1). 192.168.0.109 = master 192.168.0.110 = slave my ...
0
votes
1answer
662 views

pgpool-II configuring multiple master databases

I could not find a solution for this anywhere, not even in the pgpool manuals. How do I configure multiple - master postgresql databases with pgpool-II? Additional requirement is that each master ...
3
votes
0answers
390 views

Poor performance in my pgpool cluster

I've configured a postgres cluster with pgpool2 using the following link. The replication seems to be ok, but I ran some benchmarks (pg_bench) and the performance is lower than a single node, for ...
1
vote
0answers
50 views

Master/Slave - streaming replication restrict function to master

How can I run a function a on master only? I don't want to connect directly to my master server, because the master server might change. Or can I change my function to work on this setup? Because ...
1
vote
0answers
83 views

Pgpool load-balancing vs. consistency

In what ways is consistency weakened when using pgpool-II load-balancing on Postgresql servers running streaming replication? Obviously with asynchronous replication you can insert a row on the ...
1
vote
0answers
101 views

how to get pgpool2 HA

I am using pgpool2 and PostgreSQL to get a HA of postgresql service. I have been working in this: .-----. .--------. | | W | DB | | PGP ...
1
vote
0answers
32 views

Does pg-pool-II support two phase commit?

When pg-pool II is used with sharding, what happens if I want to do a transaction which involves two nodes ? Does pgpool support two phase commit ?
1
vote
0answers
219 views

pgpool stability issues

I am using pgpool-II 3.3.1 to load balance connections to my postgres 9.3. I am experiencing an ocassional stability issue where clients are not able to connect to pgpool (but they are able to connect ...
1
vote
0answers
738 views

PgPool is pushing Postgres to 100% cpu usage

I think I've followed the configuration for pgpool correctly, but he's pushing my postgres machines to 100% cpu usage unnecessarily. I have one pgpool machine that works just fine, no overload at all, ...
1
vote
0answers
307 views

Postgresql Streaming Replication - pgpool2 - failover

In my scenario I want pgpool to forward read only queries to slaves when the master goes down - I want my app to be in the "read only mode". How do I setup pgpool to accept read only queries when ...
0
votes
0answers
62 views

Online Recovery for pgPool-II “cannot find xlog functions”

I am trying to set up Online Recovery for pgPool-II [Replication,Load Balancing, Connection Pooling] modes enabled. I followed the sample provided on the pgPool-II website for the PITR recovery ...
0
votes
0answers
98 views

Failover_command in pgpool is not working?

I have setup the pgpool with load balancing and failover mode. Following is my failover_command='/usr/local/etc/failover.sh %d %P %H %R' The following is the script: !/bin/bash -x FALLING_NODE=$1 ...
0
votes
0answers
127 views

Is Automatic failover is possible in pgpool?

I have setup the 2 PostgreSQL 9.4 severs with master-slave(Hot standby streaming replication).Is this possible in pgpool-II 3.4 to configure,where it works for automatic failover(network or hardware ...
0
votes
0answers
166 views

can Pgpool Work With Multi-master replication in PostgresPlus 9.3 AS?

My query is I have One application server and two database servers(multi-master setup with xDB-replication). Now How can i Connect to two different databases servers having different Ipaddress,Port ...
0
votes
0answers
57 views

What should be the ideal network configuration for a Postgresql Streanming Replication and PgPool HA setup

I have the following configuration using Pgpool, Postgresql with streaming replication. Pgpool is used for load balancing and automatic failover. .-----. .--------. | | ...
0
votes
0answers
472 views

pgpool-II Master Slave mode / Load Balance Mode / Watchdog On result many primary servers

I installed pgpool-II in Centos6.5, Master Slave mode / Load Balance Mode / Watchdog On but three postgresql servers are all primary server, shows as below: IP Address Port Status Weight ...
0
votes
0answers
129 views

pgpool authentication failed when use syslog in log_destination

When I configure in pgpool.conf file: log_destination = 'stderr' pgpool run ok, but when I use this configuration: log_destination = 'syslog' I get this error: pgpool pgpool[21477]: pcp_child: ...
0
votes
0answers
180 views

how to change the backend order in pgpool

I want to change the backends order in pgpool. I want to keep my master host always as the first backend. I have been configure the failover command: NEW_MASTER_INFO=($(PcpNodeInfo ...
0
votes
0answers
48 views

What is the recommended pgpool mode?

I'm trying to determine which pgpool mode to use (http://www.pgpool.net/docs/latest/pgpool-en.html#config). In order of importance my requirements are: All nodes accessible via shared public ...
0
votes
0answers
62 views

when install pgpool is also needed install hearbeat and watchdog

I am trying to get the PostgreSQL services High Availability (HA) and then I am using pgpool-II. When I install and configure pgpool, the WATCHDOG section seems to doesn't works, then I have a ...
0
votes
0answers
222 views

could not connect to pgpool server

I am configure my pgpool server to allow access from: host all all 0.0.0.0 trust The service pgpool is running: user@pgpool:~$ sudo service pgpool2 status * pgpool-II is running. ...
0
votes
0answers
130 views

Using a Virtual IP for pgpool instances doesn't work

I did a configuration of my pgpool instances, I am using a virtual ip address, delegate_IP = '192.168.1.100' <-- floating IP address ifconfig_path = '/sbin' if_up_cmd = 'ifconfig eth1:0 inet ...
0
votes
0answers
62 views

“kind does not match” after failover

We are using pgpool-II 3.3.3 with 4 nodes of Postgres 9.3. At some point today 2 of the 4 nodes had errors and pgpool did a successful failover. When the 3rd node had errors pgpool also reported a ...
0
votes
0answers
1k views

Stress-test PostgreSQL 9.2 and pgpool

i am experiencing some trouble testing Postgres cluster and load balancer on pgpool. I i wrote script script.sh on bash which asynchronously uses Postgres testing tool pgbench causing number of ...
0
votes
0answers
521 views

Multiple PostgreSQL running as primary server on pgpool

I'm facing a problem with my pgpool setup. Currently, this is my requirement based on the pgpool documentation here : Server A : Install with PostgreSQL database. Run as primary server Server B : ...