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=XsAqRfGIjcyjhScxSs2EUu0WpmArjkFEeTPyMFkTbYMkUlfLBnORDa2EUA52ynyhEwjjaS6hZK7glQn29I9tjzcT2USwTcsPLSxr6IISLDCuEpPrpiTmROSdaGJFdvOUuWxAgeADzEJQ0UCdwyN7PgzG3TLuvbiyy9BY7W7iGXc=
From: "Jyoti Seth" <jyotiseth2001@gmail.com>
To: "'Chris Browne'" <cbbrowne@acm.org>
Cc: <pgsql-sql@postgresql.org>
References: <002d01c7c90b$48870560$d9951020$@com>
	<469DC124.8000704@archonet.com>
	<60fy3ln4ij.fsf@dba2.int.libertyrms.com>
In-Reply-To: <60fy3ln4ij.fsf@dba2.int.libertyrms.com>
Subject: Re: Database Synchronization
Date: Mon, 23 Jul 2007 14:55:21 +0530
Message-ID: <004801c7cd0b$677a4870$366ed950$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcfJTY0Vn9kN8hmkSt+XXNc//vg4MgDq+hEw
Content-Language: en-us

Hello,

When I am installing slony-I from rpm's available at the following
url:http://main.slony.info/downloads/1.2/rpm/ it is giving an error: There
are no installable providers of postgresql-slony1-engine.

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.

I am new to both linux and postgres. Please help me in installing and
configuring slony-I on my suse linux m/c.

Thanks,
Jyoti Seth 

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Chris Browne
Sent: Wednesday, July 18, 2007 8:28 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Database Synchronization

dev@archonet.com (Richard Huxton) writes:
> Jyoti Seth wrote:
>> Hello ,
>>  I have two postgres databases on different linux servers. Postgres
>> database
>> on one server has some tables that needs to be synchronized from the
other
>> postgres database . What should be the best method for this.
>
> The slony replication package lets you choose what tables you
> replicate. On the destination server the tables will be read-only.
>
> http://www.slony.info/
>
> Take a little time to read through the documentation and experiment
> with a test system first. It works fine, but it's got a lot of
> complicated options.

But it is worth noting one thing about the synchronization...

Slony-I's strategy is pretty simple: One node is considered the
"master," and the other node is forcibly made to conform to what is on
the master.

If you want to synchronize back and forth (e.g. - multimaster
replication of some sort), Slony-I is not suitable...
-- 
"cbbrowne","@","linuxdatabases.info"
http://www3.sympatico.ca/cbbrowne/unix.html
Culus thinks  we should go to trade  shows and see how  many people we
can kill by throwing debian cds at them

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate