Good afternoon,

I am attempting to run pg_upgrade with the link option to upgrade from
postgres 9.2.12 to 9.4.8. Within the current 9.2.12 setup I have
slony1-2.2.3 running.

This is what I have attempted so far:
 1. installed postgres 9.4.8 on the same file system as 9.2 from tarball
source
 1. killed slony (on 9.2)
 2. stopped postgres
 3. ran 9.4.8 initdb
 4. installed slony1-2.2.3 on the new 9.4.8 setup from tarball source (here
is the command)
    ./configure --prefix=/usr/local/postgresql-9.4.8/bin
--with-pgconfigdir=/usr/local/postgresql-9.4.8/bin
--with-perltools=/usr/local/postgresql-9.4.8/bin
--with-pglibdir=/usr/local/postgresql-9.4.8/lib
--with-pgpkglibdir=/usr/local/postgresql-9.4.8/lib
 make
 make install

 5. attempted pg_upgrade (here is the command)
   /usr/local/postgresql-9.4.8/bin/pg_upgrade  -b
/usr/local/postgresql-9.2.11/bin -B /usr/local/postgresql-9.4.8/bin -d
/data/PSQL_9.2 -D /data/PSQL_9.4 -k -v &

I am now getting an error from this indicating a version mismatch:
   Could not load library "$libdir/slony1_funcs.2.2.3"
ERROR:  incompatible library "/usr/local/postgresql-9.4.8/lib/
slony1_funcs.2.2.3.so": version mismatch
DETAIL:  Server is version 9.4, library is version 9.2.

I then installed slony1-2.2.5 with the above command, ran the same
pg_upgrade command and got the exact same error. Then I deleted the
slony1_funcs.2.2.3.so file from my library directory leaving the
slony1_funcs.2.2.5.so and attempted the upgrade.  This time it errored out
with a NOT FOUND condition on the slony1_funcs.2.2.3.so.  So I'm not sure
what to do next.  I looked at slony.info to see if it shed any light on
compatibilities between slony versions and postgres versions and didn't
find anything.

A note: without slony installed in either instance the upgrade is
successful.

Any help / insight appreciated.  Thank you



-- 
*Mark Steben*
 Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
  CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20160726/4623cb29/attachment.htm