Re: slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 - Mailing list pgsql-performance

From Glyn Astill
Subject Re: slony rpm help slony1-95-2.2.2-1.rhel6.x86_64
Date
Msg-id 1879732441.636578.1465486362833.JavaMail.yahoo@mail.yahoo.com
Whole thread Raw
In response to slony rpm help slony1-95-2.2.2-1.rhel6.x86_64  (avi Singh <avisingh19811981@gmail.com>)
List pgsql-performance
> From: avi Singh <avisingh19811981@gmail.com>
>To: pgsql-performance@postgresql.org
>Sent: Saturday, 4 June 2016, 0:03
>Subject: [PERFORM] slony rpm help slony1-95-2.2.2-1.rhel6.x86_64
>
>
>
>Hi All
>         Can anyone please point me to location from where i can get slony slony1-95-2.2.2-1.rhel5.x86_64  rpm. I'm
upgradingdatabase from version 9.3 to 9.5. Current version of rpm we are using is  slony1-93-2.2.2-1.el5.x86_64 and the
onethat is available on postgresql website for 9.5 is slony1-95-2.2.4-4.rhel5.x86_64  which is not compatible and
throwsan error when i test the upgrade.  In the past i was able to find the 2.2.2-1 version rpm for previous versions
onpostgres website but not this time for postgresql 9.5 
>
>


What you'd be better off doing is installing Slony 2.2.4 on all your servers (or better a 2.2.5) rather than trying to
getthe older version.  If you can't get a package you could compile Slony yourself. 


The not compatible error you mention is most likely because you've failed to update the Slony functions.  See:


    http://slony.info/documentation/2.2/stmtupdatefunctions.html

Glyn


pgsql-performance by date:

Previous
From: Nicolas Paris
Date:
Subject: Re: array size exceeds the maximum allowed (1073741823) when building a json
Next
From: Jeff Janes
Date:
Subject: Re: Performance of LIKE/NOT LIKE when used in single query