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

2009-07-30 Thread Scott Mead
On Thu, Jul 30, 2009 at 9:36 AM, Phoenix Kiula wrote: > On Thu, Jul 30, 2009 at 8:31 PM, Scott Mead > 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

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

2009-07-30 Thread Phoenix Kiula
On Thu, Jul 30, 2009 at 8:31 PM, Scott Mead 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 bra

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

2009-07-30 Thread Scott Mead
On Thu, Jul 30, 2009 at 7:47 AM, Phoenix Kiula wrote: > I use a Mac OSX at work. And finally have a running PG install. > > So I'm thinking: can I use some mechanism to have my local PG server > (in our premises) as a slave mirror of the main live website server > (at our data center). > > > Woul