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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
