Sun Oct 10 16:47:43 PDT 2004
- Previous message: [Slony1-general] external function libraries on non-build machine
- Next message: [Slony1-general] external function libraries on non-build machine
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Thanks for the reply. The situation is a little bit more complicated in that we are bundling up postgres and slony and installing binaries onto a "clean" Solaris system. The following changes got this working for me: 1) removed references to $libdir in slonik/dbutil.c (test LOAD commands for the two libraries) 2) removed references to PGSHARE in slonik/slonik.c, and replaced with a getenv() on an environment variable we always have defined in our environment 3) removed references to $libdir in slony1_funcs.sql and xxid.v74.sql, e.g. changed '$libdir/xxid' to just 'xxid' Thanks. - DAP >-----Original Message----- >From: hannu at skype.net [mailto:hannu at skype.net] >Sent: Sunday, October 10, 2004 4:06 AM >To: David Parker >Cc: Slony Mailing List; pgsql-general at postgresql.org >Subject: Re: [Slony1-general] external function libraries on >non-build machine > >> I have built slony 1.0.2 with postgres 7.4.5. This needs to be >> deployed on a system other than the one on which is was built. >> Somebody on our team had earlier gotten around the problem of not >> being able to move a postgres install by manually updating the >> pg_catalog.pg_proc table. But it seems like this worked *after* the >> procs calling external libraries were installed. With the >slony stuff >> I can't install the procs until the database has been >deployed on its >> target machine, so that hack doesn't seem to help me. >> >> Now I'm trying to run a slonik script on the new system, and I am >> getting the following error, which I assume is because $libdir no >> longer references the build file system: >> >> <stdin>:3: Initializing the cluster >> <stdin>:5: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: >could not >> access file "$libdir/xxid": No such file or directory > >You have to copy the xxid.so and slony1_funcs.so files to >where postgres extensions live on your target machine. on >debian this seems to be /usr/lib/postgres/lib/ > >this is the same place where you can find various pl >implementations find /usr/lib -name plpgsql.so should show you >the place > >------------ >Hannu > >
- Previous message: [Slony1-general] external function libraries on non-build machine
- Next message: [Slony1-general] external function libraries on non-build machine
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list