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 1llPYA-0003M8-63 for pgadmin-hackers@arkaria.postgresql.org; Tue, 25 May 2021 05:24:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1llPY7-0007fh-Px for pgadmin-hackers@arkaria.postgresql.org; Tue, 25 May 2021 05:24:15 +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 1llPY7-0007fY-GE for pgadmin-hackers@lists.postgresql.org; Tue, 25 May 2021 05:24:15 +0000 Received: from mail-lf1-x12b.google.com ([2a00:1450:4864:20::12b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1llPY4-0000cP-E5 for pgadmin-hackers@postgresql.org; Tue, 25 May 2021 05:24:14 +0000 Received: by mail-lf1-x12b.google.com with SMTP id j10so44032441lfb.12 for ; Mon, 24 May 2021 22:24:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=NfaIQXSd9UlVgLDXuzdAFBvNiPzcBpWdoeWISm4LbGE=; b=bbnRpz5yd5oCM8OESwRGZ+gYsedRUA22v3Kax9UrpwfGh9DvbLoudMzk32T1i72fvb ZUak3Hm4dhP8XJO0fhxbeQ6vfK1un1nXJrejN5qi/Aa5It/LeKfiFS5X+svMlgsvKTvM 3ZQ1VeIwuRPEM/6KZaNabloYs4k3HF42on1DFsp/Xoyzij8q29t7gJhhoMUN2P5nFHH7 g0h9bVPOXLY8ClMgYQO3ne4fhNGEniVlaQHyMkiaRKqAbOr257RmwYtbuNowtu4izw+9 bNjGtr6WoFcqgkqd8XHheP7uE+oxpI+UG5FgCDEY9zYk2kwpxH7TrwjYIcYWgxciZwLr ms4w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=NfaIQXSd9UlVgLDXuzdAFBvNiPzcBpWdoeWISm4LbGE=; b=pR60SNNj86TDl3xHrxHqMY3iDrcUTJ0vD3SdIh8mxAF86usNuZYbNf3RcyZlpCE31I /rjI3zzaFlQvIJoqTAmQt+h62mYeZgJaImAtYHkAijp6CNEsET/FfoP7Gz34w4Tf+EsO Zp8pqo9nzP8OjNg86MPdWJ8/Q84zaeFzEghpe8TuLZAMC/obKnN4WSzbP7eXnKJL8WxQ a+0s032L4m8sNZUtFqLCioA0Xiv9JPlck0r/GraH9F4WCq1ew5ZjupdHj6YZ4SZF62p6 ujLkBkW/wO9zlUHhQZHk6TqziqC8GkR5KGHILbQ0nST2jFLg+qRE/WWtQdxkOYondNAd Vwkw== X-Gm-Message-State: AOAM531MKMYdOQCckGvdjvXgseM9Qr0A7aWD10EKNtxx1TgA7Kz9pB6o w2OtLbv9rvowwrVvQzGOEG6fnXPeOFn8HowYXcrb0WtY+/7pZIGKmYUjOpl07s7m/RH0WH9xkrq /RqkvhElPdsTveArd4bEOf2F6+Eiqj98zHvQnSP+JC9VSSyHgNrWo+bS12sA4BebQyrF7ZvI/hb 0ypwV6+2TrFXCoYX8rL2wRWCAovN2u2kJRUgDO4Fsru8NzSVIambTaWdqqSTaWFkCzy9/E X-Google-Smtp-Source: ABdhPJwV9skcF/e70g+olWIv7rJ91cU+4vm3uLmMu1wFqCMnnswWXJ6ZnW+qDGKWWfBh+/ww/+n0qFjGYJR+GzvFYj4= X-Received: by 2002:a05:6512:3224:: with SMTP id f4mr264704lfe.149.1621920250840; Mon, 24 May 2021 22:24:10 -0700 (PDT) MIME-Version: 1.0 From: Yogesh Mahajan Date: Tue, 25 May 2021 10:53:34 +0530 Message-ID: Subject: [pgAdmin][Patch] - Feature #6395 - Feature request: Log Rotation To: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000681f1505c320bcd9" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000681f1505c320bcd9 Content-Type: multipart/alternative; boundary="000000000000681f1305c320bcd7" --000000000000681f1305c320bcd7 Content-Type: text/plain; charset="UTF-8" Hi, Please find the attached patch which rotates the pgadmin log file with context to the parameters specified in the config file. # Log rotation setting LOG_ROTATION_SIZE = 10 # In MBs LOG_ROTATION_AGE = 1440 # In minutes LOG_ROTATION_MAX_LOGS = 90 # Maximum number of backups to retain Thanks, Yogesh Mahajan EnterpriseDB --000000000000681f1305c320bcd7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Please find the att= ached patch which rotates the pgadmin log file with context to the paramete= rs specified in the config file.

# Log rotation setting
LOG_ROTATION_SIZE =3D 10  # In MBs
LO=
G_ROTATION_AGE =3D 1440  # In minutes
LOG=
_ROTATION_MAX_LOGS =3D 90  # Maximum number of back=
ups to retain

Tha= nks,
Yogesh Mahajan
EnterpriseDB
--000000000000681f1305c320bcd7-- --000000000000681f1505c320bcd9 Content-Type: application/x-patch; name="RM6395_v1.patch" Content-Disposition: attachment; filename="RM6395_v1.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kp3kcnhn0 ZGlmZiAtLWdpdCBhL3dlYi9jb25maWcucHkgYi93ZWIvY29uZmlnLnB5CmluZGV4IDRkMWY5ODY5 OC4uNjYzNzg4ZTUwIDEwMDY0NAotLS0gYS93ZWIvY29uZmlnLnB5CisrKyBiL3dlYi9jb25maWcu cHkKQEAgLTI4Niw2ICsyODYsMTAgQEAgaWYgU0VSVkVSX01PREUgYW5kIG5vdCBJU19XSU46CiBl bHNlOgogICAgIExPR19GSUxFID0gb3MucGF0aC5qb2luKERBVEFfRElSLCAncGdhZG1pbjQubG9n JykKIAorIyBMb2cgcm90YXRpb24gc2V0dGluZworTE9HX1JPVEFUSU9OX1NJWkUgPSAxMCAgIyBJ biBNQnMKK0xPR19ST1RBVElPTl9BR0UgPSAxNDQwICAjIEluIG1pbnV0ZXMKK0xPR19ST1RBVElP Tl9NQVhfTE9HUyA9IDkwICAjIE1heGltdW0gbnVtYmVyIG9mIGJhY2t1cHMgdG8gcmV0YWluCiAj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IyMjIyMjIyMjIyMjIyMjIwogIyBTZXJ2ZXIgQ29ubmVjdGlvbiBEcml2ZXIgU2V0dGluZ3MKICMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IyMjIyMjIyMjIyMjIyMjCmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9fX2luaXRfXy5weSBiL3dl Yi9wZ2FkbWluL19faW5pdF9fLnB5CmluZGV4IGE3MzMzNTM3MS4uNjQ0OTgwNmYyIDEwMDY0NAot LS0gYS93ZWIvcGdhZG1pbi9fX2luaXRfXy5weQorKysgYi93ZWIvcGdhZG1pbi9fX2luaXRfXy5w eQpAQCAtMjU1LDggKzI1NSwxNCBAQCBkZWYgY3JlYXRlX2FwcChhcHBfbmFtZT1Ob25lKToKICAg ICAgICAgZnJvbSBwZ2FkbWluLnNldHVwIGltcG9ydCBjcmVhdGVfYXBwX2RhdGFfZGlyZWN0b3J5 CiAgICAgICAgIGNyZWF0ZV9hcHBfZGF0YV9kaXJlY3RvcnkoY29uZmlnKQogCi0gICAgICAgICMg RmlsZSBsb2dnaW5nCi0gICAgICAgIGZoID0gbG9nZ2luZy5GaWxlSGFuZGxlcihjb25maWcuTE9H X0ZJTEUsIGVuY29kaW5nPSd1dGYtOCcpCisgICAgICAgICMgRmlsZSBsb2dnaW5nICMgUm90YXRl ZCBGaWxlIGxvZ2dpbmcKKyAgICAgICAgZnJvbSBwZ2FkbWluLnV0aWxzLmVuaGFuY2VkX2xvZ19y b3RhdGlvbiBpbXBvcnQgXAorICAgICAgICAgICAgRW5oYW5jZWRSb3RhdGluZ0ZpbGVIYW5kbGVy CisgICAgICAgIGZoID0gRW5oYW5jZWRSb3RhdGluZ0ZpbGVIYW5kbGVyKGNvbmZpZy5MT0dfRklM RSwKKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY29uZmlnLkxPR19S T1RBVElPTl9TSVpFLAorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBj b25maWcuTE9HX1JPVEFUSU9OX0FHRSwKKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgY29uZmlnLkxPR19ST1RBVElPTl9NQVhfTE9HUykKKwogICAgICAgICBmaC5zZXRM ZXZlbChjb25maWcuRklMRV9MT0dfTEVWRUwpCiAgICAgICAgIGZoLnNldEZvcm1hdHRlcihsb2dn aW5nLkZvcm1hdHRlcihjb25maWcuRklMRV9MT0dfRk9STUFUKSkKICAgICAgICAgYXBwLmxvZ2dl ci5hZGRIYW5kbGVyKGZoKQpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vdXRpbHMvZW5oYW5jZWRf bG9nX3JvdGF0aW9uLnB5IGIvd2ViL3BnYWRtaW4vdXRpbHMvZW5oYW5jZWRfbG9nX3JvdGF0aW9u LnB5Cm5ldyBmaWxlIG1vZGUgMTAwNjQ0CmluZGV4IDAwMDAwMDAwMC4uYjQ2YzUzNDIwCi0tLSAv ZGV2L251bGwKKysrIGIvd2ViL3BnYWRtaW4vdXRpbHMvZW5oYW5jZWRfbG9nX3JvdGF0aW9uLnB5 CkBAIC0wLDAgKzEsNDYgQEAKKyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjCisjCisjIHBnQWRtaW4gNCAtIFBv c3RncmVTUUwgVG9vbHMKKyMKKyMgQ29weXJpZ2h0IChDKSAyMDEzIC0gMjAyMSwgVGhlIHBnQWRt aW4gRGV2ZWxvcG1lbnQgVGVhbQorIyBUaGlzIHNvZnR3YXJlIGlzIHJlbGVhc2VkIHVuZGVyIHRo ZSBQb3N0Z3JlU1FMIExpY2VuY2UKKyMKKyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjCisKK2ltcG9ydCByZQor aW1wb3J0IGxvZ2dpbmcuaGFuZGxlcnMgYXMgaGFuZGxlcnMKKworCitjbGFzcyBFbmhhbmNlZFJv dGF0aW5nRmlsZUhhbmRsZXIoaGFuZGxlcnMuVGltZWRSb3RhdGluZ0ZpbGVIYW5kbGVyLAorICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGhhbmRsZXJzLlJvdGF0aW5nRmlsZUhhbmRs ZXIpOgorICAgICIiIgorICAgIEhhbmRsZXIgZm9yIGxvZ2dpbmcgdG8gYSBzZXQgb2YgZmlsZXMs IHdoaWNoIHN3aXRjaGVzIGZyb20gb25lIGZpbGUKKyAgICB0byB0aGUgbmV4dCB3aGVuIHRoZSBj dXJyZW50IGZpbGUgcmVhY2hlcyBhIGNlcnRhaW4gc2l6ZSwgb3IgYXQgY2VydGFpbgorICAgIHRp bWVkIGludGVydmFscworICAgICIiIgorICAgIGRlZiBfX2luaXRfXyhzZWxmLCBmaWxlbmFtZSwg bWF4X2J5dGVzPTEsIGludGVydmFsPTYwLCBiYWNrdXBfY291bnQ9MCwKKyAgICAgICAgICAgICAg ICAgZW5jb2Rpbmc9Tm9uZSwgd2hlbj0nTScpOgorICAgICAgICBtYXhfYnl0ZXMgPSBtYXhfYnl0 ZXMgKiAxMDAwMDAwCisgICAgICAgIGhhbmRsZXJzLlRpbWVkUm90YXRpbmdGaWxlSGFuZGxlci5f X2luaXRfXyhzZWxmLCBmaWxlbmFtZT1maWxlbmFtZSwKKyAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHdoZW49d2hlbiwKKyAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGludGVydmFsPWludGVydmFsLAorICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgYmFja3VwQ291 bnQ9YmFja3VwX2NvdW50LAorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgZW5jb2Rpbmc9ZW5jb2RpbmcpCisKKyAgICAgICAgaGFuZGxlcnMuUm90YXRp bmdGaWxlSGFuZGxlci5fX2luaXRfXyhzZWxmLCBmaWxlbmFtZT1maWxlbmFtZSwKKyAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBtb2RlPSdhJywKKyAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBtYXhCeXRlcz1tYXhfYnl0ZXMs CisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgYmFja3VwQ291 bnQ9YmFja3VwX2NvdW50LAorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIGVuY29kaW5nPWVuY29kaW5nKQorCisgICAgIyBUaW1lICYgU2l6ZSBjb21iaW5lZCBy b2xsb3ZlcgorICAgIGRlZiBzaG91bGRSb2xsb3ZlcihzZWxmLCByZWNvcmQpOgorICAgICAgICBy ZXR1cm4gaGFuZGxlcnMuVGltZWRSb3RhdGluZ0ZpbGVIYW5kbGVyLnNob3VsZFJvbGxvdmVyKHNl bGYsIHJlY29yZCkgXAorICAgICAgICAgICAgb3IgaGFuZGxlcnMuUm90YXRpbmdGaWxlSGFuZGxl ci5zaG91bGRSb2xsb3ZlcihzZWxmLCByZWNvcmQpCisKKyAgICAjIFJvbGwgb3ZlcnMgY3VycmVu dCBmaWxlCisgICAgZGVmIGRvUm9sbG92ZXIoc2VsZik6CisgICAgICAgIHNlbGYuc3VmZml4ID0g IiVZLSVtLSVkXyVILSVNLSVTIgorICAgICAgICBzZWxmLmV4dE1hdGNoID0gciJeXGR7NH0tXGR7 Mn0tXGR7Mn1fXGR7Mn0tXGR7Mn0tXGR7Mn0oXC5cdyspPyQiCisgICAgICAgIHNlbGYuZXh0TWF0 Y2ggPSByZS5jb21waWxlKHNlbGYuZXh0TWF0Y2gsIHJlLkFTQ0lJKQorICAgICAgICBoYW5kbGVy cy5UaW1lZFJvdGF0aW5nRmlsZUhhbmRsZXIuZG9Sb2xsb3ZlcihzZWxmKQo= --000000000000681f1505c320bcd9--