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)
>