A project called slony1 has a bolt-on replication toolset for PostgresSQL 7.x - it uses a daemon and a set of stored procedures to replicate table data across clusters.
The list of tables and sequences it replicates has to be hardwired (hurrah for introspection) and it needs a whole nest of perl(1) support tools to generate configs but it does what it says on the tin.
I found these notes hugely helpful in setting things up.
Leave a Reply
Recent articles
- MySQL replication health
(Tuesday, 09. 30. 2008 – No Comments) - Firewalls
(Friday, 09. 5. 2008 – No Comments) - Using Single Sign-On To Integrate Ning With An External Site
(Wednesday, 08. 20. 2008 – No Comments) - High Availability Rails Cluster
(Tuesday, 08. 19. 2008 – No Comments)