Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aYOBI-0003mq-1D for pgsql-admin@arkaria.postgresql.org; Wed, 24 Feb 2016 01:23:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aYOBG-0006fk-BN for pgsql-admin@arkaria.postgresql.org; Wed, 24 Feb 2016 01:23:54 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aYOBF-0006fX-7d for pgsql-admin@postgresql.org; Wed, 24 Feb 2016 01:23:53 +0000 Received: from mail-bn1bon0073.outbound.protection.outlook.com ([157.56.111.73] helo=na01-bn1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aYOB7-0004Y0-93 for pgsql-admin@postgresql.org; Wed, 24 Feb 2016 01:23:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=journyx.onmicrosoft.com; s=selector1-journyx-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=culUuFT4RL0TiIq/jSRFl2rdjWMuDJyBgrXzcuFfldg=; b=cvsROOJ6AR/1JoH0HrFnjtGaWlqlR6ZfdUDEmxX5cRhHcGvNnjva/ngKmuzQ/h/JhtYMyX09LSlyUCwxFsbJzoBydvzyf4fAk/mhL9vdwwlLELniQGmRG2W1ktCpzaTuizDaRGH7Rw/8pqJZVB9euUFyHtXpGsQSgduIGilLxzk= Received: from BY1PR11MB0390.namprd11.prod.outlook.com (10.162.146.14) by BY1PR11MB0389.namprd11.prod.outlook.com (10.162.146.139) with Microsoft SMTP Server (TLS) id 15.1.409.15; Wed, 24 Feb 2016 01:23:41 +0000 Received: from BY1PR11MB0390.namprd11.prod.outlook.com ([10.162.146.14]) by BY1PR11MB0390.namprd11.prod.outlook.com ([10.162.146.14]) with mapi id 15.01.0409.024; Wed, 24 Feb 2016 01:23:41 +0000 From: Scott Whitney To: "drum.lucas@gmail.com" CC: "David G. Johnston" , "pgsql-admin@postgresql.org" Subject: Re: Incremental Refresh - PostgreSQL 9.2 Thread-Topic: [ADMIN] Incremental Refresh - PostgreSQL 9.2 Thread-Index: AQHRboXKnuQxIGPyVEKbzsLkuDvc3p86MhEAgAAHxP6AACKUgIAACogF Date: Wed, 24 Feb 2016 01:23:40 +0000 Message-ID: References: , In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=journyx.com; x-originating-ip: [24.55.4.13] x-microsoft-exchange-diagnostics: 1;BY1PR11MB0389;5:tStQP1KgcoagWxzdsg/INsfTLR30FnYkMKWYowODxWWuAScX6Vv+DgB+7N1Y+AaGbiJdiMKV/sMS7zMUdmRah9qmk8kEJyhDer8nahhINVjOs0nrtv3IlUrjW/gMgC9nDoviYG1qhb6rHJayNyBRjg==;24:EjANuG20enjN+xfAbZtz5e9/54Q6P4Vfb6eKqSBxhOkntauKIdKFLuGLqMDJ+SpvKsglohXHdoe36qcIh+QZlrCuY/biFSRkBTx66aTQk7Q= x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BY1PR11MB0389; x-ms-office365-filtering-correlation-id: 55719265-af0f-4895-9942-08d33cb92136 x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(601004)(2401047)(8121501046)(5005006)(10201501046)(3002001);SRVR:BY1PR11MB0389;BCL:0;PCL:0;RULEID:;SRVR:BY1PR11MB0389; x-forefront-prvs: 08626BE3A5 x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(24454002)(377454003)(479174004)(19617315012)(15974865002)(2351001)(92566002)(6116002)(3660700001)(40100003)(15975445007)(3280700002)(99286002)(33646002)(19580395003)(77096005)(19580405001)(95246002)(2501003)(16236675004)(2950100001)(10400500002)(2900100001)(122556002)(54356999)(76176999)(11100500001)(50986999)(110136002)(106116001)(189998001)(5001960100002)(87936001)(63666004)(102836003)(3846002)(4326007)(1096002)(1220700001)(5008740100001)(5004730100002)(2906002)(586003)(5002640100001)(93886004)(66066001)(86362001);DIR:OUT;SFP:1101;SCL:1;SRVR:BY1PR11MB0389;H:BY1PR11MB0390.namprd11.prod.outlook.com;FPR:;SPF:None;MLV:sfv;LANG:en; spamdiagnosticoutput: 1:23 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_ewwmlvageqrkn3rdthfso2nq1456277100577emailandroidcom_" MIME-Version: 1.0 X-OriginatorOrg: journyx.com X-MS-Exchange-CrossTenant-originalarrivaltime: 24 Feb 2016 01:23:40.8995 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 83db917a-cb55-44ba-82ef-25aa3e32343f X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY1PR11MB0389 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 --_000_ewwmlvageqrkn3rdthfso2nq1456277100577emailandroidcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Please do not refer me (or the list) to a URL when you are asking for help.= Be clear and concise. If you have a URI that helps you, please be specific= in the places you do not understand. -------- Original message -------- From: drum.lucas@gmail.com Date: 02/23/2016 6:46 PM (GMT-06:00) To: Scott Whitney Cc: "David G. Johnston" , pgsql-admin@postgresq= l.org Subject: Re: [ADMIN] Incremental Refresh - PostgreSQL 9.2 On 24 February 2016 at 11:42, Scott Whitney > wrote: Are you using it for just select queries, or is this a full 100% test (inse= rt/update/delete) test environment? I have both. In my case they are geographically separate. Production server= at data center. Replicated "just in case," also at data center. At HQ, I r= eplicate that for DR purposes. INTERNALLY (gigabit backend), I have another= internal test server that I refresh FROM THE REPLICATED SERVER AT HQ on a = regular basis. I use the replicated server to query stuff (select) and dump= databases to the interaction test server regularly for full testing. That's what I'm looking for: https://coderwall.com/p/jxebnw/incremental-backups-for-postgresql Journyx, Inc. 7600 Burnet Road #300 Austin, TX 78757 www.journyx.com p 512.834.8888 f 512-834-8858 Do you receive our promotional emails? You can subscribe or unsubscribe to = those emails at http://go.journyx.com/emailPreference/e/4932/714/ --_000_ewwmlvageqrkn3rdthfso2nq1456277100577emailandroidcom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Please do not refer me (or the list) to a URL when you are asking for help.= Be clear and concise. If you have a URI that helps you, please be specific= in the places you do not understand.

-------- Original message --------
From: drum.lucas@gmail.com
Date: 02/23/2016 6:46 PM (GMT-06:00)
To: Scott Whitney <scott@journyx.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, pgsql= -admin@postgresql.org
Subject: Re: [ADMIN] Incremental Refresh - PostgreSQL 9.2



On 24 February 2016 at 11:42, Scott Whitney <scott@journyx.co= m> wrote:
Are you using it for just select queries, or is this a full 100% test = (insert/update/delete) test environment?

I have both. In my case they are geographically separate. Production s= erver at data center. Replicated "just in case," also at data cen= ter. At HQ, I replicate that for DR purposes. INTERNALLY (gigabit backend),= I have another internal test server that I refresh FROM THE REPLICATED SERVER AT HQ on a regular basis. I use the r= eplicated server to query stuff (select) and dump databases to the interact= ion test server regularly for full testing.



That's what I'm looking for:




Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com

p 512.834.8888 
f 512-834-8858 

Do you receive our promotional emails? You can subscribe or unsubscrib= e to those emails at http://go.journyx.com/emailPreference/e/4932/714/ = ;
--_000_ewwmlvageqrkn3rdthfso2nq1456277100577emailandroidcom_--