Re: replication for hot-standby?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: replication for hot-standby?
Дата
Msg-id 200507051651.j65GpSU17913@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: replication for hot-standby?  (Brad Nicholson <bnichols@ca.afilias.info>)
Список pgsql-admin
Brad Nicholson wrote:
> It totally depends on your enviornment.  We use Slony in a 24x7x365
> production enviornment.  Usage requires that you know what your doing,
> and  fair amount of care and planning when using it.  But Slony was
> never designed with the intent of being a click and forget type system.
>
> If you have environement where the schema is not stable, replicating
> with Slony will likely take a lot of work, but can be done safely.  If
> you don't have control over your schema changes (ie a web hosting
> environement where the end user can change the schema), it's certainly
> out of the picture.  In that scenario, I think you're going to have a
> hard time finding a replication engine that will let you have a hot
> standyby.

Seems such a case should use xlog shipping and loading into a hot
standby, which we don't support yet.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Brad Nicholson
Дата:
Сообщение: Re: replication for hot-standby?
Следующее
От: jose fuenmayor
Дата:
Сообщение: problems with pgadmin 3