All Questions
4 questions
0
votes
2
answers
156
views
Does my master server crash using Log-Shipping Synchronous Replication in Postgresql when the replica is down?
I'm searching for HA solutions without load balancing in the master-slave model, using postgresql. My favorite solution so far is log shipping synchronous replication. But I have one main concern, and ...
0
votes
1
answer
895
views
Postgres HA - Warm standby server lagging
We have recently implemented high availability for our postgres (9.0.4) DB server, through the methods described as Log-Shipping Standby Servers in the Postgres documentation. Everything seems to be ...
- 1,766
2
votes
2
answers
2k
views
Postgresql pg_standby takes forever to perform failover
I have a working WAL shipping setup with a warm standby slave server applying the WAL files.
When I create the pg_standby trigger file, it detects this at once, but it takes about 10-15 minutes to ...
- 1,891
0
votes
4
answers
4k
views
Postgres HA (based on WAL-shipping) fails
I'm hoping someone can help me a WAL-shipping and warm standby issue. My standby system runs happily for weeks, then all of a sudden it starts looking for .history files that don't exist. It then ...
- 1,685