Re: How to find the latest (partial) WAL file - Mailing list pgsql-general

From Tom Lane
Subject Re: How to find the latest (partial) WAL file
Date
Msg-id 1681.1144711479@sss.pgh.pa.us
Whole thread Raw
In response to How to find the latest (partial) WAL file  ("Just Someone" <just.some@gmail.com>)
Responses 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>)
List 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 by date:

Previous
From: "Just Someone"
Date:
Subject: How to find the latest (partial) WAL file
Next
From: Tom Lane
Date:
Subject: Re: Workaround for custom aggregate which would need "internal" as statetype