Re: Huge archive log generate in Postgresql-13

Holger Jakobs <holger@xxxxxxxxxx> · Mon, 18 Apr 2022 14:10:08 +0200



    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
  

Attachment:
OpenPGP_signature

Description: OpenPGP digital signature