From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com> |
Cc: | General postgres mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Sync 2 tables in 2 databases |
Date: | 2009-03-11 19:37:42 |
Message-ID: | dcc563d10903111237j273de97g373037cb9fbdf4d2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Mar 11, 2009 at 1:29 PM, SHARMILA JOTHIRAJAH
<sharmi_jo(at)yahoo(dot)com> wrote:
>
>
>> > Hi,
>> > I have 2 postgres databases with similar structure. I
>> want to keep some tables in sync in these 2 databases(They
>> can be synced just once a day). Is there a way to archive
>> this using function ?
>> > Something like....
>> >
>> > Select syncTable('foo')
>> >
>> > where syncTable is a function that compares table
>> 'foo' in db1 with table 'foo' in db2 and make
>> changes(update/insert/delete) to 'foo' in db1
>>
>> You can either truncate it on the destination db every so
>> often, then
>> dump / restore the data back into it, drop it and restore
>> it, write a
>> simple replication script that looks for missing /
>> updated rows, or
>> my suggestion, set up replication with slony and be done
>> with it. Of
>> course, you don't mention if you need one or two way
>> synchronization,
>> which makes a big difference in how you choose to do
>> things.
>>
>
> Also, Is there a way to archive this using dbi_link? In Oracle I do this using db_link..is it possible to get this done using postgres' dbi_link?
there's a package called dblink for linux. Not sure it could automate
things, but if you're using dbi_link in oracle, dblink in pgsql can
accomplish the same basic thing.
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2009-03-11 19:41:00 | Re: Server Shutting Down |
Previous Message | SHARMILA JOTHIRAJAH | 2009-03-11 19:29:58 | Re: Sync 2 tables in 2 databases |