Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jdzzF-0000Xs-TM for pgsql-admin@arkaria.postgresql.org; Wed, 27 May 2020 17:37:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jdzzE-00054N-Id for pgsql-admin@arkaria.postgresql.org; Wed, 27 May 2020 17:37:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jdzzE-00054A-B5; Wed, 27 May 2020 17:37:04 +0000 Received: from mail-oln040092253011.outbound.protection.outlook.com ([40.92.253.11] helo=APC01-SG2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jdzzB-0005vz-MH; Wed, 27 May 2020 17:37:03 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=mTAvUH/ottC8xXEAxCsNxBml2XfoyXH2grWsU54OZM2lBaZGUBtO5FBXy05ecNzB70tzSHjdVCciAgA1hs/JHa/01NCzpPZvSusXIPntYj1a33Xi45PWmsaQkvyVee3LOHr+JlitfnCyneVW02GHF8pMnBdx8bLQ2IcYMsCuiQakyAeEgz3optnlGbVZNrPQufFlmASnVC9WTUCH3NAUgRrcnS9fvB8RYvGHRIm1N5r83L0Gy82isHGBTYmMwDP6a6on/UzVP/mnQ1aJf0guMJBezu0f3y1mQ5jlOOgtqKZzaXlXYinsrkinqq1ntvU14I+F2vLyb6ffsZdnUJeMtg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=W1QYOC9qV+5/ciDqcBxd4NZfzjVgttNanA1M8CMuGFY=; b=PWWNIM0JKns1YLbuggcRMlwnLhNsiEhOv3AEtfy4o19yUTIcaHJ9wFhg939enE8LMKjDmU37ab/SLx15pfB6rpEPMscasXYtLG9qM+ju0mRSL9wqbmQXAcugdYvBrVklo9QTIkIB/110AfcgZh3UvctiotM7D0O/5EHAibkOrwYjWQTOfzfmo6VEZq+1TWOV/oeVI94MCjwCdV1vpO15UXRI2CB8VAb4gr/Cr7RzPbnLmwXc3FYHvJ7K/iSOxaV07vPTh+Ziqo6BNw3eQjGFY+MGLhvwANna56DSqF2LUqkqYY5GwFTTMl9i0bnzdDqlS+c/E/cnM4gIiUzyBxm+Mg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=W1QYOC9qV+5/ciDqcBxd4NZfzjVgttNanA1M8CMuGFY=; b=uUnznulOoxGgFdD/w3QOGzaMg33ZrXtjvKuaCVIhrCxU97BtYuvIjkok4MS3Q4kcM1sJTbBUEBs8HjP5QdvJD9o2b0MrfLsri9O/N3x7gVE2glFNw/IoRxGKn8YpjYaImxyNVNJ+mQnLl/LwJygcBAbTgxQYG4xvOQVYCnFY2LuOlNdzaV5jfYx1CxCvXrkibJOP4ZuywdCH3Wq3UFYEtpWmT2tHZ6qQDWssoi7E8A9cyNXbJDWRML8r9sn3zW4JAu3RvVRHxgt061nzCVm6rLtIvkaN8PZRNjiC33cEvQ4KiL7Jq+qgRYW9uEytFBwwrrmr9PH/OgFWKTtyrn07NA== Received: from PU1APC01FT114.eop-APC01.prod.protection.outlook.com (2a01:111:e400:7ebe::47) by PU1APC01HT148.eop-APC01.prod.protection.outlook.com (2a01:111:e400:7ebe::171) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3045.17; Wed, 27 May 2020 17:36:57 +0000 Received: from MA1PR01MB0634.INDPRD01.PROD.OUTLOOK.COM (2a01:111:e400:7ebe::51) by PU1APC01FT114.mail.protection.outlook.com (2a01:111:e400:7ebe::228) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3045.17 via Frontend Transport; Wed, 27 May 2020 17:36:57 +0000 Received: from MA1PR01MB0634.INDPRD01.PROD.OUTLOOK.COM ([fe80::ed04:84fc:e941:62e4]) by MA1PR01MB0634.INDPRD01.PROD.OUTLOOK.COM ([fe80::ed04:84fc:e941:62e4%8]) with mapi id 15.20.3045.018; Wed, 27 May 2020 17:36:57 +0000 From: soumitra bhandary To: postgann2020 s CC: pgsql-admin , pgsql-general Subject: Re: suggestion the process to sync the data from PROD DB to Staging environment Thread-Topic: suggestion the process to sync the data from PROD DB to Staging environment Thread-Index: AQHWND9zEvsPvxamQEG1dngC7GPdGai8Mlfo Date: Wed, 27 May 2020 17:36:57 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:55CC626A330410F8601E6C351F3BA3D4239EA534510287C1A660F58D9B2BB480;UpperCasedChecksum:B5B01752EDC4F50B7D1ADB120753CED9F68A27A736733B1DC8F366D2F8F6EC14;SizeAsReceived:7121;Count:46 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [2TbnPGRGsuyX1UNDzYItyr6+s4jnUlKW] x-ms-publictraffictype: Email x-incomingheadercount: 46 x-eopattributedmessage: 0 x-ms-office365-filtering-correlation-id: 4b2b7c17-d91c-4c2e-6e2d-08d802648dfd x-ms-traffictypediagnostic: PU1APC01HT148: x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: FzlgU5cSHi+PCkHZPS9YsoEOuWMFsUOCKQt1v5HqhZaH0SQjif4fyiPKEzRYUJCFyY3tBbvBVVG2LykSU9kTUPcZ0sdnaAWQPcYeqc1X8B2TsOv8Xkd5SAUmxo6s8b38jexJW9CN+DrMrcKYvR1Dq1CIqHLRXoOqN11NAtJce33R4kkWnBh/Q/b4DoPd0gTlOzTs3BqHxA5VMqSUSy68yA== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:0;SRV:;IPV:NLI;SFV:NSPM;H:MA1PR01MB0634.INDPRD01.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFTY:;SFS:;DIR:OUT;SFP:1901; x-ms-exchange-antispam-messagedata: J0pj54LROGB9CnORG3G+bDjHL5xWu/a0UDZkyMiS7a/ldLlebBP/MbMtGNGOHRQ9Jo9upOd++hK40zoH6lR/lI26swhVPp3i8gXSV+lyyPelcauxT/e/FerbF9z2UC5tGcWVYu5uOtfcU0HuDY7KKA== x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_MA1PR01MB06348F1F124C3326530D5B99E0B10MA1PR01MB0634INDP_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 4b2b7c17-d91c-4c2e-6e2d-08d802648dfd X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-originalarrivaltime: 27 May 2020 17:36:57.3827 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: PU1APC01HT148 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_MA1PR01MB06348F1F124C3326530D5B99E0B10MA1PR01MB0634INDP_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SWYgcG9zc2libGUgeW91IGNhbiBjb25uZWN0IHN0YWdpbmcgc2VydmVyIGFzIGFzeW5jaHJvbm91 cyBzbGF2ZSBub2RlIHRvIG9uZSBvZiB0aGUgYXN5bmNocm9ub3VzIG5vZGUgYWxyZWFkeSBpbiBw cm9kdWN0aW9uDQoNClNlbnQgZnJvbSBteSBpUGhvbmUNCg0KT24gMjctTWF5LTIwMjAsIGF0IDk6 MjYgUE0sIHBvc3RnYW5uMjAyMCBzIDxwb3N0Z2FubjIwMjBAZ21haWwuY29tPiB3cm90ZToNCg0K 77u/DQpIaSBUZWFtLA0KDQpUaGFua3MgZm9yIHlvdXIgc3VwcG9ydC4NCg0KQ291bGQgc29tZW9u ZSBwbGVhc2Ugc3VnZ2VzdCB0aGUgcHJvY2VzcyB0byBzeW5jIHRoZSBkYXRhIGZyb20gUFJPRCBE QiB0byB0aGUgU3RhZ2luZyBlbnZpcm9ubWVudCB3aXRoIG1pbmltYWwgbWFudWFsIGludGVydmVu dGlvbiBvciBhdXRvbWF0aWNhbGx5Lg0KDQpUaGFua3MgJiBSZWdhcmRzLA0KUG9zdGdhbm4uDQo= --_000_MA1PR01MB06348F1F124C3326530D5B99E0B10MA1PR01MB0634INDP_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0i dGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjwvaGVhZD4NCjxib2R5IGRpcj0iYXV0byI+DQpJ ZiBwb3NzaWJsZSB5b3UgY2FuIGNvbm5lY3Qgc3RhZ2luZyBzZXJ2ZXIgYXMgYXN5bmNocm9ub3Vz IHNsYXZlIG5vZGUgdG8gb25lIG9mIHRoZSBhc3luY2hyb25vdXMgbm9kZSBhbHJlYWR5IGluIHBy b2R1Y3Rpb24mbmJzcDs8YnI+DQo8YnI+DQo8ZGl2IGRpcj0ibHRyIj5TZW50IGZyb20gbXkgaVBo b25lPC9kaXY+DQo8ZGl2IGRpcj0ibHRyIj48YnI+DQo8YmxvY2txdW90ZSB0eXBlPSJjaXRlIj5P biAyNy1NYXktMjAyMCwgYXQgOToyNiBQTSwgcG9zdGdhbm4yMDIwIHMgJmx0O3Bvc3RnYW5uMjAy MEBnbWFpbC5jb20mZ3Q7IHdyb3RlOjxicj4NCjxicj4NCjwvYmxvY2txdW90ZT4NCjwvZGl2Pg0K PGJsb2NrcXVvdGUgdHlwZT0iY2l0ZSI+DQo8ZGl2IGRpcj0ibHRyIj7vu78NCjxkaXYgZGlyPSJs dHIiPkhpIFRlYW0sPGJyPg0KPGJyPg0KVGhhbmtzIGZvciB5b3VyIHN1cHBvcnQuPGJyPg0KPGJy Pg0KQ291bGQgc29tZW9uZSBwbGVhc2Ugc3VnZ2VzdCB0aGUgcHJvY2VzcyB0byA8Zm9udCBjb2xv cj0iI2ZmMDAwMCI+PGI+c3luYyB0aGUgZGF0YSBmcm9tIFBST0QgREIgdG8gdGhlIFN0YWdpbmcg ZW52aXJvbm1lbnQ8L2I+PC9mb250PiB3aXRoIG1pbmltYWwgbWFudWFsIGludGVydmVudGlvbiBv ciBhdXRvbWF0aWNhbGx5Ljxicj4NCjxicj4NClRoYW5rcyAmYW1wOyBSZWdhcmRzLDxicj4NClBv c3RnYW5uLjxicj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Jsb2NrcXVvdGU+DQo8L2JvZHk+DQo8L2h0 bWw+DQo= --_000_MA1PR01MB06348F1F124C3326530D5B99E0B10MA1PR01MB0634INDP_--