Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41863=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VgFkS-0000Of-LQ
 for pgsql-admin@arkaria.postgresql.org; Tue, 12 Nov 2013 15:19:24 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41863=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VgFkR-0006Zj-9a
 for pgsql-admin@arkaria.postgresql.org; Tue, 12 Nov 2013 15:19:23 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <scott_ribe@elevated-dev.com>) id 1VgFkH-0006Ln-N5
 for pgsql-admin@postgresql.org; Tue, 12 Nov 2013 15:19:13 +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 <scott_ribe@elevated-dev.com>) id 1VgFkB-00072S-3u
 for pgsql-admin@postgresql.org; Tue, 12 Nov 2013 15:19:12 +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
 rACFJ2X5010333
 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NO);
 Tue, 12 Nov 2013 15:19:04 +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 <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CAH-nkqk6amrDozECFKo+kakXPocGm512W=-7x013wxf0H-veoQ@mail.gmail.com>
Date: Tue, 12 Nov 2013 08:19:00 -0700
Cc: Scott Marlowe <scott.marlowe@gmail.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <B24871FC-91A7-4E08-B685-19E21BE463C0@elevated-dev.com>
References: 
 <CAH-nkqnTO+MKFHBEk4jMH6WJUduc-ezXAepzsEc7kP2bx5u-jw@mail.gmail.com>
 <CAOR=d=0P5Ztk=30+otLZeqQo=HrpQ6oHjh5OtbiPa5LfDfBaXw@mail.gmail.com>
 <CAH-nkqk6amrDozECFKo+kakXPocGm512W=-7x013wxf0H-veoQ@mail.gmail.com>
To: Guillermo Carrasco <guillermo.carrasco@scilifelab.se>
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=NEAV23lmAAAA:8 a=no8No8b_vcNS5pNGXoAA:9 a=wPNLvfGTeEIA:10
 a=uN5EI_x0ke8A:10 a=sx6hCiKP-x8A:10 a=p4YQ7U2Pg4IA:10 a=VNvfRua1cs0A:10
 a=SIpPrCeHeVYA:10
X-CTCH-RefID: str=0001.0A02020A.528246E8.0201, 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: 0.8 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Why not just shut down the staging server, pg_start_backup on production, a=
nd rsync the db???

On Nov 12, 2013, at 8:02 AM, Guillermo Carrasco <guillermo.carrasco@scilife=
lab.se> 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
>=20


--=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