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 propagated. Skytools (http://pgfoundry.org/projects/skytools/) has a considerably lower learning curve compared to Slony. Nothing wrong with Slony, but recovering from replication problems with skytools is far easier, and it's 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 a cluster and Slony versus Skytools) is my recommendation. Regards Henry
