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:
0000000100000013000000A4.00AEE2F0.backup.done
0000000100000013000000DE.00B8A498.backup.done
I presume these correlate with the files in the pg_xlog directory that look
like so:
0000000100000013000000A4.00AEE2F0.backup
0000000100000013000000DE.00B8A498.backup
0000000100000013000000DF
0000000100000013000000E0
0000000100000013000000E1
0000000100000013000000E2
0000000100000013000000E3
0000000100000013000000E4
0000000100000013000000E5
0000000100000013000000E6
Given that list, does that mean that 0000000100000013000000DF is the in use
WAL file?
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954