Re: pg_restore
От
Joshua D. Drake
Тема
Re: pg_restore
Дата
Msg-id
1301527039.10914.70.camel@jd-desktop
Ответ на
Re: pg_restore (Mike Orr)
Список
Дерево обсуждения
pg_restore Mike Orr <sluggoster@gmail.com>
Re: pg_restore John R Pierce <pierce@hogranch.com>
Re: pg_restore Mike Orr <sluggoster@gmail.com>
Re: pg_restore "Joshua D. Drake" <jd@commandprompt.com>
Re: pg_restore John R Pierce <pierce@hogranch.com>
Re: pg_restore Marco Colombo <pgsql@esiway.net>
Re: pg_restore Merlin Moncure <mmoncure@gmail.com>
Re: pg_restore Mike Orr <sluggoster@gmail.com>
Re: pg_restore Scott Marlowe <scott.marlowe@gmail.com>
> > 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 по дате отправления
