| From: | Michelle Konzack <linux(dot)mailinglists(at)freenet(dot)de> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to backup a postgreSQL of 80 GByte ? |
| Date: | 2002-12-23 21:32:42 |
| Message-ID: | 3.0.6.32.20021223233242.00829c00@pop3.01019freenet.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Oops... and Hello,
Am 11:39 2002-12-23 +0100 hat SZUCS Gábor geschrieben:
>
>Call me suspicious, but 830 THOUSAND millions of tables in 80Gbyte is a
8-O ...a little BIG error... they are ONLY 830.000 tables ! :-P
>As for the hardware, I agree with Scott regarding tapes. The typical thing
>to backup/archive. As for its speed-- well, let's hope you won't have to
>restore from it ;)
Curently I am using the Software RAID-1 with two Harddrives...
Maybe I will switch to RAID-5 with 3 Drives.
>As for compression, bzip2 is really much better on text files. Also don't
>forget the "-9" flag (though I think this should be the default).
But HOW do you backup 80 GBytes ???
OK, I have three drives and the first drive is a normal 120 GByte HD,
on which I have the OS and a around 120 Gbyte TEMP Partition !!!
If I try to 'gzip' or 'bzip2' the 80 GBytes, how many days need it ???
It is a Productionssystem and will go online in Paris at amen.fr next
year. I think, 'bzip2' nos no solution...
Never I have tried it. - I think, it is amegalomania !
OK, I use the HP Surstore 12000e with 16 GByte Tapes...
Thanks
Michelle
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Fitzpatrick | 2002-12-23 22:43:32 | Multiple Foreign Keys to same table and field |
| Previous Message | Lamar Owen | 2002-12-23 19:12:16 | Re: [HACKERS] v7.3.1 Bundled and Released ... |