Re: backups

[Jonas S. <dr...@jo...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 24 Nov 2001, Ray Aldridge wrote:

> I seem to have just about everything running okay, but as a database
> ignoramus, I'd like to ask about other sql-ledger users how they go
> about backing up their accounting data.
>
> Do most folks use pg_dump?  Any special considerations I should be
> aware of?

I have attached the script I use on all my Debian machines. Don't know if
it works out-of-the-box for Redhat and others.

The reason for dumping to /var/local/backups/localhost is my structure of
rsync'ing between servers ( .../localhost is actually a symlink to the
domain name of the local machine - so I end up having folders for all
machines duplicated onto all machine).

 - Jonas

- --
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Made with pgp4pine 1.75-6

iD8DBQE8Ahw/n7DbMsAkQLgRAnpxAJsFNfdVIn3V/ona+sde1KYReCe/pQCgmtWc
nUrzIy9yGRDbiIIr4X0aNEE=
=u0s2
-----END PGP SIGNATURE-----