Le mardi 22 septembre 2009, Lawrence Giam a écrit :
> Hi All,

Hi !

> 
> 
> 
> I am trying to install Slony-I on Debian Etch with kernel version
> 2.6.18-6-686 and after googling around for information, I have some
> questions to ask.
> 
> 
> 
> 1.	I tried to search the online repository using apt-get and found
> that :
> 
> 	a.	Slony1 on Debian Etch is postgresql-8.1-slony1.2.1-1
> 	b.	Slony1 on Debian Lenny is postgresql-8.3-slony1.2.15-1
> 
> 2.	Looking at the Slony-I website, I found that Slony-I has got the
> following version available which I think I will need to build from
> source.
> 
> 	a.	1.2.17-rc.tar.bz2
> 	b.	1.2.16.tar.bz2
> 
> 3.	I tried going to www.backports.org <http://www.backports.org/>
> and look for Slony-I, the version they have is
> postgresql-8.1-slony1_1.2.1-1_i386.deb
> <http://ftp.debian.org/debian/pool/main/s/slony1/postgresql-8.1-slony1_1
> .2.1-1_i386.deb>  and postgresql-8.3-slony1_1.2.16-1_i386.deb
> <http://ftp.debian.org/debian/pool/main/s/slony1/postgresql-8.1-slony1_1
> .2.1-1_i386.deb>
> 
> 
> 
> Questions:
> 
> 1.	As my production server is running on Etch and PostgreSQL 8.1, I
> want to know which version of Slony-I should I install?

the lastest, if you don't have it in debian : you can repoart/ask the slony 
debian maintener, else you can build it your self or use the debian tools to 
backport (look at "apt-build" "apt-get source -b" etc...) 

> 2.	Looking at Slony-I website, if I plan to migrate PostgreSQL on
> the production server to version 8.3. Should I upgrade the OS to Lenny
> or build PostgreSQL from source to version 8.3 with the OS remaining at
> Debian Etch?
> 3.	What is the differences between Slony-I version 2.0.x and
> version 1.2.x.

major changes ... 

> 4.	If I install from the backports repository, what are the steps
> to patch Slony to the lastest version?

I am not sure you are walking the right way...

Etch will become outdated in not so long time. (not so long in a database 
server/system life) You probably want to upgrade to Lenny anyway.

Postgresql 8.3 is more strict about CASTing, some applications needs to be re-
coded (I mean they should be compliant if they are well coded already) 

I'll install postgresql 8.4+slony2 and debian Lenny, sure. If you want 
packages, you can do your own, it is pretty simple [1]; or ./configre make 
make install which work too :).

[1] http://www.debian.org/doc/manuals/debian-
reference/ch02.en.html#_porting_a_package_to_the_stable_system
> 
> Regards,
> 
> Lawrence Giam
> 
>   <http://www.globalitcreations.com>
> ........................................................................
> ..........................
> Lawrence Giam | Global IT Creations Pte Ltd |  Network Administrator
> website: http://www.globalitcreations.com
> phone: +65 6836 4768 ext 115| fax: + 65 6836 4736 | mobile: + 65 9758
> 7448
> 


-- 
----
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20090922/fc057a3c/attachment.pgp