On Thu, Jul 30, 2009 at 9:36 AM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote:
Exactly right.
--Scott
On Thu, Jul 30, 2009 at 8:31 PM, Scott Mead<scott.lists@xxxxxxxxxxxxxxxx> wrote:
...snip...
Thanks. This was useful. So much for my brainwave.
> 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
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