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 1qEvhq-0006QO-J7 for pgsql-admin@arkaria.postgresql.org; Thu, 29 Jun 2023 17:45:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qEvhp-0004Th-2b for pgsql-admin@arkaria.postgresql.org; Thu, 29 Jun 2023 17:45:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qEvho-0004Pj-4J for pgsql-admin@lists.postgresql.org; Thu, 29 Jun 2023 17:45:20 +0000 Received: from mx0a-000e5c14.pphosted.com ([148.163.133.209]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qEvhg-0018TB-80 for pgsql-admin@lists.postgresql.org; Thu, 29 Jun 2023 17:45:18 +0000 Received: from pps.filterd (m0206225.ppops.net [127.0.0.1]) by mx0a-000e5c14.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 35TFJwuS025379; Thu, 29 Jun 2023 12:45:08 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=express-scripts.com; h=from : to : date : message-id : references : in-reply-to : content-type : mime-version : subject; s=pod140124231234; bh=14pRW32+bqjO49HC9mATSoYU4IrPaSIE1+bXdNhOS7k=; b=ZeLpXkb/SpW4Bov5w8SWayWBzJ/frupLG3DqGbgVL+uNPOEefUkxwqQfKmkjai27AnBu VR6RfIy18zNx7atrE1vXY3EjOFpVtWkt0G1J7Eg/6K1gK6czHVD9c5AKSkkaeyv6B/gg BEE2EDR3BhdNdhHBtBHqamvtCnBSlvspYDX234N3VOC1vlGvMt+YqqHtggTCZHk/T+rG Q9m8DHGGIp1mOg8d+57sF5BQ+/+e+73MHHFh+6l8l+WHUKnDZi1AL+zpyIkaVGAQl4CT 7EAXi6FtzDGNEqLADtSv6Z7p2VSLdO4BTkXQMklsXyPXOrHRfW+b8au8AEBfx5daMgEL cw== Received: from eiaappxp0005.gid.prd.globalcore.com ([170.48.0.128]) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3rhcga8bte-4 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Thu, 29 Jun 2023 12:45:08 -0500 Received: from cvlappxp20760.internal.cigna.com (HELO PS2PW1012185.accounts.root.corp) ([10.36.52.93]) by EIAAPPXP0005.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 29 Jun 2023 17:45:08 +0000 Received: from PS2PW1012186.accounts.root.corp (10.221.225.154) by PS2PW1012185.accounts.root.corp (10.221.225.153) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.26; Thu, 29 Jun 2023 13:45:07 -0400 Received: from PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad]) by PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad%6]) with mapi id 15.02.1118.026; Thu, 29 Jun 2023 13:45:07 -0400 From: "Wetmore, Matthew (CTR)" To: Nikhil Ingale , "pgsql-admin@lists.postgresql.org" Thread-Topic: [EXTERNAL] Deleting the pg logs older than 30 days or certain time Thread-Index: AQHZqlkqsVjdREIk2U61XoEeoG+0Wq+iDaLw Date: Thu, 29 Jun 2023 17:45:07 +0000 Message-ID: <425e0d73152e4c0692293d144a299305@express-scripts.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.222.252.1] x-proofpoint-routing: 000e5c14 Content-Type: multipart/alternative; boundary="_000_425e0d73152e4c0692293d144a299305expressscriptscom_" MIME-Version: 1.0 X-CFilter-Loop: Reflected Subject: Deleting the pg logs older than 30 days or certain time X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.254,Aquarius:18.0.957,Hydra:6.0.591,FMLib:17.11.176.26 definitions=2023-06-29_05,2023-06-27_01,2023-05-22_02 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_425e0d73152e4c0692293d144a299305expressscriptscom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SSBmZWVsIHlvdSBoYXZlIG1vcmUgY29udHJvbCB3aXRoIGEgc2ltcGxlIGJhc2ggKG9yIHNjcmlw dCBvZiBjaG9pY2UpIG9uZSBsaW5lciBhbmQgY3Jvbi4gIEkgZG9u4oCZdCBsaWtlIGF1dG9tYXRl ZCBkZWxldGVzIG9mIGFueXRoaW5nIHVubGVzcyBJ4oCZbSBpbiBjb250cm9sLiAgJDAuMDINCg0K DQoNCkZyb206IE5pa2hpbCBJbmdhbGUgPG5pa3MuYmdtQGdtYWlsLmNvbT4NClNlbnQ6IFRodXJz ZGF5LCBKdW5lIDI5LCAyMDIzIDEyOjEyIEFNDQpUbzogcGdzcWwtYWRtaW5AbGlzdHMucG9zdGdy ZXNxbC5vcmcNClN1YmplY3Q6IFtFWFRFUk5BTF0gRGVsZXRpbmcgdGhlIHBnIGxvZ3Mgb2xkZXIg dGhhbiAzMCBkYXlzIG9yIGNlcnRhaW4gdGltZQ0KDQpIaSBBbGwsDQpDYW4gcG9zdGdyZXNxbCBp bnRlcm5hbCBsb2cgcm90YXRpb24gY29uZmlndXJhdGlvbiBtZWNoYW5pc20gZGVsZXRlIHRoZSBs b2cgZmlsZXMgb2xkZXIgdGhhbiBhIHNwZWNpZmljIHBlcmlvZCBvZiB0aW1lPw0KDQpJcyB0aGVy ZSBhIHdheSB0byBjb25maWd1cmUgdGhpcyBhcyBwYXJ0IG9mIHBvc3RncmVzcWw/DQoNClJlZ2Fy ZHMsDQpOaWtoaWwgSW5nYWxlDQo= --_000_425e0d73152e4c0692293d144a299305expressscriptscom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9 DQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCglj b2xvcjojMDU2M0MxOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBz cGFuLk1zb0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xv cjojOTU0RjcyOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KcC5tc29ub3JtYWwwLCBs aS5tc29ub3JtYWwwLCBkaXYubXNvbm9ybWFsMA0KCXttc28tc3R5bGUtbmFtZTptc29ub3JtYWw7 DQoJbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87DQoJbWFyZ2luLXJpZ2h0OjBpbjsNCgltc28tbWFy Z2luLWJvdHRvbS1hbHQ6YXV0bzsNCgltYXJnaW4tbGVmdDowaW47DQoJZm9udC1zaXplOjEyLjBw dDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIixzZXJpZjt9DQpzcGFuLkVtYWlsU3R5 bGUxOA0KCXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1yZXBseTsNCglmb250LWZhbWlseToiQ2Fs aWJyaSIsc2Fucy1zZXJpZjsNCgljb2xvcjojMUY0OTdEO30NCi5Nc29DaHBEZWZhdWx0DQoJe21z by1zdHlsZS10eXBlOmV4cG9ydC1vbmx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIixzYW5zLXNl cmlmO30NCkBwYWdlIFdvcmRTZWN0aW9uMQ0KCXtzaXplOjguNWluIDExLjBpbjsNCgltYXJnaW46 MS4waW4gMS4waW4gMS4waW4gMS4waW47fQ0KZGl2LldvcmRTZWN0aW9uMQ0KCXtwYWdlOldvcmRT ZWN0aW9uMTt9DQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVk ZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAyNiIgLz4NCjwveG1sPjwhW2VuZGlmXS0t PjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVsYXlvdXQgdjpleHQ9ImVkaXQiPg0K PG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQo8L286c2hhcGVsYXlvdXQ+PC94bWw+ PCFbZW5kaWZdLS0+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJFTi1VUyIgbGluaz0iIzA1NjNDMSIg dmxpbms9IiM5NTRGNzIiPg0KPGRpdiBjbGFzcz0iV29yZFNlY3Rpb24xIj4NCjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90 O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjojMUY0OTdEIj5JIGZlZWwgeW91IGhhdmUg bW9yZSBjb250cm9sIHdpdGggYSBzaW1wbGUgYmFzaCAob3Igc2NyaXB0IG9mIGNob2ljZSkgb25l IGxpbmVyIGFuZCBjcm9uLiZuYnNwOyBJIGRvbuKAmXQgbGlrZSBhdXRvbWF0ZWQgZGVsZXRlcyBv ZiBhbnl0aGluZyB1bmxlc3MgSeKAmW0gaW4gY29udHJvbC4mbmJzcDsNCiAkMC4wMjxvOnA+PC9v OnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNp emU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xv cjojMUY0OTdEIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9y bWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxp YnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFGNDk3RCI+PG86cD4mbmJzcDs8L286cD48L3Nw YW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4w cHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMxRjQ5 N0QiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxi PjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkm cXVvdDssc2Fucy1zZXJpZiI+RnJvbTo8L3NwYW4+PC9iPjxzcGFuIHN0eWxlPSJmb250LXNpemU6 MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZiI+IE5pa2hp bCBJbmdhbGUgJmx0O25pa3MuYmdtQGdtYWlsLmNvbSZndDsNCjxicj4NCjxiPlNlbnQ6PC9iPiBU aHVyc2RheSwgSnVuZSAyOSwgMjAyMyAxMjoxMiBBTTxicj4NCjxiPlRvOjwvYj4gcGdzcWwtYWRt aW5AbGlzdHMucG9zdGdyZXNxbC5vcmc8YnI+DQo8Yj5TdWJqZWN0OjwvYj4gW0VYVEVSTkFMXSBE ZWxldGluZyB0aGUgcGcgbG9ncyBvbGRlciB0aGFuIDMwIGRheXMgb3IgY2VydGFpbiB0aW1lPG86 cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286 cD48L3A+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+SGkmbmJzcDtBbGwsPG86cD48L286 cD48L3A+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+Q2FuIHBvc3RncmVzcWwgaW50ZXJu YWwgbG9nIHJvdGF0aW9uIGNvbmZpZ3VyYXRpb24gbWVjaGFuaXNtIGRlbGV0ZSB0aGUgbG9nIGZp bGVzIG9sZGVyIHRoYW4gYSBzcGVjaWZpYyBwZXJpb2Qgb2YgdGltZT88bzpwPjwvbzpwPjwvcD4N CjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9w Pg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+SXMgdGhlcmUgYSB3YXkgdG8g Y29uZmlndXJlIHRoaXMgYXMgcGFydCBvZiBwb3N0Z3Jlc3FsPzxvOnA+PC9vOnA+PC9wPg0KPC9k aXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8 L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5SZWdhcmRzLDxicj4NCk5pa2hpbCBJ bmdhbGU8bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rpdj4NCjwvYm9keT4NCjwv aHRtbD4NCg== --_000_425e0d73152e4c0692293d144a299305expressscriptscom_--