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..