* Jyoti Seth <[EMAIL PROTECTED]> wrote:
Hi,
if you can live with some seconds lag, you can use an separate
transfer process which looks at the source of your prices and
and updates the second DB if some price changes.
Depending on how often prices change, there're two good options:
a) add an
On Tue, Jul 31, 2007 at 09:22:04AM +0100, Richard Huxton wrote:
> I don't think slony lets you rename tables/schemas during transfer. I'm
> not sure many people want it, and it would be a complicated thing to do
> properly in the general case (you'll need to consider dependant objects
> - FKeys,
Jyoti Seth wrote:
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 tab
e:
>
> Thanks a lot for your suggestion. It will help me in taking the decision.
>
> -Original Message-
> From: Richard Huxton [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 25, 2007 6:10 PM
> To: Jyoti Seth
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL]
Thanks a lot for your suggestion. It will help me in taking the decision.
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 25, 2007 6:10 PM
To: Jyoti Seth
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Database synchronization
Jyoti Seth wrote
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 th
nks,
Jyoti
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 25, 2007 3:54 PM
To: Jyoti Seth
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Database synchronization
Try not to start a new thread (question) by replying to an old one - it
can mean some people
Try not to start a new thread (question) by replying to an old one - it
can mean some people don't see your question.
Jyoti Seth wrote:
Hi,
I have two postgres databases "Db1" and "Db2" on different linux servers.
"DB1" is my master server and its data updates very frequently.
My application
Hi,
I have two postgres databases "Db1" and "Db2" on different linux servers.
"DB1" is my master server and its data updates very frequently.
My application access DB2 database, which in turn requires data from Db1
database.
The same can be achieved in either of the following ways:
1. I can hav
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
> ma
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_ b
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Chris Browne
Sent: Wednesday, July 18, 2007 8:28 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Database Synchronization
[EMAIL PROTECTED] (Richard Huxton) writes:
> Jyoti Seth wrote:
>> Hello ,
>> I have two postgres da
Thanks a lot for your suggestions. I have ony single master.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Richard Huxton
Sent: Wednesday, July 18, 2007 9:13 PM
To: Chris Browne
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Database Synchronization
Chris Browne wrote:
[EMAIL PROTECTED] (Richard Huxton) writes:
http://www.slony.info/
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 mast
[EMAIL PROTECTED] (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.
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 t
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.
Please let me know if someone has idea.
Thanks,
Jyoti Seth
17 matches
Mail list logo
