pgpool is a middleware that works between postgresql servers and postgresql clients

learn more… | top users | synonyms

2
votes
1answer
1k views

pgpool2+streaming replication failover on only 2 servers?

I am trying to configure pgpool2 and postgresql 9.1 to handle failover. I currently have streaming replication running, and are using pgpool2 for read-only load balancing. I have 2 servers in my ...
1
vote
1answer
214 views

pgpool shm_exit(0)

I'm trying to set up pgpool-II on centos-5.4 For whatever reason pgpool-II fails silently when I try to start it up. I can't seem to find a log file in the default /tmp dir or in /var/log. Can anyone ...
0
votes
1answer
112 views

pgpool run and only log one line

I am using pgpool and when I run: sudo pgpool -f pgpool.conf -F pcp.conf -n It just log one line and keep waitting.... : 2014-10-09 13:27:42 LOG: pid 28626: wd_chk_setuid: ifup[/sbin/ifconfig] ...
-1
votes
1answer
319 views

pgpool-ii show server as down, but server is running fine

I am using postgres 9.2 with streaming replication. I have 1 master DB and 2 standby DBs, it's hosted on amazon EC2, each has it's own server. On separate server i have pgpool(3.2.3) that does load ...
0
votes
0answers
51 views

pgpool2 parallel mode: Non-superusers must provide a password in the connection string

I have two AWS RDS postgres nodes backing a parallel mode pgpool setup on EC2. After using pgbench to populate test tables, I get odd behavior from test queries. Any query that uses a function ...