From: Jyoti Seth <jyotiseth2001@gmail.com>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Database synchronization
Date: Tue, 31 Jul 2007 13:32:52 +0530
Message-ID: <6c3fb5eb0707310102s73bf7516w8dd157c550e2cf7d@mail.gmail.com> (raw)
In-Reply-To: <001e01c7cf40$85e7b540$91b71fc0$@com>
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>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jyotiseth2001@gmail.com, dev@archonet.com
Subject: Re: Database synchronization
In-Reply-To: <6c3fb5eb0707310102s73bf7516w8dd157c550e2cf7d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox