: Re: Huge archive log generate in Postgresql-13
On 4/19/22 21:31, Ram Pratap Maurya wrote:
> Dear Adrian,
>
> We are using binary replication and par day *pg_log_archive* total
> size is increase after upgrade for PG11 to PG13.
So what is pruning the WAL's in pg_log_archive?
Or
On 4/19/22 21:31, Ram Pratap Maurya wrote:
Dear Adrian,
We are using binary replication and par day *pg_log_archive* total size
is increase after upgrade for PG11 to PG13.
So what is pruning the WAL's in pg_log_archive?
Or to put it another way what is the purpose of pg_log_archive and how
;
pgsql-gene...@postgresql.org
Subject: Re: Huge archive log generate in Postgresql-13
On 4/18/22 21:41, Ram Pratap Maurya wrote:
> Dear Adrian,
>
> If we set parameter *"PG-WAL = replica"* in PG13 conf file , there
> is any issue in replication through PG_WAL
To: Adrian Klaver ; pgsql-gene...@postgresql.org
Cc: Manu Saxena
Subject: RE: Huge archive log generate in Postgresql-13
Dear Adrian,
We have two replica system one is Slave and other id DR server .
Salve server replicate from PG_WAL and DR system replicate from
pg_log_archive.
Can you please su
Ram Pratap Maurya
Sent: 19 April 2022 09:00
To: Adrian Klaver ; pgsql-gene...@postgresql.org
Cc: Manu Saxena
Subject: RE: Huge archive log generate in Postgresql-13
Dear Adrian,
We have two replica system one is Slave and other id DR server .
Salve server replicate from PG_WAL and DR system repl
Klaver [mailto:adrian.kla...@aklaver.com]
Sent: 18 April 2022 21:30
To: Ram Pratap Maurya ;
pgsql-gene...@postgresql.org
Cc: Manu Saxena
Subject: Re: Huge archive log generate in Postgresql-13
On 4/18/22 04:34, Ram Pratap Maurya wrote:
> Hi Support,
>
> We have upgraded postgresq
On 4/18/22 04:34, Ram Pratap Maurya wrote:
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.
Whe
On 4/18/22 07:34, Ram Pratap Maurya wrote:
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.
Ca
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 generate
