switchover in postgresql
- by user1010280
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...