From: Allan Kamau <allank@sanbi.ac.za>
To: Adrian Moisey <adrian@careerjunction.co.za>
Cc: pgsql-general@postgresql.org
Subject: Re: replication
Date: Wed, 25 Jun 2008 13:52:00 +0200
Message-ID: <48623160.4060302@sanbi.ac.za> (raw)
In-Reply-To: <ecd779860806242320i35e3f333ue148c62b691da608@mail.gmail.com>
References: <4860970E.9070305@careerjunction.co.za>
<ecd779860806242320i35e3f333ue148c62b691da608@mail.gmail.com>
Initially you may want to get the full dump (this applies also to the
replication option) across to your other site. You may want to bzip2 the
dump file, you may be surprised by the reduction of file size using
bzip2. Try "tar -cjf mydump.sql.tar.bz2 mydump.sql" then transfer it
using scp or place it on an ftp server in your local office, then login
remotely (ssh) to a pc/server on your destination office then issue
"wget -c -t0 http://myftpsite/path/to/mydump.sql";.
Allan.
Asko Oja wrote:
> Hi
>
> 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@careerjunction.co.za <mailto:adrian@careerjunction.co.za>> 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 <http://www.careerjunction.co.za; |
> Email: adrian@careerjunction.co.za
> <mailto:adrian@careerjunction.co.za>
> Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686
> 6842
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org
> <mailto:pgsql-general@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
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: allank@sanbi.ac.za, adrian@careerjunction.co.za
Subject: Re: replication
In-Reply-To: <48623160.4060302@sanbi.ac.za>
* 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