On Nov 13, 2013, at 12:42 AM, Guillermo Carrasco <guillermo.carrasco@xxxxxxxxxxxxx> wrote: > We want to make an exact copy of production, even if someone have made changes in stage, we want to remove all the changes and leave stage as an exact copy of production, will pg_start_backup do the work? Copying the files pg uses does the work ;-) pg_start_backup just enables you to copy a live database and get a consistent result. -- 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