> -----Message d'origine-----
> De : Jan Wieck [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] 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
> > 
> >> 
> >> 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
> 
> 
> --
> #=============================================================
> =========#
> # 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/20041026/0092aaf0/attachment.html