PostgreSQL Discussion - Recovery with pg

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Recovery with pg_xlog

Jason C. Leach

2006-03-31, 11:28 am

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

Sponsored Links