Re: How to backup a postgreSQL of 80 GByte ?

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