From: | "Jason C(dot) 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: | 2006-03-31 16:50:16 |
Message-ID: | 602f2f2b0603310850k5bf032ffs76f44e53c5954eb7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alex bahdushka | 2006-03-31 17:20:29 | Re: PANIC: heap_update_redo: no block |
Previous Message | Joshua D. Drake | 2006-03-31 16:32:43 | Re: [Slightly OT] data model books/resources? |