Re: [GENERAL] replication only

2008-08-05 Thread Andrew Sullivan
On Tue, Aug 05, 2008 at 06:03:19AM +0200, Henry wrote: > just much simpler to use -- not as flexible and as powerful as Slony, but > if all you need to do is replicate some tables with minimum fuss and > without having to learn a new language, then Skytools (based on my > personal experience with

Re: [GENERAL] replication only

2008-08-05 Thread Scott Marlowe
On Tue, Aug 5, 2008 at 7:34 AM, Bill Moran <[EMAIL PROTECTED]> wrote: > In response to Jef Peeraer <[EMAIL PROTECTED]>: > > You'd probably be best with Slony, just don't replicate that 1 table > that you'll need to write to. That's one of my favorite things about slony. -- Sent via pgsql-general

Re: [GENERAL] replication only

2008-08-05 Thread Henry
On Tue, August 5, 2008 9:21 am, Jef Peeraer wrote: > > i read about the replication possibilities with postgresql. If i just need > some replication ( without failover stuff ) to 1 standby server, what > would be the best option to go with. Slony i presume, although schema > chanages are not propag

Re: [GENERAL] replication only

2008-08-05 Thread Bill Moran
In response to Jef Peeraer <[EMAIL PROTECTED]>: > > On Tue, 5 Aug 2008, Bill Moran wrote: > > > In response to Jef Peeraer <[EMAIL PROTECTED]>: > > > > > > i read about the replication possibilities with postgresql. If i just > > > need > > > some replication ( without failover stuff ) to 1 st

Re: [GENERAL] replication only

2008-08-05 Thread Jef Peeraer
On Tue, 5 Aug 2008, Bill Moran wrote: > In response to Jef Peeraer <[EMAIL PROTECTED]>: > > > > i read about the replication possibilities with postgresql. If i just need > > some replication ( without failover stuff ) to 1 standby server, what > > would be the best option to go with. > > Yo

Re: [GENERAL] replication only

2008-08-05 Thread Bill Moran
In response to Jef Peeraer <[EMAIL PROTECTED]>: > > i read about the replication possibilities with postgresql. If i just need > some replication ( without failover stuff ) to 1 standby server, what > would be the best option to go with. Your description of you requirements is very lacking, so

Re: [GENERAL] replication only

2008-08-05 Thread Raymond O'Donnell
On 05/08/2008 08:21, Jef Peeraer wrote: would be the best option to go with. Slony i presume, although schema chanages are not propagated. Schema changes *are* propagated in Slony, using the EXECUTE SCRIPT statement: http://www.slony.info/documentation/stmtddlscript.html Ray. ---

[GENERAL] replication only

2008-08-05 Thread Jef Peeraer
i read about the replication possibilities with postgresql. If i just need some replication ( without failover stuff ) to 1 standby server, what would be the best option to go with. Slony i presume, although schema chanages are not propagated. thanks jef peeraer -- Sent via pgsql-general