> > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
