Обсуждение: upgrade issue

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

Jodi Kanter <jkanter@virginia.edu> writes:
> 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.

If you don't need any of the data then you can just rm -rf $PGDATA and
initdb.  (You might at least want to save the text configuration files
that appear in the top level $PGDATA directory, however, as consulting
them will make it easier to configure your new installation.)

            regards, tom lane

On Fri, 16 Aug 2002, Jodi Kanter wrote:

JK> Our system admin recently upgraded our Linux system from 7.1 to 7.3.
JK> Apparently this upgrade also changed our postgres version from 7.1.3 to
JK> 7.2.1-5.

[snip]

JK> problem. Luckily we do not have any data that I need to save in the
JK> database. I could easily get back to a functioning state if I could drop the
JK> database and rebuild it via my schema.sql file. However, I cannot drop the
JK> database unless I can get the postmaster started.
JK> Can anyone advise?

Well if you do not neet older database then just 'rm -rf $PGDATA' and then
do initdb. You'll got virgin empty database cluster.

Sincerely,
D.Marck                                   [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
------------------------------------------------------------------------