Kamil Srot <kamil.srot@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
