Wed Mar 1 13:10:14 PST 2006
- Previous message: [Slony1-general] Example of adding a table to an existing set ... ?
- Next message: [Slony1-general] Replicating between 8.0.x and 8.1.x databases
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Example of adding a table to an existing set ... ?
- Next message: [Slony1-general] Replicating between 8.0.x and 8.1.x databases
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list