From: Justin Clift <justin@postgresql.org>
To: Fran Fabrizio <ffabrizio@mmrd.com>
Cc: pgsql-general@postgresql.org
Subject: Re: replication?
Date: Thu, 19 Jul 2001 09:12:50 +1000
Message-ID: <3B5617F2.F5140582@postgresql.org> (raw)
References: <3B55F205.441C92E4@mmrd.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: justin@postgresql.org, ffabrizio@mmrd.com
Subject: Re: replication?
In-Reply-To: <3B5617F2.F5140582@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox