Slony can handle this all.
If you do not want to use Slony, you can write your own triggers using
dblink module to get the data across.
On 6/25/07, Mary Anderson <maryfran(at)demog(dot)berkeley(dot)edu> wrote:
> Hi all,
> I am new to postgresql and have been called upon to set up a
> database to be used by two groups. One group (mine) is strictly a UNIX
> shop. The other group (theirs) is strictly a Windows shop. What is the
> best way to go.
> First, does postgresql have replication and can i get it with the
> open source database?
> Second, would replication work between a Linux postgresql and a
> Windows postgresql?
> What if I run postgresql on VMWare in the Windows shop? Will
> replication work?
> What about dumping the Linux database and restoring it on the
> Windows database. Will that work?
> Opinions on any of this are welcome!
> Mary Anderson
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
In response to
pgsql-admin by date
|Next:||From: Chris Browne||Date: 2007-06-25 18:40:44|
|Subject: Re: database creation date|
|Previous:||From: Mary Anderson||Date: 2007-06-25 17:34:49|
|Subject: replication between linxu postgresql and Windows postgresql|