From: | Michael King <michaelbking(at)hotmail(dot)com> |
---|---|
To: | Vikas Gupta <vikasmanya1(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Removing archived wal files on Master |
Date: | 2019-02-22 12:24:04 |
Message-ID: | PS1PR03MB3464BFA71F430345F7505A69C17F0@PS1PR03MB3464.apcprd03.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Vikta,
The archived wals timestamp are as of last month (20 January 2019).
I believe Prince Pathria’s advice makes sense (remove archive folder and all files within it). I’m still somewhat confused by the correct usage of pg_archivecleanup and whether or not I need to use this in my current scenario.
On 22 Feb 2019, at 8:10 pm, Vikas Gupta <vikasmanya1(at)gmail(dot)com<mailto:vikasmanya1(at)gmail(dot)com>> wrote:
can you please see the latest time stamp of the WAl archives as archive_mode is off now, i am suspecting these are the old archive files.
Thanks and Regards
Vikas Gupta PMP
+91-987181913
+91-9953999863
On Fri, Feb 22, 2019 at 4:49 PM Michael King <michaelbking(at)hotmail(dot)com<mailto:michaelbking(at)hotmail(dot)com>> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Fabio Pardi | 2019-02-22 12:24:21 | Re: Removing archived wal files on Master |
Previous Message | Vikas Gupta | 2019-02-22 12:09:24 | Re: Removing archived wal files on Master |