switchover in postgresql
Posted
by
user1010280
on Server Fault
See other posts from Server Fault
or by user1010280
Published on 2011-11-30T03:55:57Z
Indexed on
2011/12/01
10:00 UTC
Read the original article
Hit count: 280
I am using Postgresql 9.0 with Streaming replication. So, during switchover I follow these steps:-
- Get the server timestamp on primary.
- Get the current log position on primary.
- Set Verify Log location
- Verify Transaction Received Location
- Shutdown DB on production.
- Synchronize the transaction logs from PR to DR.
- Trigger a failover on the DR Database by creating the trigger file specified in recovery.conf
- Verify DB Mode on DR
- Copy the control file from from DR to primary.
- copy the temporary stats file from DR to primary.
- copy the history file from DR to primary.
- Create recovery.conf file.
- Start Database in standby mode in primary.
- Verify DB mode on PR
At step (6), I have to copy last wal generated on Primary to standby and sync both PR and standby. but this thing takes time to copy files because this remote. So that postgres will keep seraching for wal for long time and after that it stops the server.
So I want to know is there any way so that I can ask postgres to stop seraching or locating WAL after shutdown??? because postgres tries to locate this wal every 5 seconds.
Please reply as soon as possible..its urgent...
© Server Fault or respective owner