Re: recover corrupt DB?
От | Dan Armbrust |
---|---|
Тема | Re: recover corrupt DB? |
Дата | |
Msg-id | 82f04dc40905040651h1c4bbacct72147c3e0f764e73@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: recover corrupt DB? (Craig Ringer <craig@postnewspapers.com.au>) |
Ответы |
Re: recover corrupt DB?
|
Список | pgsql-general |
> These reports seem to come up a bit, with disk full issues resulting in > the need to pg_resetxlog, dump, and re-initdb, but I wouldn't be too > shocked if they all turned out to be on xfs or something like that. > My particular disk-full condition was on ext2. Nothing exotic. Also, the process that filled the disk was postgres - if that makes any difference - I had left a debug level turned up in the postgres config file, and it was logging every single db query. Since it wasn't set up to remove old log files - it filled the disk. Nothing else unusual occurred that I'm aware of - things went weird for the lab tester, he cleared some space, rebooted the system, and postgres didn't come back online.
В списке pgsql-general по дате отправления: