Database Replication with Slony-I

Linux Journal logo

Image via Wikipedia

Whether you need multiple instances of your database for high availability, backup or for a no-downtime migration to a new version, this versatile tool will keep all of them in sync.

Here follows a useful article found on Linux Journal about setting a Replication with Slony-I.

http://www.linuxjournal.com/article/7834?page=0,0

Slony configuration file

The blue/white elephant logo of the PostgreSQL...

Image via Wikipedia

This is an example of a Slony configuration file to use with the Slon process:

Changes applied to 2.0 also to HEAD

- Fix syntax error in tools/altperl/slon_watchdog.pl

- Add cleanup_interval example to sample slon.conf file

- Add cleanup_interval configuration configuration to regression tests
Per discussion on slony-bugs list with Cyril Scetbon
 Continue reading 

PostgreSQL – Distribuzione e Replicazione

I have found an interesting slide show on PostreSQL Replication and HA topics. This is on my mother language italian. As soon as I can I will translate it to English.

PostgreSQL – Distribuzione e Replicazione.