Why not just shut down the staging server, pg_start_backup on production, and rsync the db??? On Nov 12, 2013, at 8:02 AM, Guillermo Carrasco <guillermo.carrasco@xxxxxxxxxxxxx> wrote: > Thanks for your answer, I know, that's why we have this statement: https://github.com/guillermo-carrasco/scilifelab/blob/master/scripts/dbsync.sh#L20 > -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin