All Questions
4 questions
0
votes
1
answer
229
views
How to make sure that all required wal files are availables before starting a standby server?
Im writing a script to restore a postgres standby server that was out of sync with the master node for a while.
I would like the following behavior
Check if i can go with pg_rewind
If pg_rewind fails,...
0
votes
1
answer
476
views
Is there a better way to add failed node back to postgres cluster?
There are 2 nodes in the cluster: node1(primary) and node2(replica).
I will shutdown node1 and promote node2 as primary.
I'll add the node1 back to the cluster (as a replica this time), so I am using ...
- 123
0
votes
1
answer
144
views
how to upgrade postgresql 9.0.4 to latest with minimum downtime
I have master-slave-slave setup for postgresql 9.0.4 in our production setup.
We need to upgrade it to latest (11.X), so my question is what would be the procedure to do so with as little downtime as ...
3
votes
1
answer
7k
views
unable to start the standby postgres database
Situation
I have 2 separate instances. Both running on Ubuntu 14.04 server.
Both have installed postgres 9.5 the following way:
sudo apt-get install software-properties-common python-software-...
- 215