Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tw1yG-0004a0-QK for pgsql-admin@arkaria.postgresql.org; Fri, 18 Jan 2013 02:46:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tw1yG-0008Lp-Ay for pgsql-admin@arkaria.postgresql.org; Fri, 18 Jan 2013 02:46:20 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tw1yF-0008Lj-CI for pgsql-admin@postgresql.org; Fri, 18 Jan 2013 02:46:19 +0000 Received: from [64.207.29.137] (helo=mail.illumen.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tw1yD-0000HU-5v for pgsql-admin@postgresql.org; Fri, 18 Jan 2013 02:46:18 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Subject: Re: Question concerning replicated server using streaming replication used as a read-only reporting server Date: Thu, 17 Jan 2013 19:46:05 -0700 Message-ID: In-Reply-To: <20130117233212.134360@gmx.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Question concerning replicated server using streaming replication used as a read-only reporting server Thread-Index: Ac31CuHsEZynbT1UR4CpUKtxnRSWtgAGvUww References: <20130117233212.134360@gmx.com> From: "Benjamin Krajmalnik" To: "Kevin Grittner" , X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.207.29.137 (failed) X-Pg-Spam-Score: -1.1 (-) 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 SXQgaXMgb2sgaWYgSSBhbSBhIGxpdHRsZSBiaXQgYmVoaW5kLiAgV2hhdCBz ZXR0aW5nIGRvIEkgbmVlZCB0byB0d2VhayB0byBhbGxvdyBpdCB0byBnZXQg ZnVydGhlciBiZWhpbmQ/DQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0t LS0NCkZyb206IEtldmluIEdyaXR0bmVyIFttYWlsdG86a2dyaXR0bkBtYWls LmNvbV0gDQpTZW50OiBUaHVyc2RheSwgSmFudWFyeSAxNywgMjAxMyA0OjMy IFBNDQpUbzogQmVuamFtaW4gS3Jham1hbG5pazsgcGdzcWwtYWRtaW5AcG9z dGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBbQURNSU5dIFF1ZXN0aW9uIGNv bmNlcm5pbmcgcmVwbGljYXRlZCBzZXJ2ZXIgdXNpbmcgc3RyZWFtaW5nIHJl cGxpY2F0aW9uIHVzZWQgYXMgYSByZWFkLW9ubHkgcmVwb3J0aW5nIHNlcnZl cg0KDQpCZW5qYW1pbiBLcmFqbWFsbmlrIHdyb3RlOg0KDQo+IEkgaGF2ZSAy IHNlcnZlcnMgd2hpY2ggYXJlIHVzaW5nIHN0cmVhbWluZyByZXBsaWNhdGlv biAocGcgOS4wLjQpLg0KPiANCj4gVGhlIHNlY29uZGFyeSBzZXJ2ZXIgaXMg dGhlcmUgcHJpbWFyaWx5IGFzIGEgZGlzYXN0ZXIgcmVjb3Zlcnkgc2VydmVy LCANCj4gYnV0IHdlIGFyZSBhbHNvIHVzaW5nIGl0IGZvciByZXBvcnRpbmcs IHNvIGFzIG5vdCB0byBwbGFjZSB1bmR1ZSBsb2FkIA0KPiBvbiB0aGUgcHJp bWFyeSBzZXJ2ZXIuDQo+IA0KPiBBcyBJIHJldmlldyB0aGUgbG9ncyBvbiB0 aGUgc2Vjb25kYXJ5IHNlcnZlciwgSSBmcmVxdWVudGx5IHNlZSB0aGUNCj4g Zm9sbG93aW5nOg0KDQo+IDIwMTMtMDEtMTcgMDY6MDU6NDcgTVNUIFtsb2Nh bF1FUlJPUjogY2FuY2VsaW5nIHN0YXRlbWVudCBkdWUgdG8gDQo+IGNvbmZs aWN0IHdpdGggcmVjb3ZlcnkNCj4gMjAxMy0wMS0xNyAwNjowNTo0NyBNU1Qg W2xvY2FsXURFVEFJTDogVXNlciBxdWVyeSBtaWdodCBoYXZlIG5lZWRlZCB0 byANCj4gc2VlIHJvdyB2ZXJzaW9ucyB0aGF0IG11c3QgYmUgcmVtb3ZlZC4N Cj4gMjAxMy0wMS0xNyAwNjowNTo0NyBNU1QgW2xvY2FsXVNUQVRFTUVOVDog U2VsZWN0IHN0YXRlbWVudCBnb2VzIGhlcmUNCj4gMjAxMy0wMS0xNyAwNjow NTo0NyBNU1QgW2xvY2FsXUZBVEFMOiB0ZXJtaW5hdGluZyBjb25uZWN0aW9u IGR1ZSB0byANCj4gY29uZmxpY3Qgd2l0aCByZWNvdmVyeQ0KPiAyMDEzLTAx LTE3IDA2OjA1OjQ3IE1TVCBbbG9jYWxdREVUQUlMOiBVc2VyIHF1ZXJ5IG1p Z2h0IGhhdmUgbmVlZGVkIHRvIA0KPiBzZWUgcm93IHZlcnNpb25zIHRoYXQg bXVzdCBiZSByZW1vdmVkLg0KPiAyMDEzLTAxLTE3IDA2OjA1OjQ3IE1TVCBb bG9jYWxdSElOVDogSW4gYSBtb21lbnQgeW91IHNob3VsZCBiZSBhYmxlIHRv IA0KPiByZWNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlIGFuZCByZXBlYXQgeW91 ciBjb21tYW5kLg0KDQo+IElzIHRoZXJlIGFueXRoaW5nIHRoYXQgY2FuIGJl IGRvbmUgdG8gbWl0aWdhdGUgdGhpcyBzaXR1YXRpb24/DQoNCllvdSBuZWVk IHRvIGRlY2lkZSBob3cgInN0YWxlIiB5b3UncmUgd2lsbGluZyB0byBsZXQg dGhlIGhvdCBzdGFuZGJ5IGdldC4gVG8gcHJlc2VydmUgYW4gaW1hZ2Ugb2Yg dGhlIGRhdGFiYXNlIHdoaWNoIGNhbiBhbGxvdyB0aGUgcXVlcnkgdG8ga2Vl cCBydW5uaW5nLCB0aGUgc3RhbmRieSBzZXJ2ZXIgbWlnaHQgbmVlZCB0byBw YXVzZSByZXBsYXkgb2YgdHJhbnNhY3Rpb25zLiBUbyBhbGxvdyBsb25nIHRy YW5zYWN0aW9ucywgeW91IG5lZWQgdG8gYWxsb3cgaXQgdG8gcGF1c2UgdGhl IHRyYW5zYWN0aW9uIHN0cmVhbSBmb3IgYSBsb25nIHRpbWUsIGJ1dCB0aGF0 IG1lYW5zIHRoYXQgaXQncyBnZXR0aW5nIG91dCBvZiBkYXRlIGZvciBkaXNh c3RlciByZWNvdmVyeSBwdXJwb3Nlcy4NCkl0IG1pZ2h0IGJlIHdvcnRod2hp bGUgdG8ga2VlcCB0d28gc3RhbmRieSBjbHVzdGVycywgb25lIHRoYXQgaXMg YWdncmVzc2l2ZSBhYm91dCBhcHBseWluZyB0aGUgbGF0ZXN0IHRyYW5zYWN0 aW9ucywgYW5kIGFub3RoZXIgd2hpY2ggYWxsb3dzIGxvbmctcnVubmluZyBx dWVyaWVzLg0KDQotS2V2aW4NCgotLSAKU2VudCB2aWEgcGdzcWwtYWRtaW4g bWFpbGluZyBsaXN0IChwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZykKVG8g bWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3 LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLWFkbWluCg==