Received: from unix.pantz.com (mail.pantz.com [205.158.93.53]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6ILcVa94147 for ; Wed, 18 Jul 2001 17:38:31 -0400 (EDT) (envelope-from ryan@paymentalliance.net) Received: from luz.paymentalliance.net (mail.downpore.com [205.158.93.51] (may be forged)) by unix.pantz.com (8.10.1/8.10.2) with ESMTP id f6ILV4908598; Wed, 18 Jul 2001 17:31:05 -0400 Message-Id: <5.0.2.1.0.20010718173255.033e0ae0@paymentalliance.net> X-Sender: ryan@paymentalliance.net X-Mailer: QUALCOMM Windows Eudora Version 5.0.2 Date: Wed, 18 Jul 2001 17:33:30 -0400 To: Fran Fabrizio , pgsql-general@postgresql.org From: Ryan Mahoney Subject: Re: replication? In-Reply-To: <3B55F205.441C92E4@mmrd.com> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=======778526B7======="; x-avg-checked=avg-ok-13C346B7 X-Archive-Number: 200107/676 X-Sequence-Number: 12724 --=======778526B7======= Content-Type: text/plain; charset=us-ascii; format=flowed; x-avg-checked=avg-ok-13C346B7 http://www.greatbridge.org/genpage?replication_top All you could ever want to know about pgsql replication. God Luck! -r At 04:31 PM 7/18/01 -0400, Fran Fabrizio wrote: >Does postgres support replication? I think this is the feature I need. >I have a table in one db that I need to use from another db on another >machine. The first db is behind two firewalls (for a good reason =) and >the second needs to be hung out on the internet, so I can't really use >the same db. But I would like to have the table on the internet Pg >install to be updated whenever the master table behind the firewalls is >updated. It doesn't need to be real-time, but maybe once every hour or >half hour. I certainly have no problem cheating and just copying a file >over or something if that will work. I looked through the docs but >didn't see anything about replication in the Administrator manual, where >I assume it'd be discussed. I did see a vague reference to a >replication toolkit in the release notes, is this what I'm looking for? > >Thanks, >Fran > > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > >http://www.postgresql.org/search.mpl > > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01 --=======778526B7======= Content-Type: text/plain; charset=us-ascii; x-avg-checked=avg-ok-13C346B7 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01 --=======778526B7=======--