Message-ID: <3B5617F2.F5140582@postgresql.org>
Date: Thu, 19 Jul 2001 09:12:50 +1000
From: Justin Clift <justin@postgresql.org>
MIME-Version: 1.0
To: Fran Fabrizio <ffabrizio@mmrd.com>
CC: pgsql-general@postgresql.org
Subject: Re: replication?
References: <3B55F205.441C92E4@mmrd.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Fran,

You might want to check out the PostgreSQL replication solutions linked
to from :

http://techdocs.postgresql.org/oresources.php#replication

PostgreSQL Replicator seems to be the most complete, but I'm not sure
(haven't yet gotten around to testing them properly).

:-)

Regards and best wishes,

Justin Clift

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