Look at slony.
On Mon, 2006-07-10 at 11:06, Forums @ Existanze wrote:
>
> We are looking for the exact thing but with two PostgreSQL databases
>
>
> ______________________________________________________________
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Kevin
> Bednar
> Sent: 10 July 2006 18:28
> To: pgsql-sql@postgresql.org
> Subject: [SQL] MS-SQL<->Postgres sync
>
>
> Looking to keep 2 databases in sync, at least semi-realtime if
> possible, although running a batch update every x mins
> wouldn't be out of the question. One db is postgres and the
> other is ms-sql. It's to keep inventory in sync from 2
> seperate locations, one being a brick and mortar store and the
> other an ecommerce system for a web site. Any and all help is
> appreciated since I can't find much of anything on syncing
> these 2 database systems!
>
> Kevin Bednar
> Systems Support
> Stockwell Design Group
> http://www.stockwelldesigngroup.com
> kevin@stockwelldesigngroup.com
>