On Tue, 2007-07-10 at 12:44 -0700, Ben wrote: > ...which I then need to tokenize in order to find which archived wal > files I'll need to keep as part of the backup. For instance, that > output above will result in a WAL file named like so:
Try using pg_xlogfile_name() http://www.postgresql.org/docs/8.2/static/functions-admin.html#FUNCTIONS-ADMIN-BACKUP-TABLE -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match