PostgreSQL replication

Thursday, 3. 11. 2005  –  Category: all, sw

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