> > however, you might look at PITR and/or WAL log shipping rather than
> > dump/restore. this would only update new data, and when you playback the
> > WAL log on the backup server bring it up to whatever point in time you want.
>
> I looked at PITR and WAL, but it looks like I can't have the backup
> database running and answering queries while it's WAL'ing. I'd have to
> log in and switch it to normal mode and start the webapp, and that's
> what I may not be able to do if the backup server were needed.
You can if you are using 9.x, take a look at the HS stuff.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt