Re: Removing archived wal files on Master

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you everyone for ther help.
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@xxxxxxxxx>
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.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Fri, Feb 22, 2019 at 4:49 PM Michael King <michaelbking@xxxxxxxxxxx> wrote:
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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux