Re: Old WAL files under pg_xlog not getting delete

Поиск
Список
Период
Сортировка
От rammohan ganapavarapu
Тема Re: Old WAL files under pg_xlog not getting delete
Дата
Msg-id CALm_Vjhf4AJF_=rvOMmmwKcaN3CN0YNnm7Q8RwivpLio8G+i7A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Old WAL files under pg_xlog not getting delete  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Old WAL files under pg_xlog not getting delete  (Ron <ronljohnsonjr@gmail.com>)
Re: Old WAL files under pg_xlog not getting delete  (Scott Ribe <scott_ribe@elevated-dev.com>)
Re: Old WAL files under pg_xlog not getting delete  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Thank you all, but irrespective of count i have why is it keeping old files? and how is it using those files? Is there any processes that can flush or remove those files?

On Wed, Jan 30, 2019, 4:11 PM David G. Johnston <david.g.johnston@gmail.com wrote:
On Wed, Jan 30, 2019 at 5:00 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> Hmm ... I would recommend to keep the xlog files in a subdir, not the
> root of the filesystem.

They are in a subdir (under /opt/pgdata), and the OP seems likely to
have omitted the self/parent hidden directories during his check as
well.  Plus per the docs we actually expect 501 so there isn't a need
to account for 6 extra, just 5.

Dave

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Old WAL files under pg_xlog not getting delete
Следующее
От: Ron
Дата:
Сообщение: Re: Old WAL files under pg_xlog not getting delete