From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Mike Orr <sluggoster(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_restore |
Date: | 2011-03-30 23:17:19 |
Message-ID: | 1301527039.10914.70.camel@jd-desktop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > 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
From | Date | Subject | |
---|---|---|---|
Next Message | Brendan Jurd | 2011-03-31 03:39:25 | Re: [HACKERS] Date conversion using day of week |
Previous Message | John R Pierce | 2011-03-30 23:14:38 | Re: pg_restore |