Removing archived wal files on Master

From: Michael King <michaelbking(at)hotmail(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Removing archived wal files on Master
Date: 2019-02-22 11:19:32
Message-ID: PS1PR03MB34647FD6CE34ED431CAA0DC3C17F0@PS1PR03MB3464.apcprd03.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I recently acquired a legacy server. This is running Postgresql 9.3 on Ubuntu 16.04.
There is around 200GB worth of archived wal files (~12,500 files) located on /var/lib/postgresql/9.3/main/archive.
I have checked and can confirm that this is a standalone server without any Replication setup and no secondary/slave server talking to it.

Checking the /etc/postgresql/9.3/main/postgresql.conf file (write ahead log section), shows the following:
wal_level = minimal
archive_mode = off
archive_command = 'test ! -f /var/lib/postgresql/9.3/main/archive/%f && cp -i %p /var/lib/postgresql/9.3/main/archive/%f </dev/null'

Replication section shows all default values.

Could you please advice how I can cleanup all of these 200GB worth of files.
I've searched through numerous postgresql books/blogs/articles which all have very good advise on how to setup wal archiving but unfortunately not on how to disable it.

Kind regards,
Michael

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Prince Pathria 2019-02-22 11:28:49 Re: Removing archived wal files on Master
Previous Message Peter Eisentraut 2019-02-21 15:30:53 Re: Regarding postgreSQL performance on DRAM