Re: Postmaster running out of discspace; Data corruption?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postmaster running out of discspace; Data corruption?
Дата
Msg-id 14224.1112717504@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Postmaster running out of discspace; Data corruption?  (Hannes Dorbath <light@theendofthetunnel.de>)
Ответы Re: Postmaster running out of discspace; Data corruption?  (Hannes Dorbath <light@theendofthetunnel.de>)
Список pgsql-general
Hannes Dorbath <light@theendofthetunnel.de> writes:
> one of our servers did accidently run out of discspace during a huge
> data load. Postmaster closed the connection with `no space left on
> device, cannot write x_log' or something similar. We have fsync=false on
> that machine. Do we have to fear data corruption?

No.  The reason PG treats out-of-xlog-space as a PANIC is exactly so
that it won't do anything it can't log safely.  Once you get past the
postmaster restart you're fine.

            regards, tom lane

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

Предыдущее
От: Wes
Дата:
Сообщение: Re: Vacuum time degrading
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum time degrading