Re: Postmaster running out of discspace; Data corruption?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postmaster running out of discspace; Data corruption?
Date: 2005-04-05 16:11:44
Message-ID: 14224.1112717504@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hannes Dorbath <light(at)theendofthetunnel(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-04-05 16:15:49 Re: Vacuum time degrading
Previous Message Wes 2005-04-05 16:08:25 Re: Vacuum time degrading