Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e2zI9-0004Db-86 for pgsql-admin@arkaria.postgresql.org; Fri, 13 Oct 2017 12:42:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e2zI8-00067J-R7 for pgsql-admin@arkaria.postgresql.org; Fri, 13 Oct 2017 12:42:16 +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 1e2zI7-00062N-FK for pgsql-admin@postgresql.org; Fri, 13 Oct 2017 12:42:15 +0000 Received: from mx02.junkmailshark.com ([204.134.46.100]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e2zI3-0003xi-QO for pgsql-admin@postgresql.org; Fri, 13 Oct 2017 12:42:14 +0000 X-Ironport-SBRS: 2.7 X-Ironport-GROUP-POLICY: ENCRYPTION_RELAY - $RELAY_TLS_REQUIRED X-IronPort-AV: E=Sophos;i="5.43,371,1503381600"; d="scan'208,217";a="1121963" Received: from unknown (HELO ANMEX02.adnetman.local) ([199.198.255.156]) by mx02.junkmailshark.com with ESMTP/TLS/AES256-SHA; 13 Oct 2017 06:42:10 -0600 Received: from ANMEX01.adnetman.local (192.168.240.21) by ANMEX02.adnetman.local (172.24.20.40) with Microsoft SMTP Server (TLS) id 15.0.1156.6; Fri, 13 Oct 2017 06:42:09 -0600 Received: from ANMEX02.adnetman.local (172.24.20.40) by ANMEX01.adnetman.local (192.168.240.21) with Microsoft SMTP Server (TLS) id 15.0.1156.6; Fri, 13 Oct 2017 06:42:09 -0600 Received: from ANMEX02.adnetman.local ([fe80::bc68:46db:6a32:b01b]) by ANMEX02.adnetman.local ([fe80::bc68:46db:6a32:b01b%12]) with mapi id 15.00.1156.000; Fri, 13 Oct 2017 06:42:09 -0600 From: Ishan Arora To: "pgsql-admin@postgresql.org" Subject: Increase retention period of a table in database Thread-Topic: Increase retention period of a table in database Thread-Index: AQHTRCCumuRZa/cd2UaxKbVHjsVrWw== Date: Fri, 13 Oct 2017 12:42:08 +0000 Message-ID: <37018920e5984732a176436dbd80620c@ANMEX02.adnetman.local> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted Content-Type: multipart/alternative; boundary="_000_37018920e5984732a176436dbd80620cANMEX02adnetmanlocal_" MIME-Version: 1.0 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_37018920e5984732a176436dbd80620cANMEX02adnetmanlocal_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGVsbG8gVGVhbSwNCg0KSSB3YW50ZWQgdG8ga25vdyBpZiB0aGVyZSBpcyBhIHdheSB0byBpbmNy ZWFzZSB0aGUgcmV0ZW50aW9uIHBlcmlvZCBvZiBhIHRhYmxlIGluIGRhdGFiYXNlPw0KSSBoYXZl IGNyZWF0ZWQgYSBkYXRhYmFzZSBmb3Igc3RvcmluZyBjaGF0IG1lc3NhZ2VzOyBpdCBpcyBpbnRl Z3JhdGVkIHdpdGggQ2lzY28gSU0gJiBQcmVzZW5jZSBhcHBsaWNhdGlvbi4gRm9yIGRldGFpbHMg b24gaW50ZWdyYXRpb246IGh0dHBzOi8vd3d3LmNpc2NvLmNvbS9jL2VuL3VzL3N1cHBvcnQvZG9j cy91bmlmaWVkLWNvbW11bmljYXRpb25zL3VuaWZpZWQtcHJlc2VuY2UtdmVyc2lvbi04MC8xMTc3 MzUtY3Vwcy1wb3N0Z3Jlcy0wMC5odG1sDQoNCkluIHRoZSBjcmVhdGVkIGRiLCB0aGUgY2hhdCBt ZXNzYWdlcyBhcmUgc3RvcmVkIGluIHRoZSDigJhqbeKAmSB0YWJsZSBmb3Igd2hpY2ggdGhlIHJl dGVudGlvbiBwZXJpb2Qgc2VlbXMgdG8gYmUgMTUgZGF5cy4gSSB3b3VsZCBsaWtlIHRvIGtub3cg aWYgdGhpcyBjYW4gYmUgaW5jcmVhc2VkIGFuZCBob3cuDQoNCkFueSBpbnB1dHMgYXJlIGhpZ2hs eSBhcHByZWNpYXRlZC4NCg0KVGhhbmtzICYgcmVnYXJkcywNCklzaGFuIEFyb3JhDQoNCg== --_000_37018920e5984732a176436dbd80620cANMEX02adnetmanlocal_ Content-Type: text/html; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6bz0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6b2ZmaWNlIiB4 bWxuczp3PSJ1cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTp3b3JkIiB4bWxuczptPSJo dHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL29mZmljZS8yMDA0LzEyL29tbWwiIHhtbG5zPSJo dHRwOi8vd3d3LnczLm9yZy9UUi9SRUMtaHRtbDQwIj4NCjxoZWFkPg0KPG1ldGEgaHR0cC1lcXVp dj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPG1l dGEgbmFtZT0iR2VuZXJhdG9yIiBjb250ZW50PSJNaWNyb3NvZnQgV29yZCAxNSAoZmlsdGVyZWQg bWVkaXVtKSI+DQo8c3R5bGU+PCEtLQ0KLyogRm9udCBEZWZpbml0aW9ucyAqLw0KQGZvbnQtZmFj ZQ0KCXtmb250LWZhbWlseToiQ2FtYnJpYSBNYXRoIjsNCglwYW5vc2UtMToyIDQgNSAzIDUgNCA2 IDMgMiA0O30NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6Q2FsaWJyaTsNCglwYW5vc2UtMToy IDE1IDUgMiAyIDIgNCAzIDIgNDt9DQovKiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3Jt YWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1zb05vcm1hbA0KCXttYXJnaW46MGNtOw0KCW1hcmdpbi1i b3R0b206LjAwMDFwdDsNCglmb250LXNpemU6MTEuMHB0Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJp IixzYW5zLXNlcmlmO30NCmE6bGluaywgc3Bhbi5Nc29IeXBlcmxpbmsNCgl7bXNvLXN0eWxlLXBy aW9yaXR5Ojk5Ow0KCWNvbG9yOmJsdWU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQph OnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQNCgl7bXNvLXN0eWxlLXByaW9yaXR5 Ojk5Ow0KCWNvbG9yOiM5NTRGNzI7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQouTXNv Q2hwRGVmYXVsdA0KCXttc28tc3R5bGUtdHlwZTpleHBvcnQtb25seTt9DQpAcGFnZSBXb3JkU2Vj dGlvbjENCgl7c2l6ZTo2MTIuMHB0IDc5Mi4wcHQ7DQoJbWFyZ2luOjcyLjBwdCA3Mi4wcHQgNzIu MHB0IDcyLjBwdDt9DQpkaXYuV29yZFNlY3Rpb24xDQoJe3BhZ2U6V29yZFNlY3Rpb24xO30NCi0t Pjwvc3R5bGU+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJFTi1JTiIgbGluaz0iYmx1ZSIgdmxpbms9 IiM5NTRGNzIiPg0KPGRpdiBjbGFzcz0iV29yZFNlY3Rpb24xIj4NCjxwIGNsYXNzPSJNc29Ob3Jt YWwiPkhlbGxvIFRlYW0sPC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286 cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5JIHdhbnRlZCB0byBrbm93IGlmIHRoZXJlIGlz IGEgd2F5IHRvIGluY3JlYXNlIHRoZSByZXRlbnRpb24gcGVyaW9kIG9mIGEgdGFibGUgaW4gZGF0 YWJhc2U/PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+SSBoYXZlIGNyZWF0ZWQgYSBkYXRhYmFz ZSBmb3Igc3RvcmluZyBjaGF0IG1lc3NhZ2VzOyBpdCBpcyBpbnRlZ3JhdGVkIHdpdGggQ2lzY28g SU0gJmFtcDsgUHJlc2VuY2UgYXBwbGljYXRpb24uIEZvciBkZXRhaWxzIG9uIGludGVncmF0aW9u Og0KPGEgaHJlZj0iaHR0cHM6Ly93d3cuY2lzY28uY29tL2MvZW4vdXMvc3VwcG9ydC9kb2NzL3Vu aWZpZWQtY29tbXVuaWNhdGlvbnMvdW5pZmllZC1wcmVzZW5jZS12ZXJzaW9uLTgwLzExNzczNS1j dXBzLXBvc3RncmVzLTAwLmh0bWwiPg0KaHR0cHM6Ly93d3cuY2lzY28uY29tL2MvZW4vdXMvc3Vw cG9ydC9kb2NzL3VuaWZpZWQtY29tbXVuaWNhdGlvbnMvdW5pZmllZC1wcmVzZW5jZS12ZXJzaW9u LTgwLzExNzczNS1jdXBzLXBvc3RncmVzLTAwLmh0bWw8L2E+PC9wPg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5JbiB0aGUg Y3JlYXRlZCBkYiwgdGhlIGNoYXQgbWVzc2FnZXMgYXJlIHN0b3JlZCBpbiB0aGUg4oCYam3igJkg dGFibGUgZm9yIHdoaWNoIHRoZSByZXRlbnRpb24gcGVyaW9kIHNlZW1zIHRvIGJlIDE1IGRheXMu IEkgd291bGQgbGlrZSB0byBrbm93IGlmIHRoaXMgY2FuIGJlIGluY3JlYXNlZCBhbmQgaG93Ljwv cD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+QW55IGlucHV0cyBhcmUgaGlnaGx5IGFwcHJlY2lhdGVkLjwvcD4NCjxwIGNs YXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1h bCI+VGhhbmtzICZhbXA7IHJlZ2FyZHMsPC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+SXNoYW4g QXJvcmE8L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjwv ZGl2Pg0KPC9ib2R5Pg0KPC9odG1sPg0K --_000_37018920e5984732a176436dbd80620cANMEX02adnetmanlocal_--