middleware between PostgreSQL servers and clients for connection pooling, replication and load balancing
1
vote
0answers
39 views
PGPool Frequent Queries
We recently setup a PostgreSQL Cluster with PGPool in front of it. This is our first go at such a thing. We setup our QA environment to use the new PGPool, and we cranked up the logging on the ...
0
votes
0answers
147 views
multiple postgreSQL running as primary server on pgpool
I'm facing 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 : ...
0
votes
1answer
856 views
Pgpool install - libpq is not installed or libpq is old
Based on the documentation here, I want to create a pgpool II with PostgreSQL databases. When I try to install, I encounter this error:
configure: error: libpq is not installed or libpq is old
...
4
votes
1answer
229 views
How large should my pool size be? And should I use pgbouncer?
I have a Rails application with 4 Unicorn workers. How do I determine what postgresql database pool size I should use?
And if I have 6 applications connecting to this postgres database, would that be ...
4
votes
1answer
185 views
Can you make SSL and SSL-only (hostssl) connections to PGPool?
The new version of PGPool (3.2) has an "SSL" section in the conf file, and directions on how to use it in the manual. However, pool_hba.conf specifically says that PGPool doesn't support SSL (i.e. ...
3
votes
1answer
698 views
Pgpool, Postgresql and Apache tuning (1000 concurrent spatial queries)
I'm trying to configure a load balancing system.
I've a python script, invoked through mod_wsgi on Apache, that generates a query and executes it on pgpool: request-> wsgi python -> pgpool -> ...
2
votes
1answer
116 views
How not to distribute reads in pgpool
I want to use pgpool to replicate one database to another. I want to do my processing on my master database (reads/writes/inserts/deletes), replicate that database to another database as it is ...
6
votes
2answers
1k views
Streaming replication and failover on PostgreSQL
I am doing a proof of concept on PostgreSQL replication. After the discussion on forum we decided to go with streaming replication as the performance is good compared to other solutions. PostgreSQL is ...
2
votes
1answer
193 views
pgpool connect failed: No such file /tmp.s.PGSQL.0 replication mode = true
Setup: I have two instances of Postgres 9.0.3 and pg_pool 3.14 all running on the same Ibuntu (10.04) machine and am attempting to evaluate pgpool.
I can attach to pgpool using psql -p <pgpool ...
2
votes
1answer
367 views
Does the pgpool-II extension allow for parallel execution of any query?
I read about pgpool-II here and it states that:
Using the parallel query function, data can be divided among the multiple servers, so that a query can be executed on all the servers concurrently ...
2
votes
1answer
488 views
Pgpool-II: sequences advanced by 1 after PITR recovery
I have tested pgpool-II 3.0.1 and pgpool 3.0.4, PostgreSQL 8.4
In both cases I'm getting the same result: after online recovery on primary and target nodes all 'serial' values got "+1". Other nodes ...
3
votes
2answers
597 views
Removing Archive Logs after PostgreSQL PITR online-recovery
I'm using pgpool-II + PostgreSQL 8.4 on three servers: primary + standby1 + standby2.
Replication mode is "on"
Load balance mode is "on" (between primary and standby1)
I followed the official ...
