Tue Sep 29 16:25:10 PDT 2015
- Previous message: [Slony1-general] upgrade slony master / slave using pg_upgrade
- Next message: [Slony1-general] slony and bdr
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] upgrade slony master / slave using pg_upgrade
- Next message: [Slony1-general] slony and bdr
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list