Postgres Pro
Downloads
Home   >   mailing lists

Re: replication between linxu postgresql and Windows postgresql - Mailing list pgsql-admin

From Shoaib Mir
Subject Re: replication between linxu postgresql and Windows postgresql
Date
Msg-id bf54be870706251043l6b0b169byf87d1ab96a900d43@mail.gmail.com
Whole thread Raw
In response to replication between linxu postgresql and Windows postgresql  (Mary Anderson <maryfran@demog.berkeley.edu>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Mary Anderson
Date:
Subject: replication between linxu postgresql and Windows postgresql
Next
From: Chris Browne
Date:
Subject: Re: replication between linxu postgresql and Windows postgresql