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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Just Someone" <just(dot)some(at)gmail(dot)com>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to find the latest (partial) WAL file
Date: 2006-04-10 23:24:39
Message-ID: 1681.1144711479@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Just Someone" <just(dot)some(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-04-10 23:29:32 Re: Workaround for custom aggregate which would need "internal" as statetype
Previous Message Just Someone 2006-04-10 22:41:23 How to find the latest (partial) WAL file