Re: data format problem for upgrede from 7.1->7.3

From: Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch>
To: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: data format problem for upgrede from 7.1->7.3
Date: 2003-11-05 23:27:03
Message-ID: 3FA98747.8070805@bluewin.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)sennhauser(at)bluewin(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc G. Fournier 2003-11-06 01:06:14 Re: Postgres Web Page
Previous Message David F. Skoll 2003-11-05 22:05:07 Re: Microsoft access verses postgresql