| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Kamil Srot <kamil(dot)srot(at)nlogy(dot)com> |
| Cc: | Erik Jones <erik(at)myemma(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tables dissapearing |
| Date: | 2007-08-28 00:27:15 |
| Message-ID: | 11127.1188260835@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Kamil Srot <kamil(dot)srot(at)nlogy(dot)com> writes:
> Erik Jones wrote:
>> Have you verified that the table's files are still on disk after
>> it's "disappeared"?
> Do not have any idea how to do it... I wasn't able to access it using
> any DML/DDL commands... can try it on a binary backup of the damaged DB
> if you'll guide me...
Make a note now of the table's "relfilenode" value (it'll be different
in each database), and confirm that you see it in the filesystem. After
the next disappearance, see if anything's still there. For background
read
http://www.postgresql.org/docs/8.2/static/storage.html
Note that certain operations like TRUNCATE and CLUSTER change the
relfilenode, so if you're using any of those then it might get harder to
track where the file is.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kamil Srot | 2007-08-28 00:57:20 | Re: Tables dissapearing |
| Previous Message | Kamil Srot | 2007-08-28 00:07:17 | Re: Tables dissapearing |