On Mar 12, 2013, at 4:13 PM, Tom Lane wrote: > Erik Jones <ejones@xxxxxxxxxxxxxx> writes: >> What's the best way to determine the age of the current WAL? Not the current segment, but the whole thing. Put another way: is there a way to determine a timestamp for the oldest available transaction in the WAL? > > Transaction commit and abort records carry timestamps, so you could > figure this out with something like pg_xlogdump. I don't know of any > canned solution though. Tom, Thanks, and sorry for any discontinuity in the rather long time it's taken for me to get on this reply (had a vacation). Anyway, will pg_xlogdump work with any previous versions of Postgres or will it be only 9.3+? For reference, the reason need to be able to do this is this: Given a set of snapshots (each taken with running pg_start_backup before and pg_stop_backup after) and a running server, I need to be able to determine whether or not any given snapshot will be usable for setting up a new standby. I know I could grab the info returned from pg_start_backup and store that as snapshot meta-data but I'm hoping to keep from having to make changes the existing snapshotting code, if possible. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
