Re: Amanda and PostgreSQL
2005-01-13 09:52:49
On Thu, 13 Jan 2005 tobias.bluhm AT philips DOT com wrote:
> Using rsync:
>
> shutdown db
> rsync all data to backup disk/raid/machine
> start db
> amanda backup the backup disk/raid/machine
>
> The first run of rsync will be the slowest - must send all data to make a
> complete copy. The next run of rsync will be much faster. rsync only sends
> new or changed data. So if 3 bytes in a 1G file are changed, only the
^^^^^^^^
> changed 3 bytes are sent. Plus you have the lastest backup copy in an
^^^^^^^^^^^^^^^^^^^^^^^^
Hmm, not exactly true ;-) Rsync operates on blocks.
> easily retrieved format. Your rsync speed will depend on the size of the
> db & the amount of daily changes.
And make sure to use `rsync -za --delete'. You can drop the `-z' if you don't
want to use compression (for slow CPUs and very fast networks).
Gr{oetje,eeting}s,
Geert
--
Geert Uytterhoeven -- There's lots of Linux beyond ia32 -- geert AT linux-m68k
DOT org
In personal conversations with technical people, I call myself a hacker. But
when I'm talking to journalists I just say "programmer" or something like that.
-- Linus Torvalds
|
|
|