Skip site navigation (1) Skip section navigation (2)

Re: replication between linxu postgresql and Windows postgresql

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "Mary Anderson" <maryfran(at)demog(dot)berkeley(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: replication between linxu postgresql and Windows postgresql
Date: 2007-06-25 17:43:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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.

Shoaib Mir
EnterpriseDB (

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 BrowneDate: 2007-06-25 18:40:44
Subject: Re: database creation date
Previous:From: Mary AndersonDate: 2007-06-25 17:34:49
Subject: replication between linxu postgresql and Windows postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group