Re: PANIC: corrupted item pointer
От | Jeff Davis |
---|---|
Тема | Re: PANIC: corrupted item pointer |
Дата | |
Msg-id | 1333748968.4738.5.camel@sussancws0025 обсуждение исходный текст |
Ответ на | Re: PANIC: corrupted item pointer (Janning Vygen <vygen@kicktipp.de>) |
Ответы |
Re: PANIC: corrupted item pointer
|
Список | pgsql-general |
On Sat, 2012-03-31 at 13:21 +0200, Janning Vygen wrote: > The OS was installed a few days before, the i installed the postgresql > instance. I configured my setup with a backup server by WAL archiving. > Then i tested some things and i played around with pg_reorg (but i > didn't use ist till then) then i dropped the database, shut down my app, > installed a fresh dump and restarted the app. Hmm... I wonder if pg_reorg could be responsible for your problem? I know it does a few tricky internal things. > Is it still worth to make the copy now? At the moment everything is > running fine. Probably not very useful now. > No, i didn't found any in my postgresql dirs. Should i have a core file > around when i see a segmentation fault? What should i look for? It's an OS setup thing, but generally a crash will generate a core file if it is allowed to. Use "ulimit -c unlimited" on linux in the shell that starts postgresql and I think that will work. You can test it by manually doing a "kill -11" on the pid of a backend process. > I have never done it before. But as everything runs fine at the moment > it's quite useless, isn't it? I meant a backtrace from the core file. If you don't have a core file, then you won't have this information. Regards, Jeff Davis
В списке pgsql-general по дате отправления: