Re: Slony error please help

Поиск
Список
Период
Сортировка
От avi Singh
Тема Re: Slony error please help
Дата
Msg-id CAETvN5heq4NgJ0Sn2wihwDyMprpXBgXJsU062q3x9LSkW=oZnw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slony error please help  (Venkata Balaji N <nag1010@gmail.com>)
Список pgsql-general
Дерево обсуждения
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.cmates.com user=repl password=';
node 3 admin conninfo = 'dbname=site host=pg-db03.qs01.sea1.cmates.com user=repl password=';

update functions ( id = 1 );
update functions ( id = 3 );
_EOF_

4. Start all slony processes

Upgrade executed successfully and replication is running fine since than 

On Thu, Jun 16, 2016 at 8:44 PM, Venkata Balaji N <nag1010@gmail.com> wrote:

On Fri, Jun 17, 2016 at 5:36 AM, avi Singh <avisingh19811981@gmail.com> 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 slony 2.2.2 version is not compatible with 9.5 so i upgraded  slony1-94-2.2.2-1.rhel5.x86_64 to slony1-94-2.2.4-4.rhel5.x86_64 which went well. 


Phase 2 problem

1. Back to upgrade testing now when i run the check_upgrade script which includes the command below

/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.2.2"
ERROR:  could not access file "$libdir/slony1_funcs.2.2.2": No such file or directory

How did you upgrade Slony ? Uninstall Slony, drop slony related schemas and re-install, re-configure slony from scratch ? or did you ensure SLONIK_UPDATE_FUNCTIONS has been executed successfully ?
 
Regards,
Venkata B N

Fujitsu Australia


В списке pgsql-general по дате отправления:

Предыдущее
От: Venkata Balaji N
Дата:
Сообщение: Re: Slony error please help
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Question about RUM-index