<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>PostgreSQL version: 9.3.3<br>
Operating system: Redhat 6.4 Linux<br>
Description: </div><div><br></div><div>
We are in the process of setting up a standby server. Instead of restoring from a backup taken from primary server, <br>we want to shutdown the primary server, and then copy the primary database VM image to the standby server.<br><br>We want to do this because our database is 7TB and takes 4-5 to backup and 8-9 days to restore to the standby server.<br><br>Mock Primary :192.168.1.50<br>Mock standby:192.168.1.100<br><br>1.) Configure pg_hda.conf on primary<br><br># Allow the user "postgres" from host 192.168.1.100 to connect to the primary<br># as a replication standby if the user's password is correctly supplied.<br>#<br># TYPE DATABASE USER ADDRESS METHOD<br>host replication postgres 192.168.1.100/32 md5<br><br><br>2.) Configure recovery.conf on standby<br><br>standby_mode = 'on'<br>primary_conninfo = 'host=192.168.1.50 port=5432 user=postgres password=foopass'<br>restore_command = 'cp /path/to/archive/%f %p'<br>archive_cleanup_command = 'pg_archivecleanup /path/to/archive %r'<br><br>3.) re-start both servers<br><br>Question #1 Is this feasible?<br>Question #2 Have I missed critical steps?</div><div><br></div><div>Thanks<br></div></span></body></html>