| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Guillermo Carrasco <guillermo(dot)carrasco(at)scilifelab(dot)se> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: REVOKE command not working as expected |
| Date: | 2013-11-13 14:27:34 |
| Message-ID: | 21113D38-151D-411F-8404-FC4FE0D645F8@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Nov 13, 2013, at 12:42 AM, Guillermo Carrasco <guillermo(dot)carrasco(at)scilifelab(dot)se> 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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Petr Suk | 2013-11-13 15:26:48 | automatical grant - role membership |
| Previous Message | Guillermo Carrasco | 2013-11-13 07:42:00 | Re: REVOKE command not working as expected |