Re: replication

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(at)careerjunction(dot)co(dot)za <mailto:adrian(at)careerjunction(dot)co(dot)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(at)careerjunction(dot)co(dot)za
> <mailto:adrian(at)careerjunction(dot)co(dot)za>
> Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686
> 6842
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>