Re: the un-vacuumable table

"Andrew Hammond" <andrew.george.hammond@[EMAIL PROTECTED]
> writes:
> Does anyone else have any suggestions about what I can do to diagnose
this?

The whole thing is pretty mystifying, especially the ENOSPC write
failure on what seems like it couldn't have been a full disk.

> Jun 27 15:54:31 qadb2 postgres[92519]: [44-1] PANIC:  could not open
> relation 1663/16386/679439393: No such file or directory

I don't think anyone asked before --- after the restore fails with the
above, does the directory $PGDATA/base/16386/ exist?  Although WAL
recovery should attempt to create missing files, I think it won't
try to create missing directories.

			regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers