Take a look also on Londiste from SkyTools. It is easy to set up and manage. In addition SkyTools contains other useful scripts and tools.
We use Londiste to replicate data ovwe WAN where walshipping would consume too much bandwidth.
Asko
On Tue, Jun 24, 2008 at 9:41 AM, Adrian Moisey <adrian@xxxxxxxxxxxxxxxxxxxx> wrote:
Hi
We have a 100GB database (16GB dumped) running on 8.2.
Since the bandwidth in South Africa isn't that freely available it is difficult for us to get a new copy of out DB in our office (our fastest link in the office is 4Mbps).
What can you recommend for me to get an up to date copy of my DB in the office with as little transfer as possible.
A few ideas I've been toying with are rsyncing a dump of the db, or replication.
Any ideas?
--
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@xxxxxxxxxxxxxxxxxxxx
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
