Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5EC1047545C for ; Fri, 16 Aug 2002 10:34:32 -0400 (EDT) Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by postgresql.org (Postfix) with SMTP id BA650474E4E for ; Fri, 16 Aug 2002 10:34:31 -0400 (EDT) Received: from smtp.mail.virginia.edu by mail.virginia.edu id aa09430; 16 Aug 2002 10:34 EDT Received: from jlk3xpc (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.9.3/8.9.3) with SMTP id KAA12788 for ; Fri, 16 Aug 2002 10:34:34 -0400 Message-ID: <00fd01c24532$27600240$de138f80@virginia.edu> From: Jodi Kanter To: Postgres Admin List Subject: upgrade issue Date: Fri, 16 Aug 2002 10:35:22 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/193 X-Sequence-Number: 5308 Our system admin recently upgraded our Linux system from 7.1 to 7.3. Apparently this upgrade also changed our postgres version from 7.1.3 to 7.2.1-5. We are now getting the following error: > An old version of the database format was found. > You need to upgrade the data format before using PostgreSQL. > See (Your System's documentation directory)/postgresql-7.2/README.rpm-dist > for more information. I have now read (all be it to late) the documentation warning of this problem. Luckily we do not have any data that I need to save in the database. I could easily get back to a functioning state if I could drop the database and rebuild it via my schema.sql file. However, I cannot drop the database unless I can get the postmaster started. Can anyone advise? Also, the upgrade doc that I am reading makes mention of a postgres-dump command but there is no documentation on the system referencing this command. Can someone please tell me more about it? Is it a new command? Thanks so much for your assistance. Jodi