Re: How to backup a postgreSQL of 80 GByte ?

From: greg(at)turnstep(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to backup a postgreSQL of 80 GByte ?
Date: 2002-12-21 13:17:38
Message-ID: 29d2f7f11b6a5c9b42253afe03dbffaf@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


-----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(at)turnstep(dot)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-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Ploski 2002-12-21 14:32:30 Unicode database + JDBC driver performance
Previous Message tom 2002-12-21 07:58:01 Re: table schema causes crash