Bracing against the wind  

Tuesday, November 03, 2009

Postgres Replication

There's a lot of talk about the lack of built-in replication for postgres. I have been using the "pg_comparator" method for slave updates.

This is essentially similar to an "rsync" for database tables. It works extremely well and has a low configuration overhead. You can use it to scale a single table out to dozens of servers, even choosing which fields to replicate.

It's also easy to install, configure and maintain - even code for.

Personally, I like it better than the builtin solution that they are discussing on postgres's lists. I wish a diff-patch shipping solution was in the running. For a lot of us, that's exactly what we need.


[View/Post Comments] [Digg] [] [Stumble]

Home | Email me when this weblog updates: | View Archive

(C) 2002 Erik Aronesty/DocumentRoot.Com. Right to copy, without attribution, is given freely to anyone for any reason.

Listed on BlogShares | Bloghop: the best pretty good | Blogarama | Technorati | Blogwise