Re: the un-vacuumable table
| От | Tom Lane |
|---|---|
| Тема | Re: the un-vacuumable table |
| Дата | |
| Msg-id | 9538.1215120923@sss.pgh.pa.us обсуждение |
| Ответ на | Re: the un-vacuumable table ("Andrew Hammond" <andrew.george.hammond@gmail.com>) |
| Ответы |
Re: the un-vacuumable table
|
| Список | pgsql-hackers |
"Andrew Hammond" <andrew.george.hammond@gmail.com> 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
В списке pgsql-hackers по дате отправления: