BTW, I succeeded in installing slony 1.0.5 on another machine...
I suppose my test server begins to be real dirty... :-S
 
 
 
J?r?mie.


  _____  

De : J?r?mie LOPEZ [mailto:jlo at mgn.net] 
Envoy? : mercredi 3 novembre 2004 16:55
? : Jan Wieck
Cc : slony1-general at gborg.postgresql.org
Objet : RE: [Slony1-general] problem upgrading to 1.0.5





> -----Message d'origine----- 
> De : Jan Wieck [mailto:JanWieck at Yahoo.com <mailto:JanWieck at Yahoo.com> ] 
> Envoy? : mercredi 3 novembre 2004 16:12 
> ? : J?r?mie LOPEZ 
> Cc : slony1-general at gborg.postgresql.org 
> Objet : Re: [Slony1-general] problem upgrading to 1.0.5 
> 
> On 11/3/2004 4:12 AM, J?r?mie LOPEZ wrote: 
> 
> > As I still have problems installing the 1.0.5 (I even tried 
> to install 
> > it on another PostgreSQL server - a 7.3.4 one - and get the 
> same error message? 
> > could my server lack some module/library?), I wanted to try 
> upgrading 
> > from 
> > 1.0.2 at least to 1.0.4 or even 1.0.3, but it seems those 
> versions are 
> > not downloadable (permission denied on 
> > http://developer.postgresql.org/~wieck/slony1/download
<http://developer.postgresql.org/~wieck/slony1/download>  
> > <http://developer.postgresql.org/~wieck/slony1/download
<http://developer.postgresql.org/~wieck/slony1/download> > )... 
> 
> They are not intended to be downloadable because those 
> releases have been withdrawn. They would make no difference 
> with respect to the upgrade procedure anyway. 


That's what I tought, just wanted to be sure... 


> You said you have an installation with 2 PostgreSQL servers 
> on the same machine. Does that mean that you have 2 complete 
> separate PostgreSQL installations, with separate bin, share 
> and lib directories? If so, you also need to have the 
> PostgreSQL source trees for both installs and need to 
> configure and install Slony 2 times (one for each PG 
> install), so that the shared modules of Slony get installed 
> into both PostgreSQL lib directories. 

Well, that shouldn't be the problem: by "2 PostgreSQL servers" I meant in
fact 2 DATA directories, but I have indeed one unique PostgreSQL
installation... However, I will check this point anyway...

Thanks. 
  
  
> Jan 
> 
> > 
> > 
> > Is it expected? Or have you been able to download those files 
> > (slony1-1.0.3.tar.gz and slony1-1.0.4.tar.gz) and could you 
> send them to me? 
> > 
> > (I in fact still planned to upgrade to 1.0.5 but I need them to 
> > investiguate on my problem) 
> >   
> >   
> >   
> > J?r?mie. 
> >   
> > 
> > 
> > 
> > 
> ---------------------------------------------------------------------- 
> > ------ 
> > ---- 
> > De : J?r?mie LOPEZ [mailto:jlo at mgn.net <mailto:jlo at mgn.net>
<mailto:jlo at mgn.net <mailto:jlo at mgn.net> > 
> ] Envoy? : 
> > mardi 26 octobre 2004 17:59 ? : Jan Wieck Cc : 
> > slony1-general at gborg.postgresql.org 
> > Objet : RE: [Slony1-general] problem upgrading to 1.0.5 
> > 
> > 
> > 
> >> -----Message d'origine----- 
> >> De : Jan Wieck [mailto:JanWieck at Yahoo.com <mailto:JanWieck at Yahoo.com>  
> <mailto:JanWieck at Yahoo.com <mailto:JanWieck at Yahoo.com> > ] 
> >> Envoy? : mardi 26 octobre 2004 16:47 
> >> ? : J?r?mie LOPEZ 
> >> Cc : slony1-general at gborg.postgresql.org 
> >> Objet : Re: [Slony1-general] problem upgrading to 1.0.5 
> >> 
> >> On 10/26/2004 10:19 AM, J?r?mie LOPEZ wrote: 
> >> 
> >> > Thanks for replying Jan. 
> >> > 
> >> > I wouldn't have dare mailing the list without having checked the 
> >> > upgrade documentation, but maybe I missed something. 
> >> > Concerning the installation, I indeed just untared the 
> slony 1.0.5 
> >> > archive, launched a "configure", launched a "make install" 
> >> and checked 
> >> > the version number of slon and slonik (in the log of the 
> >> first one and with the new "-v" 
> >> > option of the second one). 
> >> 
> >> And you did that on all nodes in the cluster? 
> > 
> > I did (in fact, my 2 nodes - the master and the only slave - are 2 
> > PostgreSQL servers on the same machine). 
> > 
> >> And the slonik 
> >> script for upgrading stored procedures contained a separate 
> >> 
> >>      update functions (id = x); 
> >> 
> >> for every node in the cluster? 
> > 
> > I did (my slonik script contains a CLUSTER NAME, two ADMIN 
> CONNINFO and two 
> > UPDATE FUNCTIONS). 
> > I even tried to run the update functions after a brand new 
> install of the 
> > 1.0.5. 
> > 
> > In case it can be helpful: during the last 
> install-from-scratch of slony 
> > 1.0.5, my PostgreSQL master was in verbose mode, but I 
> can't find traces of 
> > the "slonyversion" function that seems to miss (although I 
> see the creation 
> > of the other slony functions)... 
> > 
> >> 
> >> 
> >> Jan 
> >> 
> >> > 
> >> > Do I need to do something more? Does something can prevent 
> >> the install 
> >> > to update what needs to be updated? 
> >> > 
> >> > 
> >> > J?r?mie. 
> >> > 
> >> > -----Message d'origine----- 
> >> > De : Jan Wieck [mailto:JanWieck at Yahoo.com <mailto:JanWieck at Yahoo.com>

> <mailto:JanWieck at Yahoo.com <mailto:JanWieck at Yahoo.com> > ] 
> > Envoy? : mardi 
> >> 26 octobre 
> >> > 2004 15:37 ? : J?r?mie LOPEZ Cc : 
> >> slony1-general at gborg.postgresql.org 
> >> > Objet : Re: [Slony1-general] problem upgrading to 1.0.5 
> >> > 
> >> > On 10/26/2004 7:08 AM, J?r?mie LOPEZ wrote: 
> >> >> Hi all, 
> >> >>  
> >> >> when I try to upgrade slony from 1.0.2 to 1.0.5, I get the 
> >> following 
> >> >> message (on slon start up) : 
> >> >> CONFIG main: slon version 1.0.5 starting up ERROR  cannot 
> >> get Slony-I 
> >> >> schema version - ERROR:  function 
> >> >> _SLONY_GENY_METIER_DV02.slonyversion() does not exist 
> >> >> HINT:  No function matches the given name and argument 
> >> types. You may 
> >> >> need to add explicit type casts. 
> >> >> ERROR  please upgrade Slony-I schema to version 1.0.5 
> FATAL  main: 
> >> >> Node has wrong Slony-I schema or module version loaded 
> >> > 
> >> > Please read the file README.upgrade who's content is also on the 
> >> > projects home page under "Upgrading from former Slony-I 
> versions" 
> >> > right underneath the link to the tarfile on http://slony.info
<http://slony.info>  
> > <http://slony.info/ <http://slony.info/> >  
> >> > 
> >> >> 
> >> >> I first tried the soft way (killing slon processes then calling 
> >> >> UPDATE FUNCTIONS for all nodes with slonik), then the hard way 
> >> >> (killing everything, dropping slony schema in the database then 
> >> >> reinitializing the cluster), but I always get this error... 
> >> > 
> >> > You did not completely install 1.0.5 on the machine running 
> >> the slonik 
> >> > script. Just replacing the executables doesn't do it. 
> >> > 
> >> > 
> >> > Jan 
> >> > 
> >> > 
> >> > 
> >> > 
> >> 
> -------------------------------------------------------------- 
> -------- 
> >> > -- 
> >> > 
> >> > _______________________________________________ 
> >> > Slony1-general mailing list 
> >> > Slony1-general at gborg.postgresql.org 
> >> > http://gborg.postgresql.org/mailman/listinfo/slony1-general
<http://gborg.postgresql.org/mailman/listinfo/slony1-general>  
> > <http://gborg.postgresql.org/mailman/listinfo/slony1-general
<http://gborg.postgresql.org/mailman/listinfo/slony1-general> >  
> >> 
> >> 
> >> -- 
> >> #============================================================= 
> >> =========# 
> >> # It's easier to get forgiveness for being wrong than for 
> >> being right. # 
> >> # Let's break this rule - forgive me.                         
> >>          # 
> >> #================================================== 
> >> JanWieck at Yahoo.com # 
> >> 
> > 
> > 
> > 
> > 
> > 
> -------------------------------------------------------------- 
> ---------- 
> > 
> > _______________________________________________ 
> > Slony1-general mailing list 
> > Slony1-general at gborg.postgresql.org 
> > http://gborg.postgresql.org/mailman/listinfo/slony1-general
<http://gborg.postgresql.org/mailman/listinfo/slony1-general>  
> 
> 
> -- 
> #============================================================= 
> =========# 
> # It's easier to get forgiveness for being wrong than for 
> being right. # 
> # Let's break this rule - forgive me.                         
>          # 
> #================================================== 
> JanWieck at Yahoo.com # 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20041104/0fffaabc/attachment-0001.html