From: | Kamil Srot <kamil(dot)srot(at)nlogy(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Erik Jones <erik(at)myemma(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Tables dissapearing |
Date: | 2007-08-28 00:57:20 |
Message-ID: | 46D372F0.9070707@nlogy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
> 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
>
>
OK, I have the filenames noted and I do confirm, they all does exist now
under the base in the pgsql tree...
> 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.
>
>
There is not any manipulation with the structure of the DB, so it'll
stay the same...
Thank you!
--
Kamil
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2007-08-28 01:39:32 | Re: Tables dissapearing |
Previous Message | Tom Lane | 2007-08-28 00:27:15 | Re: Tables dissapearing |