| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Huge archive log generate in Postgresql-13 |
| Date: | 2022-04-18 12:10:08 |
| Message-ID: | de1e189b-e926-1558-6bf0-d505b296b12c@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-04-18 16:00:20 | Re: Huge archive log generate in Postgresql-13 |
| Previous Message | Ram Pratap Maurya | 2022-04-18 11:47:57 | Huge archive log generate in Postgresql-13 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Ho | 2022-04-18 12:21:07 | Re: Error dydl : image not found when trying to install pg on Catalina |
| Previous Message | Ram Pratap Maurya | 2022-04-18 11:47:57 | Huge archive log generate in Postgresql-13 |