public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ram Pratap Maurya <[email protected]>
To: [email protected] <[email protected]>
Cc: Ram Pratap Maurya <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: RE: Huge archive log generate in Postgresql-13
Date: Thu, 21 Apr 2022 05:54:29 +0000
Message-ID: <KL1PR0601MB44330ACB52188F35E6D6926EF0F49@KL1PR0601MB4433.apcprd06.prod.outlook.com> (raw)
In-Reply-To: <KL1PR0601MB4433CD9FFC0FA06AD7CA9660F0F49@KL1PR0601MB4433.apcprd06.prod.outlook.com>
References: <KL1PR0601MB4433D6A72DE1CA03D9D6F75DF0F39@KL1PR0601MB4433.apcprd06.prod.outlook.com>
<KL1PR0601MB4433E3B0BBCA25042C3DAFB3F0F39@KL1PR0601MB4433.apcprd06.prod.outlook.com>
<[email protected]>
<CWXP123MB3959D7C4AB99BE0D1D6F38F4A0F39@CWXP123MB3959.GBRP123.PROD.OUTLOOK.COM>
<CAAiDzScZ_WcuOf13Oo=_=MbPxfCWc_1ose4kL=ZYEfhr1Z8seg@mail.gmail.com>
<KL1PR0601MB4433CD9FFC0FA06AD7CA9660F0F49@KL1PR0601MB4433.apcprd06.prod.outlook.com>
Dear Holger,
we have one slave server and one DR server.
salve server working on streaming replication and DR server replicate with Archive log.
if we change "wal_level " parameter value to “replica” there any impact in existing server (Salve and DR) replication?
Please suggest .
Regards,
Ram Pratap.
From: Ram Pratap Maurya
Sent: 21 April 2022 09:49
To: Ram Pratap Maurya <[email protected]>
Subject: FW: Huge archive log generate in Postgresql-13
---------- Forwarded message ---------
From: Clive Swan <[email protected]<mailto:[email protected]>>
Date: Tue, Apr 19, 2022 at 12:45 AM
Subject: Re: Huge archive log generate in Postgresql-13
To: Holger Jakobs <[email protected]<mailto:[email protected]>>, [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>>
Grenting,
Is your logging set to high verbosity??
Usually use high verbosity for debugging, then change to low verbosity.
Clive
________________________________
From: Holger Jakobs <[email protected]<mailto:[email protected]>>
Sent: Monday, 18 April 2022, 13:10
To: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>>
Subject: Re: Huge archive log generate in Postgresql-13
wal_level = hot_standby # minimal, replica, or logical
# (change requires restart)
Set wal_level to one of the allowed values. It's possible that your value gets interpreted as logical, thus creating larger wal entries.
Am 18.04.22 um 13:47 schrieb Ram Pratap Maurya:
Hi Support,
We have upgraded postgresql DB from version 11 to 13 . after upgrade to 13 huge archive log generate in system .
Before upgrade per day 120GB to 150 GB log generated but after upgrade per day approx. 250 to 300 GB log generated.
Can you please suggest why huge archive log generated after upgrade there any configure setting or this is Postgresql-13 behaviour.
Postgresql-13 Postgresql conf file attached for your references.
Regards,
Ram Pratap.
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
[application/octet-stream] postgresql.conf (27.6K, 3-postgresql.conf)
download
view thread (17+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: RE: Huge archive log generate in Postgresql-13
In-Reply-To: <KL1PR0601MB44330ACB52188F35E6D6926EF0F49@KL1PR0601MB4433.apcprd06.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox