Re: [GENERAL] Slony error please help

2016-07-17 Thread Jan Wieck
On Sun, Jul 17, 2016 at 12:47 AM, Jan Wieck wrote: > > The only thing I can imagine would be that there is another slony cluster > (or > remnants of it) hanging around in the 9.4 installation, possibly in > another database. > > That does reproduce the problem. I ran the new doc/pgbench-tutorial

Re: [GENERAL] Slony error please help

2016-07-16 Thread Jan Wieck
On Thu, Jun 16, 2016 at 3:36 PM, avi Singh wrote: > /usr/pgsql-9.5/bin/pg_upgrade -b /usr/pgsql-9.4/bin/ -B > /usr/pgsql-9.5/bin/ -d /var/lib/pgsql/cmates1/data/ -D > /var/lib/pgsql/cmates1/data/9.5/ -p 5432 -P 5433 -c > > > it throws this error > > Could not load library "$libdir/slony1_funcs.2.

Re: [GENERAL] Slony error please help

2016-06-16 Thread avi Singh
1. Stoped slon process on both provider and subscriber nodes 2. installed slony1-94-2.2.4-4.rhel5.x86_64 on both nodes 3. ran the script listed below #!/bin/bash /usr/pgsql-9.4/bin/slonik <<_EOF_ cluster name = slon_cluster_cmates; node 1 admin conninfo = 'dbname=site host=site-db01.qs01.sea1.cmat

Re: [GENERAL] Slony error please help

2016-06-16 Thread Venkata Balaji N
On Fri, Jun 17, 2016 at 5:36 AM, avi Singh wrote: > I am working on a project to upgrade postgresql from 9.4 to 9.5 we use > slony for replication > > > Phase 1 problem > > 1. We had slony version slony1-94-2.2.2-1.rhel5.x86_64 installed when i > tried testing upgrade on my test env it failed coz

[GENERAL] Slony error please help

2016-06-16 Thread avi Singh
I am working on a project to upgrade postgresql from 9.4 to 9.5 we use slony for replication Phase 1 problem 1. We had slony version slony1-94-2.2.2-1.rhel5.x86_64 installed when i tried testing upgrade on my test env it failed coz slony 2.2.2 version is not compatible with 9.5 so i upgraded sl