Thu Nov 4 17:29:38 PST 2004
- Previous message: [Slony1-general] One cluster for all replications... or not?
- Next message: [Slony1-general] One cluster for all replications... or not?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] One cluster for all replications... or not?
- Next message: [Slony1-general] One cluster for all replications... or not?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list