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: bf54be870706251043l6b0b169byf87d1ab96a900d43@mail.gmail.com (view raw or flat)
Thread:
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 (www.enterprisedb.com)

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
>
>                 http://www.postgresql.org/about/donate
>

In response to

Responses

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-2014 The PostgreSQL Global Development Group