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

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.

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.


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> ] 
> 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 # 
>> 
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> 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 #