Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ciM2v-0007dG-A3 for pgsql-performance@arkaria.postgresql.org; Mon, 27 Feb 2017 14:13:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ciM2u-0006gQ-T3 for pgsql-performance@arkaria.postgresql.org; Mon, 27 Feb 2017 14:13:00 +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_2) (envelope-from ) id 1ciM15-0000Ke-O5; Mon, 27 Feb 2017 14:11:07 +0000 Received: from mxgate02.infotech-enterprises.com ([110.76.160.160] helo=mxgate02.cyient.com) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1ciM11-0003Oz-Iy; Mon, 27 Feb 2017 14:11:06 +0000 X-IronPort-AV: E=Sophos;i="5.35,214,1483986600"; d="scan'208";a="48763835" Received: from unknown (HELO INFHYDEX10AHT2.corp.infotech-enterprises.com) ([172.17.0.115]) by mxgate02.cyient.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 27 Feb 2017 19:33:25 +0530 Received: from CYINMBX4.CORP.CYIENT.COM (172.17.4.164) by INFHYDEX10AHT2.corp.infotech-enterprises.com (172.17.0.115) with Microsoft SMTP Server (TLS) id 14.3.158.1; Mon, 27 Feb 2017 19:40:56 +0530 Received: from CYINMBX4.CORP.CYIENT.COM (172.17.4.164) by CYINMBX4.CORP.CYIENT.COM (172.17.4.164) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.544.27; Mon, 27 Feb 2017 19:40:52 +0530 Received: from CYINMBX4.CORP.CYIENT.COM ([fe80::e40c:d4fe:9e0c:f465]) by CYINMBX4.CORP.CYIENT.COM ([fe80::e40c:d4fe:9e0c:f465%19]) with mapi id 15.01.0544.027; Mon, 27 Feb 2017 19:40:52 +0530 From: Dinesh Chandra 12108 To: vinny , John Gorman CC: Rick Otten , "pgsql-performance@postgresql.org" , "pgsql-performance-owner@postgresql.org" Subject: Re: How Can I check PostgreSQL backup is successfully or not ? Thread-Topic: [PERFORM] How Can I check PostgreSQL backup is successfully or not ? Thread-Index: AdKQ3M8yJjjmRjxuRPSNwoQ1I36Zmf//tNKAgAAwVQCAAAi/AP//oXtQ Date: Mon, 27 Feb 2017 14:10:52 +0000 Message-ID: References: <7080564fb84f4bd0b178d86062b4790f@cyient.com> <0A1B0B276DEE6441A2E68EB66D4540DAD71D12C7@WINEX1.eldocomp.com> <10da6c146fc36f8124f5863bb824c615@xs4all.nl> In-Reply-To: <10da6c146fc36f8124f5863bb824c615@xs4all.nl> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.17.4.81] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Pg-Spam-Score: -3.5 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org SGksDQoNCkkgcnVuIHRoZSBiZWxvdyBjb21tYW5kDQpbcG9zdGdyZXNAQ1BQ TW9tYS1EQjA1IGJpbl0kIHBnX2R1bXAgLVUgcG9zdGdyZXMgIG1vbWFfdHNf b2NlOyBlY2hvICQNCg0KT3V0cHV0IHdhcyBsaWtlIHRoaXMoTGFzdCBmZXcg bGluZXMgKQ0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQotLSBO YW1lOiBwdWJsaWM7IFR5cGU6IEFDTDsgU2NoZW1hOiAtOyBPd25lcjogcG9z dGdyZXMNCi0tDQoNClJFVk9LRSBBTEwgT04gU0NIRU1BIHB1YmxpYyBGUk9N IFBVQkxJQzsNClJFVk9LRSBBTEwgT04gU0NIRU1BIHB1YmxpYyBGUk9NIHBv c3RncmVzOw0KR1JBTlQgQUxMIE9OIFNDSEVNQSBwdWJsaWMgVE8gcG9zdGdy ZXM7DQpHUkFOVCBBTEwgT04gU0NIRU1BIHB1YmxpYyBUTyBQVUJMSUM7DQoN Ci0tDQotLSBQb3N0Z3JlU1FMIGRhdGFiYXNlIGR1bXAgY29tcGxldGUNCi0t DQoNCiQNCg0KUmVnYXJkcywNCkRpbmVzaCBDaGFuZHJhDQp8RGF0YWJhc2Ug YWRtaW5pc3RyYXRvciAoT3JhY2xlL1Bvc3RncmVTUUwpfCBDeWllbnQgTHRk LiBOb2lkYS4NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KTW9iaWxlOiArOTEt OTk1Mzk3NTg0OSB8IEV4dCAxMDc4IHxkaW5lc2guY2hhbmRyYUBjeWllbnQu Y29tDQpQbG90IE5vLiA3LCBOU0VaLCBQaGFzZS1JSSAsTm9pZGEtRGFkcmkg Um9hZCwgTm9pZGEgLSAyMDEgMzA1LEluZGlhLg0KDQotLS0tLU9yaWdpbmFs IE1lc3NhZ2UtLS0tLQ0KRnJvbTogdmlubnkgW21haWx0bzp2aW5ueUB4czRh bGwubmxdDQpTZW50OiAyNyBGZWJydWFyeSwgMjAxNyA3OjMxIFBNDQpUbzog Sm9obiBHb3JtYW4gPGpnb3JtYW5AZWxkb2NvbXAuY29tPg0KQ2M6IFJpY2sg T3R0ZW4gPHJvdHRlbndpbmRmaXNoQGdtYWlsLmNvbT47IERpbmVzaCBDaGFu ZHJhIDEyMTA4IDxEaW5lc2guQ2hhbmRyYUBjeWllbnQuY29tPjsgcGdzcWwt cGVyZm9ybWFuY2VAcG9zdGdyZXNxbC5vcmc7IHBnc3FsLXBlcmZvcm1hbmNl LW93bmVyQHBvc3RncmVzcWwub3JnDQpTdWJqZWN0OiBSZTogW1BFUkZPUk1d IEhvdyBDYW4gSSBjaGVjayBQb3N0Z3JlU1FMIGJhY2t1cCBpcyBzdWNjZXNz ZnVsbHkgb3Igbm90ID8NCg0KT24gMjAxNy0wMi0yNyAxNDoyOSwgSm9obiBH b3JtYW4gd3JvdGU6DQo+IEV2ZW4gdGhvdWdoIGl0J3Mgbm90IGxpc3RlZCBp biBhbnkgb2YgdGhlIGRvY3VtZW50YXRpb24gb3Ig4oCccGdfZHVtcA0KPiAt LWhlbHDigJ0geW91IGNhbiBjaGVjayB0aGUgcmV0dXJuIGNvZGUgb2YgdGhl IHByb2Nlc3MuIEEgcmV0dXJuIGNvZGUNCj4gZ3JlYXRlciB0aGFuIDAgKHpl cm8pIHVzdWFsbHkgaW5kaWNhdGVzIGEgZmFpbHVyZQ0KPg0KPiAuL2JpbiA+ cGdfZHVtcCAtVSBkdW1teV91c2VyICBkdW1teV9kYXRhYmFzZTsgZWNobyAk Pw0KPg0KPiAxDQo+DQo+IEZST006IHBnc3FsLXBlcmZvcm1hbmNlLW93bmVy QHBvc3RncmVzcWwub3JnDQo+IFttYWlsdG86cGdzcWwtcGVyZm9ybWFuY2Ut b3duZXJAcG9zdGdyZXNxbC5vcmddIE9OIEJFSEFMRiBPRiBSaWNrDQo+IE90 dGVuDQo+IFNFTlQ6IE1vbmRheSwgRmVicnVhcnkgMjcsIDIwMTcgMzozNiBB TQ0KPiBUTzogRGluZXNoIENoYW5kcmEgMTIxMDgNCj4gQ0M6IHBnc3FsLXBl cmZvcm1hbmNlQHBvc3RncmVzcWwub3JnDQo+IFNVQkpFQ1Q6IFJlOiBbUEVS Rk9STV0gSG93IENhbiBJIGNoZWNrIFBvc3RncmVTUUwgYmFja3VwIGlzDQo+ IHN1Y2Nlc3NmdWxseSBvciBub3QgPw0KPg0KPiBBbHRob3VnaCBpdCBkb2Vz bid0IHJlYWxseSB0ZWxsIGlmIHRoZSBwZ19kdW1wIHdhcyBzdWNjZXNzZnVs ICh5b3UnbGwNCj4gbmVlZCB0byBkbyBhIGZ1bGwgcmVzdG9yZSB0byBiZSBz dXJlKSwgSSBnZW5lcmF0ZSBhbiBhcmNoaXZlIGxpc3QuICBJZg0KPiB0aGF0 IGZhaWxzLCB0aGUgYmFja3VwIGNsZWFybHkgd2Fzbid0IHN1Y2Nlc3NmdWws IGFuZCBpZiBpdCBzdWNjZWVkcywNCj4gb2RkcyBhcmUgcHJldHR5IGdvb2Qg dGhhdCBpdCB3b3JrZWQ6DQo+DQo+IE9uIE1vbiwgRmViIDI3LCAyMDE3IGF0 IDQ6MzUgQU0sIERpbmVzaCBDaGFuZHJhIDEyMTA4DQo+IDxEaW5lc2guQ2hh bmRyYUBjeWllbnQuY29tPiB3cm90ZToNCj4NCj4gSGksDQo+DQo+IFdlIGFy ZSB0YWtpbmcgZGFpbHkgZnVsbCBiYWNrdXAgb2YgUG9zdGdyZVNRTCBkYXRh YmFzZSB1c2luZyBQR19EVU1QDQo+IHdoaWNoIGlzIGF1dG9tYXRpYyBzY2hl ZHVsZWQgdGhyb3VnaCBDcm9uam9icy4NCj4NCj4gSG93IGNhbiBJIGNoZWNr IG15IHllc3RlcmRheSBiYWNrdXAgaXMgc3VjY2Vzc2Z1bGx5IG9yIG5vdD8N Cj4NCj4gSXMgdGhlcmUgYW55IHF1ZXJ5IG9yIHZpZXcgYnkgd2hpY2ggSSBj YW4gY2hlY2sgaXQ/DQo+DQo+IFJFR0FSRFMsDQo+DQo+IERJTkVTSCBDSEFO RFJBDQo+DQo+IHxEQVRBQkFTRSBBRE1JTklTVFJBVE9SIChPUkFDTEUvUE9T VEdSRVNRTCl8IENZSUVOVCBMVEQuIE5PSURBLg0KDQoNCkl0J3MgaW1wb3J0 YW50IHRvIG5vdGUgdGhlIGRpc3RpbmN0aW9uIGJldHdlZW4NCg0KInRoZSBi YWNrdXAgcHJvY2VzcyBkaWQgbm90IGZhaWwiDQoNCmFuZA0KDQoid2Ugbm93 IGhhdmUgYSB0cnVzdHdvcnRoeSBiYWNrdXAiDQoNCkFuZCB5b3UgY2FuIGdv IGZ1bGwtcGFyYW5vaWEgYW5kIHNheSB0aGF0IHlvdSBjYW4gc3VjY2Vzc2Z1 bGx5IGNyZWF0ZSBhIHBlcmZlY3RseSB3b3JraW5nIGJhY2t1cCBvZiB0aGUg d3JvbmcgZGF0YWJhc2UuDQoNClNvIHdoYXQgaXMgaXQgdGhhdCB5b3Ugd2Fu dCB0byBtYWtlIHN1cmUgb2Y6DQoxLiBEaWQgdGhlIHByb2Nlc3MgZ2l2ZSBh biBlcnJvcj8NCjIuIERpZCB0aGUgcHJvY2VzcyBjcmVhdGUgYSB1c2FibGUg YmFja3VwPw0KDQpXaGF0IGFyZSB0aGUgY2hhbmNlcyBvZiAjMSByZXBvcnRp bmcgc3VjY2VzcyBidXQgc3RpbGwgcHJvZHVjaW5nIGEgYmFkIGJhY2t1cD8N CkFuZCBjYW4gIzIgZmFpbCBvbiBhIGdvb2QgZGF0YWJhc2UsIGFuZCBpZiBz bywgY2FuIHlvdSBkZXRlY3QgdGhhdD8NCg0KDQoNCl9fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fDQoNCkRJU0NMQUlNRVI6DQoNClRoaXMgZW1h aWwgbWVzc2FnZSBpcyBmb3IgdGhlIHNvbGUgdXNlIG9mIHRoZSBpbnRlbmRl ZCByZWNpcGllbnQocykgYW5kIG1heSBjb250YWluIGNvbmZpZGVudGlhbCBh bmQgcHJpdmlsZWdlZCBpbmZvcm1hdGlvbi4gQW55IHVuYXV0aG9yaXplZCBy ZXZpZXcsIHVzZSwgZGlzY2xvc3VyZSBvciBkaXN0cmlidXRpb24gaXMgcHJv aGliaXRlZC4gSWYgeW91IGFyZSBub3QgdGhlIGludGVuZGVkIHJlY2lwaWVu dCwgcGxlYXNlIGNvbnRhY3QgdGhlIHNlbmRlciBieSByZXBseSBlbWFpbCBh bmQgZGVzdHJveSBhbGwgY29waWVzIG9mIHRoZSBvcmlnaW5hbCBtZXNzYWdl LiBDaGVjayBhbGwgYXR0YWNobWVudHMgZm9yIHZpcnVzZXMgYmVmb3JlIG9w ZW5pbmcgdGhlbS4gQWxsIHZpZXdzIG9yIG9waW5pb25zIHByZXNlbnRlZCBp biB0aGlzIGUtbWFpbCBhcmUgdGhvc2Ugb2YgdGhlIGF1dGhvciBhbmQgbWF5 IG5vdCByZWZsZWN0IHRoZSBvcGluaW9uIG9mIEN5aWVudCBvciB0aG9zZSBv ZiBvdXIgYWZmaWxpYXRlcy4NCgotLSAKU2VudCB2aWEgcGdzcWwtcGVyZm9y bWFuY2UgbWFpbGluZyBsaXN0IChwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0Z3Jl c3FsLm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9u OgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXBl cmZvcm1hbmNlCg==