| Nuno Fernandes 2005-09-21, 11:24 am |
| 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@cl1');
>
> # STORE NODE
> store node (id = 2, event node = 1, comment = 'Node 2 - tux@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- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
> http://gborg.postgresql.org/mailman.../slony1-general
|