Re: How to backup a postgreSQL of 80 GByte ?

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


> I was thinking, to export all tables seperately to text files, gzip
> and backup it. There will be around 830.000 millons tables !

Ignoring the more important hardware issue, you should consider
using bzip2 instead of gzip, which can save you a lot of disk space
at the cost of a slightly higher time to compress. The built in
checksums and the bzip2recover program are nice things to have as
well.

I am not sure how many tables you actually have, but saving them
all to separate files may not be the most officient way: consider
having pg_dump do more than one table, or consider tarring many
tables into one file. Midnight Commander can also read tar files.

Greg Sabino Mullane  greg@turnstep.com
PGP Key: 0x14964AC8 200212210817

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+BGxkvJuQZxSWSsgRAqNmAJ0TPN16Dr7hKURRQf1b7eX6Iz7UywCgl+2c
sEZ5Uuap3aesizogZ/0T/CE=
=8Nn6
-----END PGP SIGNATURE-----