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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2007-06-25 18:40:44 | Re: database creation date |
Previous Message | Mary Anderson | 2007-06-25 17:34:49 | replication between linxu postgresql and Windows postgresql |