[ADMIN] data format problem for upgrede from 7.1->7.3

2003-11-04 Thread Gautam Saha
Hi: I just upgraded from 7.1->7.3, but did not take a data back up. Now when i try to start the posrGreSQL server I get the message: An old version of the database format was found.\nYou need to upgrade the data format before using PostgreSQL.\nSee (Your System's documentation directory)/postgre

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

2003-11-04 Thread Tom Lane
Gautam Saha <[EMAIL PROTECTED]> writes: > Any idea what might be the resolution here? Put back your 7.1 executables and make a pg_dumpall run before you upgrade. Then upgrade, initdb, reload the dump. regards, tom lane ---(end of broadcast)---

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

2003-11-05 Thread Oli Sennhauser
Hello admins Tome Lane once wrote, if I remember well, that the biggest PostgreSQL DB he knows is about 4 TB!!! In Oracle we normaly say, it is "not possible" (= usefull) to exp/imp more than let's say 20 to 50 GB of data. This is more ore less the same we do with pg_dumpall??? Oracle was not c

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

2003-11-05 Thread Oli Sennhauser
Thanks Jonathan and Kaolin fire Technicaly it is clear to me, how it works. But on a SUN E1 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 custom

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

2003-11-05 Thread Bruno Wolff III
On Thu, Nov 06, 2003 at 00:27:03 +0100, Oli Sennhauser <[EMAIL PROTECTED]> wrote: > > 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

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

2003-11-06 Thread Andrew Sullivan
On Thu, Nov 06, 2003 at 12:27:03AM +0100, Oli Sennhauser wrote: > > 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