I can confirm that my issue has now been resolved.
Just to recap:
Set postgresql.conf (WAL section):
wal_level = minimal
archive_mode = off
comment out the archive_command
Restart postgresql server
Ensure postgresql service is up and running
Delete the folder archive folder within /var/lib/postgresql/9.3/main/
Regards,
Michael
From: Shreeyansh Dba <shreeyansh2014@gmail.com> Sent: Friday, 22 February 2019 9:26 PM To: Michael King Cc: pgsql-admin Subject: Re: Removing archived wal files on Master
Hi Michael,
I suspect that your DB parameters are set to default and database is not running in an archive mode as archive_mode = off , I believe PostgreSQL won't write archives when archive_mode is off and WAL archival cannot be enabled when wal_level is "minimal".
I assume the existing 200GB worth of archived wal files are old where you can verify by checking the timestamp of the Wal files and remove.
If you want to disable/enable archive_command you can simply comment/uncomment parameter and reload the server to affect but for
enabling archive_mode = on server required a restart.
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.