Re: [GENERAL] Slony and local machine slave..(supernewbie question)

On Thu, Jul 30, 2009 at 9:36 AM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote:

On Thu, Jul 30, 2009 at 8:31 PM, Scott Mead<scott.lists@xxxxxxxxxxxxxxxx> wrote:

...snip...

>   It may make more sense to setup a dedicated PITR slave in your office, and
> refresh it every now and then.
>
> http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html

Thanks. This was useful. So much for my brainwave.

I certainly don't wish to lose the ALTER TABLE option if I go for
Slony method. Am I right to understand that the PITR setup is separate
from the whole Slony shebang, and that PITR stuff can be setup all
with just the main install of PG itself?

Exactly right.

--Scott