Problem of pg_wal filling up - Mailing list pgsql-admin

From
Subject Problem of pg_wal filling up
Date
Msg-id 2A91BEF8171A5349931391E0C721CC537D7903CA@CPEMS-KPN301.KPNCNL.LOCAL
Whole thread Raw
Responses Re: Problem of pg_wal filling up  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-admin

Dear Experts,

 

Post the setup of streaming replication –MASTER and one SLAVE in PostgreSQL 12 , the pg_wal in both MASTER/SLAVE are - filling up.

 

My MASTER is in archive log mode and SLAVE in no archive log mode.

 

MASTER

 

postgres=# show archive_command;

                                  archive_command

------------------------------------------------------------------------------------

test ! -f /data/tablespaces/archivedir/%f && cp %p /data/tablespaces/archivedir/%f

(1 row)

 

SLAVE

 

postgres=# show archive_command;

archive_command

-----------------

(disabled)

(1 row)

 

 

Is it advisable to change  default wal location (pg_wal)? Or any other options apart from using pg_archivecleanup?

 

Thanks..

 

pgsql-admin by date:

Previous
From: Ken Benson
Date:
Subject: RE: pg_logical - for PG 9.59 running on windows server
Next
From: Jeff Janes
Date:
Subject: Re: Problem of pg_wal filling up