Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VgbQ1-0001ML-5r for pgsql-admin@arkaria.postgresql.org; Wed, 13 Nov 2013 14:27:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VgbQ0-0001JB-HH for pgsql-admin@arkaria.postgresql.org; Wed, 13 Nov 2013 14:27:44 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VgbPz-0001J5-Oj for pgsql-admin@postgresql.org; Wed, 13 Nov 2013 14:27:43 +0000 Received: from mail222c25.carrierzone.com ([64.29.147.236] helo=mail24c25-2209.carrierzone.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VgbPv-0007AZ-Cp for pgsql-admin@postgresql.org; Wed, 13 Nov 2013 14:27:42 +0000 X-Authenticated-User: sribe.elevated-dev.com Received: from [192.168.4.16] ([205.170.118.135]) (authenticated bits=0) by mail24c25-2209.carrierzone.com (8.13.6/8.13.1) with ESMTP id rADERZmi030243 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NO); Wed, 13 Nov 2013 14:27:37 +0000 Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Mac OS X Mail 7.0 \(1822\)) Subject: Re: REVOKE command not working as expected From: Scott Ribe In-Reply-To: Date: Wed, 13 Nov 2013 07:27:34 -0700 Cc: "pgsql-admin@postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: <21113D38-151D-411F-8404-FC4FE0D645F8@elevated-dev.com> References: To: Guillermo Carrasco X-Mailer: Apple Mail (2.1822) X-CSC: 0 X-CHA: v=2.1 cv=a8wJqyiF c=1 sm=1 tr=0 a=hYCsVa6O+dny/aDYgEAfRA==:117 a=hYCsVa6O+dny/aDYgEAfRA==:17 a=g0qM3YM6AAAA:8 a=9Msywe--0xYA:10 a=YTaT0nJ_ZkcA:10 a=8nJEP1OIZ-IA:10 a=YfQFs2c5AAAA:8 a=-r-VAsruUH0A:10 a=3WaU2aOxTKyZTeU9TtAA:9 a=wPNLvfGTeEIA:10 a=uN5EI_x0ke8A:10 a=sx6hCiKP-x8A:10 a=p4YQ7U2Pg4IA:10 X-CTCH-RefID: str=0001.0A020204.52838C59.01EA, ss=1, re=0.100, recu=0.000, reip=0.000, cl=1, cld=1, fgs=0 X-CTCH-VOD: Unknown X-CTCH-Spam: Unknown X-CTCH-Score: 0.100 X-CTCH-Rules: X-CTCH-Flags: 0 X-CTCH-ScoreCust: 0.000 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Nov 13, 2013, at 12:42 AM, Guillermo Carrasco wrote: > We want to make an exact copy of production, even if someone have made ch= anges in stage, we want to remove all the changes and leave stage as an exa= ct 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 consiste= nt result. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin