<span style=3D"font-family:Verdana; color:#000000; font-size:10=
pt;">PostgreSQL version: 9.3.3=0AOperating system: Redhat 6.4 Linu=
x=0ADescription: =0AWe are in the proc=
ess of setting up a standby server. Instead of restoring from a backup take=
n from primary server, we want to shutdown the primary server, and then=
copy the primary database VM image to the standby server.We want t=
o do this because our database is 7TB and takes 4-5 to backup and 8-9 days =
to restore to the standby server.Mock Primary :192.168.1.50Mock=
standby:192.168.1.1001.) Configure pg_hda.conf on primary#=
Allow the user "postgres" from host 192.168.1.100 to connect to the primar=
y# as a replication standby if the user's password is correctly supplie=
d.## TYPE DATABASE =
USER ADDR=
ESS =
METHODhost replication =
postgres 192.1=
68.1.100/32 md52.) Co=
nfigure recovery.conf on standbystandby_mode =3D 'on'primary_co=
nninfo =3D 'host=3D192.168.1.50 port=3D5432 user=3Dpostgres password=3Dfoop=
ass'restore_command =3D 'cp /path/to/archive/%f %p'archive_cleanup_=
command =3D 'pg_archivecleanup /path/to/archive %r'3.) re-start bot=
h serversQuestion #1 Is this feasible?Question #2 Have I missed=
critical steps?Thanks</h=
tml>
