I'd recommend changing the structure of your tables, adding a record_added
field, and then do a
SELECT * FROM table WHERE record_added > CURRENT_TIMESTAMP - '15min' ::datetime
and having a PERL program pipe the results of the select into the other
database using DBI with two connections.
BTW: The SELECT statement above probably doesn't work, as I can never
remember the time functions/macros. It should give you the general idea
though.
At 04:19 AM 3/24/00, Differentiated Software Solutions Pvt. Ltd. wrote:
>Hi,
>
>We have an application which has databases in 2 different machines.
>The databases are small (25 MB).
>
>Every 15 minutes we want DB of one machine to be synced with another
>machine. Are there ready made utilities in postgres to do this.
>One way is to take a pgdump, tar it, ftp it and then restore it into the
>other machine.
>This has a problem if I want to sync selected tables. Also this means the
>entire data gets reloaded, whereas only the incremental changes should get
>dumped.
>
>Any help is appreciated.
>
>Murali
>
>Differentiated Software Solutions Pvt. Ltd.,
>176, Gr. Floor, 6th Main
>2nd Block RT Nagar
>Bangalore - 560 032
>India
>Ph: 91 80 3431470
>email : diffs+AEA-vsnl.com
>http://www.diffs-india.com
