Обсуждение: Recovery with pg_xlog

Поиск
Список
Период
Сортировка

Recovery with pg_xlog

От
"Jason C. Leach"
Дата:
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