On Wed, 2005-09-28 at 12:08 -0500, Kris Kiger wrote: > My question then is, how do we tell which wal log is X (the one > currently being written to)? You don't say why you need to know? 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. Don't touch the files or you might interfere with the archiver's activities. Best Regards, Simon Riggs ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
