Thread: R: How robust is postgre in case of power failure?

R: How robust is postgre in case of power failure?

From
"Stefano Coletta"
Date:
I had problems when a power failure occurred on old postgres installations. I had to use pg_check to fix problems.

Now I have installed an UPS just to make a clean shutdown of the system. I strongly suggest you to purchase an UPS,
justto make a clean shutdown. 

--------------------------------------------------
                   xmedia
           New Media Agency
--------------------------------------------------
Stefano Coletta <mailto:coletta@xmedia.net>
Network Admin <http://www.xmedia.net>
via Francesco Benaglia, 13 - Tel. +39 06 588851
00153 Roma Italy fax +39 06 58885016
--------------------------------------------------

> -----Messaggio originale-----
> Da: aw-ml23@mw-itcon.de [mailto:aw-ml23@mw-itcon.de]
> Inviato: martedì 9 luglio 2002 9.46
> A: pgsql-admin@postgresql.org
> Oggetto: [ADMIN] How robust is postgre in case of power failure?
>
>
> Hi
>
> can anybody tell how robust postgre is in case of power
> failure? Will I loos
> data or integrity? I am using an ext3 filesystem.
>
> Thanks for your help!
>
> Regards,
>
> Andreas
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>

Re: R: How robust is postgre in case of power failure?

From
Naomi Walker
Date:
At 05:23 PM 7/9/02 +0200, Stefano Coletta wrote:
>I had problems when a power failure occurred on old postgres
>installations. I had to use pg_check to fix problems.
>
>Now I have installed an UPS just to make a clean shutdown of the system. I
>strongly suggest you to purchase an UPS, just to make a clean shutdown.

I agree a UPS/generators are good things, but don't the WAL's protect the
integrity of the data?

Re: R: How robust is postgre in case of power failure?

From
Robert Treat
Date:
Yes, that's the idea, so that even in an abrupt power failure you should
be protected against data loss. It wont save any transactions in
progress and don't forget that abrupt power loss could corrupt your file
system itself, so a ups would still be nice to have for a more graceful
shutdown. If you feel the need for more detail, dig around the mailing
list archives searching for 'fsync'.

Robert Treat

On Tue, 2002-07-09 at 12:47, Naomi Walker wrote:
> At 05:23 PM 7/9/02 +0200, Stefano Coletta wrote:
> >I had problems when a power failure occurred on old postgres
> >installations. I had to use pg_check to fix problems.
> >
> >Now I have installed an UPS just to make a clean shutdown of the system. I
> >strongly suggest you to purchase an UPS, just to make a clean shutdown.
>
> I agree a UPS/generators are good things, but don't the WAL's protect the
> integrity of the data?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)