Re: Slony and local machine slave..(supernewbie question) - Mailing list pgsql-general

From Scott Mead
Subject Re: Slony and local machine slave..(supernewbie question)
Date
Msg-id d3ab2ec80907301053l31128bb6pc8739158b213704e@mail.gmail.com
Whole thread Raw
In response to Re: Slony and local machine slave..(supernewbie question)  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-general

On Thu, Jul 30, 2009 at 9:36 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
On Thu, Jul 30, 2009 at 8:31 PM, Scott Mead<scott.lists@enterprisedb.com> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL server listen on other port than 5432
Next
From: Jennifer Trey
Date:
Subject: Re: How do I run PG Tuning Wizard on Linux?