New News Entry

A new entry has been added to the news database.

Database Admin: http://www.postgresql.org/admin/edit_news.php?233

Submitted by: justin(at)postgresql(dot)org
Headline: Slony 1.0.4 (PostgreSQL Database Replication) released
Summary:

The Slony-I team is proudly presenting the 1.0.4 release of the most advanced replication solution for the most advanced Open Source Database in the world.

Story:

<strong>Release 1.0.4 available</strong>

The Slony-I team is proudly presenting the 1.0.4 release of the most advanced replication solution for the most advanced Open Source Database in the world.

<a href=\"http://www.slony.info\">www.slony.info</a>

The release tarball is available for download here:

<a href=\"http://developer.postgresql.org/~wieck/slony1/download/slony1-1.0.4.tar.gz\">slony1-1.0.4.tar.gz</a>

<strong>Upgrading from former Slony-I versions</strong>

Beginning with version 1.0.4 the slon replication engine refuses to work against any database that does not have the stored procedures for the same version loaded or where the shared object containing the C language support functions and the log trigger does not match the version number.

This means that the Slony installation on all nodes in a cluster must be upgraded at once.

The proper upgrade procedure is this:
<ol>
<li>Stop the slon replication engine on all nodes.</li>
<li>Install the new Slony version on all nodes.</li>
<li>Execute a slonik script containing the command:

&nbsp;&nbsp;update functions (id = );

for every node in the cluster.</li>
<li>Start all slon replication engines.</li>
</ol>

<strong>Libpq requirements</strong>

The multithreaded replication engine requires the libpq client library to be compiled with --enable-thread-safety on certain operating systems. Known are thus far Solaris and AIX. Other operating systems are known to not require this (Linux-X86, FreeBSD-X86, FreeBSD-Alpha, OpenBSD-Sparc64 and OSX). The configuration script is broken with respect to the --enable-thread-safety switch for Solaris.

Please apply this patch, configure and recompile libpq:

<a href=\"http://developer.postgresql.org/~wieck/slony1/download/threadsafe-libpq-742.diff.gz\">threadsafe-libpq-742.diff.gz.</a>

We will make patches for 7.3.x available on request.