Received: from gate.mmrd.com ([216.206.87.254]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6IKTma66513 for ; Wed, 18 Jul 2001 16:29:48 -0400 (EDT) (envelope-from ffabrizio@mmrd.com) Received: from [192.168.0.100] by gate.mmrd.com for pgsql-general@postgresql.org id QAA23145; Wed Jul 18 16:29:45 2001 Received: from mmrd.com (IDENT:fran@localhost.localdomain [127.0.0.1]) by f-fabrizio.mmrd.com (8.11.0/8.11.0) with ESMTP id f6IKV2I09852 for ; Wed, 18 Jul 2001 16:31:02 -0400 Message-ID: <3B55F205.441C92E4@mmrd.com> Date: Wed, 18 Jul 2001 16:31:01 -0400 X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.16-22 i686) X-Accept-Language: en MIME-Version: 1.0 Subject: replication? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit To: pgsql-general@postgresql.org From: Fran Fabrizio X-Archive-Number: 200107/672 X-Sequence-Number: 12718 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