Re: How to backup a postgreSQL of 80 GByte ?

Поиск
Список
Период
Сортировка
От Michelle Konzack
Тема Re: How to backup a postgreSQL of 80 GByte ?
Дата
Msg-id 3.0.6.32.20021223233242.00829c00@pop3.01019freenet.de
обсуждение исходный текст
Ответ на Re: How to backup a postgreSQL of 80 GByte ?  (SZUCS Gábor <surrano@mailbox.hu>)
Ответы Re: How to backup a postgreSQL of 80 GByte ?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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 по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: no space left on device
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: missing 7.3.1 pg_hba.conf examples