Sven Willenberger sven
Wed Mar 1 13:10:14 PST 2006
As the subject line would indicate I am wondering about any caveats with
using Slony to replicate tables between an 8.0.x and 8.1.x database.
Naturally I would be using the latest version of slony with the support
for 8.1.

The reason for this is that we have a main database that is running
8.0.x and is mainly data warehousing with some active querying traffic
-- it is fairly sizeable at this point (some 224G) so upgrading this via
pg_dump pg_restore will not be some minor afternoon activity. We have
satellite databases that are designed to offload the bulk of the queries
into their own copies of the certain tables maintained by the main
database. These "satellite" servers are going to upgraded (new hardware)
so I figured I would like to take advantage of the performance
improvements offered in 8.1.x of PostgreSQL. Will slony handle the
different versions of the databases and if so, are there any "gotchas"
of which I need to be aware?

Thanks,

Sven




More information about the Slony1-general mailing list