Re: replication only
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
Import Notes
Reply to msg id not found: Pine.LNX.4.64.0808050919210.4935@minas.objectitReference msg id not found: Pine.LNX.4.64.0808050919210.4935@minas.objectit
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 a cluster and Slony versus Skytools) is my
recommendation.
This is probably good advice. For simple cases, Slony's sort of a
pain in the neck.
A
--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/