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='/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...
-- 
(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)