Re: recover corrupt DB?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: recover corrupt DB?
Дата
Msg-id 20090505195330.GU4476@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: recover corrupt DB?  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
Список pgsql-general
Dan Armbrust escribió:

> 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.

Did "cleared some space" include the pg_xlog directory or something in
the vicinity?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: PGSQL-to-MYSQL Migration: Error in a 'simple' inner join query
Следующее
От: CM J
Дата:
Сообщение: Postgres: Transaction Connections