Re: Database Synchronization

Hello,

Thanks Andrew for the solution. I have successfully installed following rpm
<< postgresql-slony1-engine-1.1.5-1_PG8.1.4.i686.rpm >> available at
http://main.slony.info/downloads/1.1/rpm/.

But when I am trying to set a cluster its throwing a following error:
<stdin>:4: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: could not
access file "$libdir/xxid": No such file or directory
<stdin>:4: Error: the extension for the xxid data type cannot be loaded in
database 'dbname=contactdb host=localhost user=postgres'
<stdin>:4: ERROR: no admin conninfo for node 134590736

I have also tried changing the value of libdir to the directory where
xxid.so file is there but couldn't resolve the problem.

Thanks,
Jyoti Seth

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org]
On Behalf Of Andrew Sullivan
Sent: Monday, July 23, 2007 11:43 PM
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Database Synchronization

On Mon, Jul 23, 2007 at 02:55:21PM +0530, Jyoti Seth wrote:
> In our system postgresql has been installed through YAST. So when we try
to
> install and configure slony-I through source, it gives the message please
> make sure tp build and install postgresql from the sources first.
>

You _might_ be able to get this to work by installing whatever extra
bits the YAST installation tool offers (probably something with -dev-
or -src- in it).

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of code underneath."
--Damien Katz

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings