Re: Removing archived wal files on Master

Поиск
Список
Период
Сортировка
От Prince Pathria
Тема Re: Removing archived wal files on Master
Дата
Msg-id CAON0Dazq7HB3RsFdH4wfquCBX9CKo8uTnqCCb7CJ5yFjFBoZWQ@mail.gmail.com
обсуждение исходный текст
Ответ на Removing archived wal files on Master  (Michael King <michaelbking@hotmail.com>)
Список pgsql-admin
Дерево обсуждения
1. archive_mode = off
2. comment or delete archive_command parameter
3. reload the server
If you don't want archive logs, just rm the directory /var/lib/postgresql/9.3/main/archive/ -> there's no harm in deleting them as you said there's no streaming replication configured.
all your data is in pg_base and  and pg_wal/pg_xlog

Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com


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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Michael King
Дата:
Сообщение: Removing archived wal files on Master
Следующее
От: Vikas Gupta
Дата:
Сообщение: Re: Removing archived wal files on Master