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

From Thomas F. O'Connell
Subject Re: How to find the latest (partial) WAL file
Date
Msg-id 6D547613-6F66-46A9-BA97-8688171A8723@sitening.com
Whole thread Raw
In response to Re: How to find the latest (partial) WAL file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Apr 10, 2006, at 6:24 PM, Tom Lane wrote:

> "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.

Seems like a natural candidate for a TODO item. I'm not familiar with
the relevant internals, but on the surface it seems like it might
even be a % item?

--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC

http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)


pgsql-general by date:

Previous
From: "Wei Wei"
Date:
Subject: Re: Date & Time with time zone
Next
From: Randall Lucas
Date:
Subject: Calculating a hash / fingerprint for a row / tuple