Re: replication for hot-standby?

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073