Re: How to backup a postgreSQL of 80 GByte ? - Mailing list pgsql-general

From Michelle Konzack
Subject Re: How to backup a postgreSQL of 80 GByte ?
Date
Msg-id 3.0.6.32.20021223233242.00829c00@pop3.01019freenet.de
Whole thread Raw
In response to Re: How to backup a postgreSQL of 80 GByte ?  (SZUCS Gábor <surrano@mailbox.hu>)
Responses Re: How to backup a postgreSQL of 80 GByte ?
List 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



pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: no space left on device
Next
From: "scott.marlowe"
Date:
Subject: Re: missing 7.3.1 pg_hba.conf examples