Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C94C79FB1CD for ; Mon, 25 Jun 2007 14:43:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 74113-02 for ; Mon, 25 Jun 2007 14:43:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.239]) by postgresql.org (Postfix) with ESMTP id 0CA1A9FB958 for ; Mon, 25 Jun 2007 14:43:06 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 68so967095wri for ; Mon, 25 Jun 2007 10:43:06 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=aO6uwHlxQNjh0Myv03ZOdOib1BZliLHbdJ9rLjfg0HCgJKbbivYWPO5JVc2HGAVNEouPjbPjlKtqsFl0dQVMBhdLuw4DdD4cD+m6/rp+DNUzIuktigFzmpYxYuy+M36+gcs7WVHeIXgD23ugqyyd6YWJDSDkYa4kygVVQ6ivrPM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=m/eT17FdGLVQXrwd8QRAE2doYfq0OggE/BenoIlGqIo87We/K6nzIxC9LAnT/8GnY8ys2zoMTtzDuzC5GE6jEd1ZtccfTlALNv+WvfrTi0JluyiFzX0g+ooVjH+mQgEsOAhGly/XVuQgOSPJBs4RBBios23DUIoQmJVjwsvBmHI= Received: by 10.100.197.15 with SMTP id u15mr3265592anf.1182793386342; Mon, 25 Jun 2007 10:43:06 -0700 (PDT) Received: by 10.100.173.9 with HTTP; Mon, 25 Jun 2007 10:43:06 -0700 (PDT) Message-ID: Date: Mon, 25 Jun 2007 13:43:06 -0400 From: "Shoaib Mir" To: "Mary Anderson" Subject: Re: replication between linxu postgresql and Windows postgresql Cc: pgsql-admin@postgresql.org In-Reply-To: <467FFCB9.70908@demog.berkeley.edu> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6775_1427137.1182793386314" References: <467FFCB9.70908@demog.berkeley.edu> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/265 X-Sequence-Number: 25933 ------=_Part_6775_1427137.1182793386314 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 > ------=_Part_6775_1427137.1182793386314 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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

------=_Part_6775_1427137.1182793386314--