Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgraded to Red Hat 7.1, now my DB is toast? - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Upgraded to Red Hat 7.1, now my DB is toast?
Date
Msg-id 991833144.3700.0.camel@billy.labor.localnet
Whole thread Raw
In response to Upgraded to Red Hat 7.1, now my DB is toast?  ("J. J. Franzen" <jfranzen@cinenet.net>)
List pgsql-novice
Tree view 
On 02 Jun 2001 00:51:56 -0700, J. J. Franzen wrote:
> dir...  Does this mean that DBs made with 6.whatever are incompatible
> with 7.whatever?  And if so, is there a way to recover/upgrade/save the
> db I already have?  Thanks in advance for any advice.  Later,

Exactly. Upgrading to 7.1 requires an initdb.
I'd recommend:

pg_dump -D dbname >dbname.sql (or use pg_dumpall)

and after installing 7.1 (and initdb)

psql -f dbname.sql

--
 Nabil Sayegh

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL problem with functions
Next
From: "Shawhan, Douglas (GEAE, GECC)"
Date:
Subject: selecting a column average into table