Re: log shipping/DB recovery with PostgreSQL 7.4

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: log shipping/DB recovery with PostgreSQL 7.4
Дата
Msg-id 4640F857.9040400@commandprompt.com
обсуждение исходный текст
Ответ на Re: log shipping/DB recovery with PostgreSQL 7.4  ("Porell, Chris" <Chris.Porell@ceridian.com>)
Список pgsql-general
Porell, Chris wrote:
> Thanks for the info.
>
> What, then, is the best way to achieve my goal of having a "standby" DB that
> can be kept within 15 minutes or so in sync with the primary?  periodic
> pg_dump/restore?  Unfortunately, I can't upgrade right now.

www.slony.info

>
>
>
> -----Original Message-----
> From: Joshua D. Drake [mailto:jd@commandprompt.com]
> Sent: Tuesday, May 08, 2007 4:41 PM
> To: Porell, Chris
> Cc: 'pgsql-general@postgresql.org'
> Subject: Re: [GENERAL] log shipping/DB recovery with PostgreSQL 7.4
>
>
> Porell, Chris wrote:
>> I am trying to bring up a disaster recovery database using a cold-copy of
>> the datafiles on a different machine.  I've got all WAL files since this
>> copy was made.  Is it possible to make a 7.4 DB apply the WALs to the DB
>> when I bring it up?
>
> No, you need to be running >8.x.
>
> Sincerely,
>
> Joshua D. Drake
>


--

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


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

Предыдущее
От: "Porell, Chris"
Дата:
Сообщение: Re: log shipping/DB recovery with PostgreSQL 7.4
Следующее
От: Brent Wood
Дата:
Сообщение: Re: PG on Debian 4.0.x ?