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

From Hannes Dorbath
Subject Re: Postmaster running out of discspace; Data corruption?
Date
Msg-id 4252b93b$0$5472$8fe63b2a@news.disputo.net
Whole thread Raw
In response to Re: Postmaster running out of discspace; Data corruption?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
ok :)

Thank you

On 05.04.2005 18:11, Tom Lane wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: contrib/dbsize
Next
From: David Rysdam
Date:
Subject: Check for existence of index