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