Hi,

I am new to PostgreSQL and now want to know how can I recover from a database crash.

I know pg_dump and pg_restore but with pg_dump all transactions between every pg_dump will be lost. I found WAL in the doc and seems with it I can archieve point-in-time recovery. But I don't know the exact steps of doing this.

Any input, link or tutorials will be greatly appreciated.

Thanks in advance.

Michael
_______________________________________
YM - Â÷½u°T®§
´Nºâ§A¨S¦³¤Wºô¡A§AªºªB¤Í¤´¥i¥H¯d¤U°T®§µ¹§A¡A·í§A¤W ºô®É´N¯à¥ß§Y¬Ý¨ì¡A¥ô¦ó»¡¸Ü³£ÉN¨«¥¢¡C
http://messenger.yahoo.com.hk

On Thu, Sep 28, 2006 at 22:16:19 +0800,
Chan Michael <michael_kychan@yahoo.com.hk> wrote:
> Hi,
>
> I am new to PostgreSQL and now want to know how can I recover from a database crash.

If you are just talking about the server dying unexpectedly, you recover
by restarting it. Doing this should recover all transactions.

Note that if your hard drives a lying to you about write completion, this
might not work.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match