From: Adam Manock <abmanock@planetcable.net>
To: Fran Fabrizio <ffabrizio@mmrd.com>
To: pgsql-general@postgresql.org
Subject: Re: replication?
Date: Wed, 18 Jul 2001 18:28:08 -0400
Message-ID: <5.1.0.14.2.20010718181510.0282f740@pop.planetcable.net> (raw)
In-Reply-To: <3B55F205.441C92E4@mmrd.com>
Hi,
from: http://www.postgresql.org/idocs/index.php?backup.html :
"pg_dump -h host1 dbname | psql -h host2 dbname"
You could run this out of cron on your internal DB server (host1)
And use a firewall rule like:
# Allow internal DB server to use TCP for DB dumps
pass in quick proto tcp from ip_of_host1 to ip_of_host2 port = 5432 flags
S/FSRPAU keep state
The rule above is for IP Filter http://coombs.anu.edu.au/~avalon/
Adam
At 04:31 PM 7/18/01 -0400, 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
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: abmanock@planetcable.net, ffabrizio@mmrd.com
Subject: Re: replication?
In-Reply-To: <5.1.0.14.2.20010718181510.0282f740@pop.planetcable.net>
* 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