Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1068F9FB4E1 for ; Mon, 25 Jun 2007 14:34:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 19464-06 for ; Mon, 25 Jun 2007 14:34:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from transition.DEMOG.Berkeley.EDU (DEMOG.Berkeley.EDU [128.32.93.50]) by postgresql.org (Postfix) with ESMTP id B50DB9FB34D for ; Mon, 25 Jun 2007 14:34:48 -0300 (ADT) Received: from transition.DEMOG.Berkeley.EDU (localhost.localdomain [127.0.0.1]) by transition.DEMOG.Berkeley.EDU (Postfix) with ESMTP id 503D213902 for ; Mon, 25 Jun 2007 10:34:47 -0700 (PDT) Received: from [192.168.1.26] (generation.DEMOG.Berkeley.EDU [192.168.1.26]) (using SSLv3 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by transition.DEMOG.Berkeley.EDU (Postfix) with ESMTP id 10F1D138E5 for ; Mon, 25 Jun 2007 10:34:46 -0700 (PDT) Message-ID: <467FFCB9.70908@demog.berkeley.edu> Date: Mon, 25 Jun 2007 10:34:49 -0700 From: Mary Anderson User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: replication between linxu postgresql and Windows postgresql Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.481 tagged_above=0 required=5 tests=AWL=-0.240, BAYES_50=0.001, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200706/264 X-Sequence-Number: 25932 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