replication

From: Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: replication
Date: 2008-06-24 06:41:18
Message-ID: 4860970E.9070305@careerjunction.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henry - Zen Search SA 2008-06-24 06:53:28 Re: replication
Previous Message Craig Ringer 2008-06-24 05:36:17 Re: Method to detect certain characters in column?