Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
Recovery with pg_xlog
- From: "Jason C. Leach" <jason(dot)leach(at)gmail(dot)com>
- To: jayati(dot)biswas(at)cmcltd(dot)com
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Recovery with pg_xlog
- Date: Fri, 31 Mar 2006 08:50:16 -0800
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
- Prev by Date: Re: [Slightly OT] data model books/resources?
- Next by Date: Re: PANIC: heap_update_redo: no block
- Previous by thread: Recovery with pg_xlog
- Next by thread: Chasing "signal 11" issues
- Indexes: