Re: Postmaster running out of discspace; Data corruption? - Mailing list pgsql-general

From Tom Lane
Subject Re: Postmaster running out of discspace; Data corruption?
Date
Msg-id 14224.1112717504@sss.pgh.pa.us
Whole thread Raw
In response to Postmaster running out of discspace; Data corruption?  (Hannes Dorbath <light@theendofthetunnel.de>)
Responses Re: Postmaster running out of discspace; Data corruption?  (Hannes Dorbath <light@theendofthetunnel.de>)
List 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 by date:

Previous
From: Wes
Date:
Subject: Re: Vacuum time degrading
Next
From: Tom Lane
Date:
Subject: Re: Vacuum time degrading