Bob Lunney bob_lunney at yahoo.com
Tue Sep 29 16:25:10 PDT 2015
Mark,
Extensions are compiled forspecific PostgreSQL versions, so the slony libraries that were compiled for 9.2 will not run in 9.4.  You have to install the slony package or rpm that was compiled for 9.4, or recompile slony yourself.   Either option is fairly easy.  A short RTFM will yield the answer that works for you.
Regards,
Bob Lunney
      From: Mark Steben <mark.steben at drivedominion.com>
 To: slony <slony1-general at lists.slony.info> 
 Sent: Tuesday, September 29, 2015 5:23 PM
 Subject: [Slony1-general] upgrade slony master / slave using pg_upgrade
   
Good evening

Fairly simple question (I think) 
Can I use the pg_upgrade contrib module to upgrade from postgres 9.2 to 9.4 without having to
re-define and re-subscribe all of the slony replicated data?  My initial pg_upgrade tests are yelling at me that some slony libraries are not found in the new 9.4 binaries:

Could not load library "$libdir/slony1_funcs"
ERROR:  could not access file "$libdir/slony1_funcs": No such file or directory

Hopefully it is just and issue of copying the slony binaries from 9.2 to the same libraries in 9.4 on master and slave, or is a re-creation necessary?  (We are running slony 2.2.3) 

I did check on www.slony.info and didn't find any reference to pg_upgrade.

Thanks for your time and insights

-- 
Mark Steben 
 Database Administrator
@utoRevenue | Autobase  
  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






_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general


  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20150929/ae4b5dc7/attachment-0001.htm 


More information about the Slony1-general mailing list