Re: How to find the latest (partial) WAL file

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to find the latest (partial) WAL file
Дата
Msg-id 1681.1144711479@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to find the latest (partial) WAL file  ("Just Someone" <just.some@gmail.com>)
Ответы Re: How to find the latest (partial) WAL file  ("Just Someone" <just.some@gmail.com>)
Re: How to find the latest (partial) WAL file  ("Thomas F. O'Connell" <tfo@sitening.com>)
Список pgsql-general
Дерево обсуждения 
"Just Someone" <just.some@gmail.com> writes:
> Is there a way to discover what is the real current WAL file?

If you sort first by mtime and second by file name you should find the
right one in all cases, ie, take the latest mtime among the
properly-named files, breaking ties by taking the higher filename.

It'd probably be better if we had a function to report this, but
you can get along without one.

            regards, tom lane

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

Предыдущее
От: "Just Someone"
Дата:
Сообщение: How to find the latest (partial) WAL file
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Workaround for custom aggregate which would need "internal" as statetype