| From: | Michelle Konzack <linux(dot)mailinglists(at)freenet(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | How to backup a postgreSQL of 80 GByte ? |
| Date: | 2002-12-19 23:55:34 |
| Message-ID: | 3E01647500113FB2@mel-rta9.wanadoo.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I am running a postgreSQL under Debian/GNU-Linux 3.0r0 and a Ultra-
ATA-133 RAID-1 with three 120 GByte IBM-Drives.
Now I have the Problem to backup the stuff.
I was thinking, to export all tables seperately to text files, gzip
and backup it. There will be around 830.000 millons tables !
How can I do effectiv backup so that I can get informationd from it,
if all other fails...
The Textfiles are perfectly in general, because you can get infos
with an editor or browsing with mc ;-))
Any suggestins are welcome...
Oh yes, I like to backup to my CD-R55S and I like to know, whats the
ratio from a compressed (gzip'ed) database ?
Thanks in advance
Michelle
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Harding | 2002-12-20 00:16:43 | Re: trouble caused by change in 7.3 handling of '' |
| Previous Message | Tom Lane | 2002-12-19 23:00:28 | Re: Changing column question.. |