Recovery with pg_xlog

You can usually get the directory name by doing

SELECT dataname, oid FROM pg_databases;

To get the file name do:

SELECT relname, relfilenode FROM pg_class WHERE relname = 'tblName';

The relfilenode will tell you what numbed file belongs to the talbe. It's
not always OID, but it often is (don't just assume it will be the OID).

J.

--
........................................
.... Jason C. Leach
.... PGP Key: 0x62DDDF75
.... Keyserver: gpg.mit.edu