Re: Production Backup and Recovery

Поиск
Список
Период
Сортировка
От John Moore
Тема Re: Production Backup and Recovery
Дата
Msg-id Pv607.11379$ck5.1203016@newsread2.prod.itd.earthlink.net
обсуждение исходный текст
Ответ на Re: Production Backup and Recovery  (Doug McNaught <doug@wireboard.com>)
Список pgsql-hackers
"Doug McNaught" <doug@wireboard.com> wrote in message
news:m38zi7dyfl.fsf@belphigor.mcnaught.org...
> "P. Dwayne Miller" <dmiller@espgroup.net> writes:
>
> > Is it documented somewhere how to do on-line backups and then how to
> > recover from some event using those backups with no (or minimum) loss of
> > data?
>
> Right now there is no PIT recovery.  All you can do is run pg_dump
> whenever you want to make a backup.  This  will take a consistent
> snapshot of the database and write it out as SQL code that will
> recreate the database..

By consistent... does that mean that committed transactions are completely
there, and uncommitted are not there at all?






В списке pgsql-hackers по дате отправления:

Предыдущее
От: Mike Cianflone
Дата:
Сообщение: way to pass NEW into function
Следующее
От: ncm@zembu.com (Nathan Myers)
Дата:
Сообщение: Re: SOMAXCONN (was Re: Solaris source code)