On Tue, 2007-11-20 at 08:38 -0800, mailtolouis2020-postgres@xxxxxxxxx wrote: > > For e.g, if I did a pg_dump backup a week ago, and the system crash > today, but I'm able to get all the files > in /usr/local/pgsql/data/pg_xlog, can I still recover my database to > the latest state? No, pg_dump never allows any form of Point in Time Recovery. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly