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

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.

--------------------------------------------------
xmedia
New Media Agency
--------------------------------------------------
Stefano Coletta <mailto:coletta(at)xmedia(dot)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(at)mw-itcon(dot)de [mailto:aw-ml23(at)mw-itcon(dot)de]
> Inviato: martedì 9 luglio 2002 9.46
> A: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org)
>