Re: [PERFORM] slony rpm help slony1-95-2.2.2-1.rhel6.x86_64

[Jan Wieck]

On Fri, Jun 3, 2016 at 7:03 PM, avi Singh 
wrote:

> 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.
>

There should not be one since Slony1-I v2.2.2 does not compile against
PostgreSQL 9.5.
9.5 requires at least Slony-I v2.2.4. I recommend upgrading Slony to 2.2.5
first.


Regards, Jan




> I'm upgrading database 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 one that is available on
> postgresql website for 9.5 is slony1-95-2.2.4-4.rhel5.x86_64
> 
>   which is not compatible and throws an error when i test the upgrade.
> In the past i was able to find the 2.2.2-1 version rpm for previous
> versions on postgres website but not this time for postgresql 9.5
>
>
>
> Thanks
> Avi
>
>
>
>
>


-- 
Jan Wieck
Senior Postgres Architect

Re: [PERFORM] slony rpm help slony1-95-2.2.2-1.rhel6.x86_64

[Glyn Astill]

> From: avi Singh 
>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 upgrading database 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 one that is available on postgresql website for 9.5 is 
> slony1-95-2.2.4-4.rhel5.x86_64  which is not compatible and throws an error 
> when i test the upgrade.  In the past i was able to find the 2.2.2-1 version 
> rpm for previous versions on postgres 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 get the 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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] slony rpm help slony1-95-2.2.2-1.rhel6.x86_64

[avi Singh]

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 upgrading database 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 one that is
available on postgresql website for 9.5 is slony1-95-2.2.4-4.rhel5.x86_64

  which is not compatible and throws an error when i test the upgrade.  In
the past i was able to find the 2.2.2-1 version rpm for previous versions
on postgres website but not this time for postgresql 9.5



Thanks
Avi