Re: Upgraded to Red Hat 7.1, now my DB is toast?

From: Nabil Sayegh <imap(at)sayegh(dot)de>
To: "J(dot) J(dot)" Franzen <jfranzen(at)cinenet(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Upgraded to Red Hat 7.1, now my DB is toast?
Date: 2001-06-06 13:12:23
Message-ID: 991833144.3700.0.camel@billy.labor.localnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Joe Moraca 2001-06-06 13:32:21 How do I start postmaster with -i for tcp-ip
Previous Message Armin Rauch 2001-06-06 12:53:31 Looking for a search tool