On 09/29/2015 05:23 PM, Mark Steben wrote:

As I recall trying to pg_upgrade a slony node encounters two issues

1) Slony uses a catalog datatype (NAME or something like that) in some 
of the slony columns and this caused pg_upgrade to gripe

2) pg_upgrade resets (or at least used to) the xid rollover counter and 
this causes slony to get confused because the full 64bit xids slony uses 
appear to travel backwards.

In theory one could work around both of those issues, I can't say for 
sure if there are other issues.


> 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 <http://www.slony.info> and didn't find
> any reference to pg_upgrade.
>
> Thanks for your time and insights
>
> --
> *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
> <http://www.fb.com/DominionDealerSolutions>
> www.twitter.com/DominionDealer <http://www.twitter.com/DominionDealer>
> www.drivedominion.com <http://www.autorevenue.com/>
>
> <http://autobasedigital.net/marketing/DD12_sig.jpg>
>
>
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>