Re: pg_restore
От | Joshua D. Drake |
---|---|
Тема | Re: pg_restore |
Дата | |
Msg-id | 1301527039.10914.70.camel@jd-desktop обсуждение исходный текст |
Ответ на | Re: pg_restore (Mike Orr <sluggoster@gmail.com>) |
Список | 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
В списке pgsql-general по дате отправления: