On Apr 10, 2006, at 6:24 PM, Tom Lane wrote:
"Just Someone" <[EMAIL PROTECTED]> 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-na
Hi Tom,
> 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 alo
"Just Someone" <[EMAIL PROTECTED]> 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 fil
What is the best way to find the latest partial WAL file?
Based on my tests, using the mtime isn't 100% accurate, as if a
pg_start_backup/pg_stop_backup() operation is run, the .backup file
created might be newer than the last WAL file. It also seems that the
WAL file related to the backup is bein
