replication - Mailing list pgsql-general

From Adrian Moisey
Subject replication
Date
Msg-id 4860970E.9070305@careerjunction.co.za
Whole thread Raw
Responses Re: replication  ("Henry - Zen Search SA" <henry@zen.co.za>)
Re: replication  ("Asko Oja" <ascoja@gmail.com>)
List pgsql-general
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@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Method to detect certain characters in column?
Next
From: "Albe Laurenz"
Date:
Subject: Re: Unicode problem again