: 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
