Nevermind :P

Needed slony installed and running in second node..



Thanks
Nuno Fernandes


On Wednesday 21 September 2005 16:16, Nuno Fernandes wrote:
> Hello,
>
> I've installed postgresql 7.3.10 using redhat rpms and included devel
> package.
>
> I've  installed slony using
>
> ./configure --includedir /usr/include/pgsql --with-perltools=/usr/bin
> --datadir /usr/share/pgsql --sysconfdir=/etc --with-pglibdir=/usr/lib/pgsql
> make
> make install
>
> Next i've started postgresql using service postgresql start.
> All went ok.
>
> When i try the following slonik script
> # INIT CLUSTER
> cluster name = tuxcluster;
>  node 1 admin conninfo='host=cl1 dbname=tux user=slony port=5432
> password=123456';
>  node 2 admin conninfo='host=cl2 dbname=tux user=slony port=5432
> password=123456';
>   init cluster (id = 1, comment = 'Node 1 - tux at cl1');
>
> # STORE NODE
>   store node (id = 2, event node = 1, comment = 'Node 2 - tux at cl2');
>   echo 'Set up replication nodes';
>
> # STORE PATH
>   echo 'Next: configure paths for each node/origin';
>   store path (server = 2, client = 1, conninfo = 'host=cl2 dbname=tux
> user=slony port=5432 password=123456');
>   store path (server = 1, client = 2, conninfo = 'host=cl1 dbname=tux
> user=slony port=5432 password=123456');
>
> # STORE LISTEN
>   store listen (origin = 1, receiver = 2, provider = 1);
>   store listen (origin = 2, receiver = 1, provider = 2);
>   echo 'Replication nodes prepared';
>   echo 'Please start a slon replication daemon for each node';
>
> I get the error:
>
> <stdin>:9: PGRES_FATAL_ERROR load '$libdir/xxid';  - ERROR:  LOAD: could
> not open file '$libdir/xxid': No such file or directory
> <stdin>:9: Error: the extension for the xxid data type cannot be loaded in
> database 'host=cl2 dbname=tux user=slony port=5432 password=123456'
>
> I've read the faq regarding this issue and i don't have any other
> postgresql build environment. I've straced postgresql and it
> opens /usr/lib/pgsql/xxid.so.
>
> Thanks
> Nuno Fernandes
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general