All Questions
Tagged with postgresql-9.1 pgpool
4 questions
4
votes
1
answer
4k
views
timeline 2 of the primary does not match recovery target timeline 1
I want to create a configuration with postgresql and pgpool to get height availability (HA). I want to do this:
.-----. .--------.
| | W | DB |
| APP |---...
- 705
4
votes
2
answers
9k
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 ...
- 141
1
vote
1
answer
2k
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 ...
- 11
1
vote
0
answers
459
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 ...
- 211