On Fri, Mar 7, 2008 at 12:27 AM, Christopher Browne <
cbbrowne at ca.afilias.info> wrote:

> Satya <satya461 at gmail.com> writes:
> >  I have compiled Slony 1.2.13 with Postgres 8.3. Can I use this slony to
> run with Postgres 8.2 or 8.1 ??
> >  Also I have seen when doing a configure with
> --libdir=3D'/some/other/path' , slony still copies its libraries (xxid.so=
,slony1_funcs.so)  to the PostgreSQL  lib directory
> > only and same is the case with  sql files . They always go in Postgres
> Share directory.
> >  So I wasn't able make Slony 1.2.13 which is compiled against 8.3 to
> work with Postgres 8.2. I  get this error
> >  <stdin>:22: PGRES_FATAL_ERROR load '$libdir/xxid';  - ERROR:  could not
> access file "$libdir/xxid": No such file or directory
> >   This is because i didn't compile slony against postgres 8.2 and
> couldn't xxid.so in PG 8.2 lib directory.
> >   Is there a way I can install Slony which is compiled using Postgres
> 8.3 installed *completely* in a different location (including lib) and use
> the same Slony which I
> > compiled using postgres 8.3 to  make it work with postgres 8.2 or 8.1 ??
> >   I am expecting some directory layout like this
> >   [/export/home/tmp/satya/slony-bin] 12:01:29 $ ls -RCF
> > .:
> > bin/            etc/            slon-tools.pm  lib/
> > ./bin:
> > show_configuration*        slonik*
> slonik_execute_script*     slonik_restart_node*       slony_logshipper*
> > slon*                      slonik_build_env*
> slonik_failover*           slonik_store_node*
> slony_show_configuration*
> > slon_kill*                 slonik_create_set*
> slonik_init_cluster*       slonik_subscribe_set*
> > slon_start*                slonik_drop_node*
> slonik_merge_sets*         slonik_uninstall_nodes*
> > slon_watchdog*             slonik_drop_set*
> slonik_move_set*           slonik_unsubscribe_set*
> > slon_watchdog2*            slonik_drop_table*
> slonik_print_preamble*     slonik_update_nodes*
> > ./etc:
> > slon_tools.conf-sample
> > ./lib:
> > slony1_funcs.so*  xxid.so*
> > Hope you understood the problem. Please do let me know if you need more
> information.
>
> You will need to recompile Slony-I against 8.1 or 8.2 if you want to
> use it with them, notably so that you get .so files that are
> compatible with those versions.
>
> There is no problem with running the pl/pgsql code against varying
> PostgreSQL releases, and it should be fine to use the executable
> binaries (e.g. - slon, slonik) against a different version of
> PostgreSQL, but the .so files likely need to be compiled "custom" for
> each release...


 Ok what I understood is  that  I need to build the shared libraries (
xxid.so nad slon1_funcs.so) for each version of Postgres 8.1 or 8.3
 and i can replace them so that I can use with other versions.

 I have a problem here. The shared libraries always reside in postgres lib
directory lets say here /usr/postgres/8.3/lib/ and when I wanted to use the
same slon binaries to use with /usr/postgres/8.2/bin, I have to copy
xxid.soand slony1_funcs.so to /usr/postgres/8.2/lib  to make it work
with Postgres
8.2

  Instead it would be nice to have  all the slony  binaries and libraries
under  a  single directory so that I can easily keep overwriting the .so
files.

  In a simple way I want to know 'Is it possible to install  xxid.so ,
slony1_funcs.so and .sql files in some other location of my choice?

 Thanks for the inputs given until now.

-Satya

>
> --
> (format nil "~S@~S" "cbbrowne" "cbbrowne.com")
> http://linuxdatabases.info/info/emacs.html
> "Not  me, guy. I  read the  Bash man  page each  day like  a Jehovah's
> Witness reads  the Bible.  No  wait, the Bash  man page IS  the bible.
> Excuse    me..."    (More   on    confusing   aliases,    taken   from
> comp.os.linux.misc)
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080307/=
6ce9cfce/attachment.htm