On Thu, Sep 28, 2006 at 10:16:19PM +0800, Chan Michael wrote: > 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. Point in Time Recovery wasn't added until version 8.0. -- Jim Nasby jim@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
