From: | <soumik(dot)bhattacharjee(at)kpn(dot)com> |
---|---|
To: | <pgsql-admin(at)lists(dot)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Problem of pg_wal filling up |
Date: | 2020-01-31 16:20:11 |
Message-ID: | 2A91BEF8171A5349931391E0C721CC537D7903CA@CPEMS-KPN301.KPNCNL.LOCAL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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..
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2020-01-31 21:24:59 | Re: Problem of pg_wal filling up |
Previous Message | Ken Benson | 2020-01-30 16:43:59 | RE: pg_logical - for PG 9.59 running on windows server |