pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jodi Kanter <jkanter@virginia.edu>
To: Postgres Admin List <pgsql-admin@postgresql.org>
Subject: upgrade issue
Date: Fri, 16 Aug 2002 10:35:22 -0400
Message-ID: <00fd01c24532$27600240$de138f80@virginia.edu> (raw)

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




view thread (12+ messages)  latest in thread

Message-ID: <00fd01c24532$27600240$de138f80@virginia.edu>
Permalink:  ../00fd01c24532$27600240$de138f80@virginia.edu/
Also on:    postgresql.org/message-id/00fd01c24532$27600240$de138f80@virginia.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jkanter@virginia.edu
  Subject: Re: upgrade issue
  In-Reply-To: <00fd01c24532$27600240$de138f80@virginia.edu>
  References: <00fd01c24532$27600240$de138f80@virginia.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox