On Fri, 30 Sep 2005, Simon Riggs wrote:
> You don't say why you need to know?
Not sure why Kris needs to know, but I need to know for PITR and keeping the
latest WAL file saved by a script which runs every few minutes as my client
does not turn over WAL files very often (about 4/day).
> If you really care, you can look at the status files in the
> archive_status directory underneath pg_xlog. This is where the archiver
> checks to see for notifications of filled WAL files, then clears the
> notification afterwards. Only filled WAL filenames are shown.
I see lots of items like this:
I presume these correlate with the files in the pg_xlog directory that look
Given that list, does that mean that 0000000100000013000000DF is the in use
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
In response to
pgsql-admin by date
|Next:||From: Tomeh, Husam||Date: 2005-09-30 17:01:41|
|Subject: Re: Backing up several tables using pg_dump -t|
|Previous:||From: Rytis||Date: 2005-09-30 16:14:44|
|Subject: data files corruption after server crash|