Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 95D069FA2EF
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 24 Jul 2007 04:49:10 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 40624-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 24 Jul 2007 04:49:07 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.232])
	by postgresql.org (Postfix) with ESMTP id 556409FA2C1
	for <pgsql-sql@postgresql.org>; Tue, 24 Jul 2007 04:49:07 -0300 (ADT)
Received: by qb-out-0506.google.com with SMTP id o12so9878120qba
	for <pgsql-sql@postgresql.org>; Tue, 24 Jul 2007 00:49:06 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:from:to:cc:references:in-reply-to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:content-language;
	b=W5Epm7ASxk9bNyHY4nH+i5mTPFk/m3CP5WQoarSz8IHGds7lWzrsyXVbF/fm1QYNISgIRjKnt3yrPqH2tGJwCq+tZHowuq0tq26UDzodnuWbgEBOtVMq2zr/2PRjeP2Vi8ONw9vZirNayaE1faqeGcwJgPGGVH4A4YCr3GvIy+I=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:from:to:cc:references:in-reply-to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:content-language;
	b=UkkbzWKdr5HIBHtbgEc6Ee9y5esfbN+jFxbBrL9i44fvHbCJSeeatq6XG8eOCGZ2mZb0wiT+XCL3KRshSgPUJGd8Ww4UMpWZoSxBjE5FOqEdZoL/G3ZDlAuS42R6p6Oev4Ks4ZhaJz2a1T6JdNhkleXWmWONq0DNtyP65JnEhpc=
Received: by 10.141.209.7 with SMTP id l7mr1211316rvq.1185263345682;
	Tue, 24 Jul 2007 00:49:05 -0700 (PDT)
Received: from bitdldt04 ( [122.162.171.152])
	by mx.google.com with ESMTPS id c20sm13250854rvf.2007.07.24.00.49.01
	(version=SSLv3 cipher=RC4-MD5); Tue, 24 Jul 2007 00:49:03 -0700 (PDT)
From: "Jyoti Seth" <jyotiseth2001@gmail.com>
To: "'Andrew Sullivan'" <ajs@crankycanuck.ca>
Cc: <pgsql-sql@postgresql.org>
References: <002d01c7c90b$48870560$d9951020$@com>
	<469DC124.8000704@archonet.com>
	<60fy3ln4ij.fsf@dba2.int.libertyrms.com>
	<004801c7cd0b$677a4870$366ed950$@com>
	<20070723181320.GA9196@phlogiston.dyndns.org>
In-Reply-To: <20070723181320.GA9196@phlogiston.dyndns.org>
Subject: Re: Database Synchronization
Date: Tue, 24 Jul 2007 13:15:56 +0530
Message-ID: <000601c7cdc6$ae37f530$0aa7df90$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcfNVagh7+Mdq0rXTUuygVe2fJzH8gAb9NTg
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/137
X-Sequence-Number: 28872

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@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Andrew Sullivan
Sent: Monday, July 23, 2007 11:43 PM
To: pgsql-sql@postgresql.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@crankycanuck.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