Problem of pg_wal filling up

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

Responses

Browse pgsql-admin by date

  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