Re: replication?

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