DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=LkDupgU+kLVKaM0e7brLar5y6BQqA5DwBVlbn569TY7D+0TmcnGR2edYb0pmW+w2chuev99dZ/gC6AyiTfUZwonTGOFzPMQuziFnre2GOOpwun7sQP8m2N/f+Up3i70v2XBORBqk98D9JWsrQuwH88lEaZl5ymWldepO39nz3fQ=
Message-ID: <6c3fb5eb0707310102s73bf7516w8dd157c550e2cf7d@mail.gmail.com>
Date: Tue, 31 Jul 2007 13:32:52 +0530
From: "Jyoti Seth" <jyotiseth2001@gmail.com>
To: "Richard Huxton" <dev@archonet.com>
Subject: Re: Database synchronization
Cc: pgsql-sql@postgresql.org
In-Reply-To: <001e01c7cf40$85e7b540$91b71fc0$@com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_42518_15748223.1185868972271"
References: <20070724143737.GA25948@apartia.fr>
	<004e01c7cea4$58046570$080d3050$@com> <46A724CB.3030405@archonet.com>
	<000001c7cea8$39775d20$ac661760$@com> <46A7449A.4080500@archonet.com>
	<001e01c7cf40$85e7b540$91b71fc0$@com>

------=_Part_42518_15748223.1185868972271
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello,

I have one query related to slony-I. Can I replicate table data in different
schemas. Say if have table 'country' in database 'stock' and schema
'stocksch'. And I want to replicate the data in table 'country' of database
'smsdb' and schema 'smssch'. Here, the country table is present in two
different schemas. Can I replicate the country table data from schema
stocksch to schema smssch or I have to create a schema with the same name
for replication.

Thanks,
Jyoti Seth


On 7/26/07, Jyoti Seth <jyotiseth2001@gmail.com> wrote:
>
> Thanks a lot for your suggestion. It will help me in taking the decision.
>
> -----Original Message-----
> From: Richard Huxton [mailto:dev@archonet.com]
> Sent: Wednesday, July 25, 2007 6:10 PM
> To: Jyoti Seth
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Database synchronization
>
> Jyoti Seth wrote:
> > My master database contains prices of some products that vary after few
> > hours and many other details that are also reqd in Db2 which doesn't
> change
> > that frequently. My slave database contains the details of queries sent
> by
> > the customers.
> > These queries are to find the price of the product and other details.
> (Some
> > part of the info reqd from Db1 varies frequently where some information
> is
> a
> > kind of master data that doesn't vary frequently).
> >
> > So should I use all the ways i.e #2 or #3 to get price info and #1
> (slony)
> > for other details or there is some other better option
>
> If you can live with a time-lag measured in seconds, then slony will
> work just fine. If you can't then you'll want dblink.
>
> One other thing you might consider - if you attach "valid_from" time to
> each price then you can put them in place in advance, and make sure they
> are replicated before needed.
>
> --
>   Richard Huxton
>   Archonet Ltd
>
>

------=_Part_42518_15748223.1185868972271
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hello,</div>
<div>&nbsp;</div>
<div>I have one query related to slony-I. Can I replicate table data in different schemas. Say if have table &#39;country&#39; in database &#39;stock&#39; and schema &#39;stocksch&#39;. And&nbsp;I want to replicate the data in table &#39;country&#39; of database &#39;smsdb&#39; and schema &#39;smssch&#39;. Here, the country table is present in two different schemas. Can I replicate the country table data from schema stocksch to schema smssch or I have to create a schema with the same name for replication.
</div>
<div>&nbsp;</div>
<div>Thanks,</div>
<div>Jyoti Seth<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 7/26/07, <b class="gmail_sendername">Jyoti Seth</b> &lt;<a href="mailto:jyotiseth2001@gmail.com">jyotiseth2001@gmail.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Thanks a lot for your suggestion. It will help me in taking the decision.<br><br>-----Original Message-----
<br>From: Richard Huxton [mailto:<a href="mailto:dev@archonet.com">dev@archonet.com</a>]<br>Sent: Wednesday, July 25, 2007 6:10 PM<br>To: Jyoti Seth<br>Cc: <a href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org
</a><br>Subject: Re: [SQL] Database synchronization<br><br>Jyoti Seth wrote:<br>&gt; My master database contains prices of some products that vary after few<br>&gt; hours and many other details that are also reqd in Db2 which doesn&#39;t
<br>change<br>&gt; that frequently. My slave database contains the details of queries sent by<br>&gt; the customers.<br>&gt; These queries are to find the price of the product and other details.<br>(Some<br>&gt; part of the info reqd from Db1 varies frequently where some information is
<br>a<br>&gt; kind of master data that doesn&#39;t vary frequently).<br>&gt;<br>&gt; So should I use all the ways i.e #2 or #3 to get price info and #1 (slony)<br>&gt; for other details or there is some other better option
<br><br>If you can live with a time-lag measured in seconds, then slony will<br>work just fine. If you can&#39;t then you&#39;ll want dblink.<br><br>One other thing you might consider - if you attach &quot;valid_from&quot; time to
<br>each price then you can put them in place in advance, and make sure they<br>are replicated before needed.<br><br>--<br>&nbsp;&nbsp;Richard Huxton<br>&nbsp;&nbsp;Archonet Ltd<br><br></blockquote></div><br>

------=_Part_42518_15748223.1185868972271--