From: Shoaib Mir <shoaibmir@gmail.com>
To: Mary Anderson <maryfran@demog.berkeley.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: replication between linxu postgresql and Windows postgresql
Date: Mon, 25 Jun 2007 13:43:06 -0400
Message-ID: <bf54be870706251043l6b0b169byf87d1ab96a900d43@mail.gmail.com> (raw)
In-Reply-To: <467FFCB9.70908@demog.berkeley.edu>
References: <467FFCB9.70908@demog.berkeley.edu>
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 (www.enterprisedb.com)
On 6/25/07, Mary Anderson <maryfran@demog.berkeley.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
>
> http://www.postgresql.org/about/donate
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: shoaibmir@gmail.com, maryfran@demog.berkeley.edu
Subject: Re: replication between linxu postgresql and Windows postgresql
In-Reply-To: <bf54be870706251043l6b0b169byf87d1ab96a900d43@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox