From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postmaster running out of discspace; Data corruption? |
Date: | 2005-04-05 16:40:40 |
Message-ID: | 4252b93b$0$5472$8fe63b2a@news.disputo.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
ok :)
Thank you
On 05.04.2005 18:11, Tom Lane wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | David Rysdam | 2005-04-05 16:41:03 | Check for existence of index |
Previous Message | Joseph Shraibman | 2005-04-05 16:24:02 | contrib/dbsize |