Re: Database Size Limiting

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Database Size Limiting
Дата
Msg-id 40B64011.4000209@archonet.com
обсуждение исходный текст
Ответ на Re: Database Size Limiting  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
Joshua D. Drake wrote:
> Hello,
>
> You could use Filsystem quotas but I strongly suggest against it as it
> will probably bring about database corruption.

Ah - manual reference
http://www.postgresql.org/docs/current/static/disk-full.html

"24.2. Disk Full Failure

The most important disk monitoring task of a database administrator is
to make sure the disk doesn't grow full. A filled data disk may result
in subsequent corruption of database indexes, but not of the tables
themselves. If the WAL files are on the same disk (as is the case for a
default configuration) then a filled disk during database initialization
may result in corrupted or incomplete WAL files. This failure condition
is detected and the database server will refuse to start up. "

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Database Size Limiting
Следующее
От: "Matt Van Mater"
Дата:
Сообщение: Re: Connection log entries - random port number recorded