Thanks Jonathan and Kaolin fire
Technicaly it is clear to me, how it works. But on a SUN E10000 we had
hours to exp/imp 20-30 GB of data. And I do not think, that we were able
to exp/imp 1TB.
If somebody is telling me now, I have to do this several times a year
(how can I sell this to a customer???)... It is not a problem handling a
micky-mouse database. dump/load 100 GB I would gess it takes me more
than 12 h, 2 or 4 times a year makes an availability of less than 99%.
If I have 1 TB...???
Regards Oli
PS: It is not a technical question/problem its a strategical/marketing
question/problem.
7.0.0 2000-05-08 A dump/restore using pg_dump is required
7.1.0 2001-04-13 A dump/restore using pg_dump is required 11 months
7.2.0 2002-02-04 A dump/restore using pg_dump is required 10 months
7.3.0 2002-11-27 A dump/restore using pg_dump is required 9 months
7.4.0 2003-11-xx A dump/restore using pg_dump is required 12 months
-------------------------------------------------------
Oli Sennhauser
Database-Engineer (Oracle & PostgreSQL)
Rebenweg 6
CH - 8610 Uster / Switzerland
Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14
e-Mail oli.sennhauser@bluewin.ch
Website http://mypage.bluewin.ch/shinguz/PostgreSQL/
Secure (signed/encrypted) e-Mail with a Free Personal SwissSign ID: http://www.swisssign.ch
Import the SwissSign Root Certificate: http://swisssign.net/cgi-bin/trust/import