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> )...


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> ] 
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> ] 
> 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> ]
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/>  
> > 
> >> 
> >> 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>  
> 
> 
> -- 
> #============================================================= 
> =========# 
> # 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/20041103/3e173667/attachment-0001.html