Re: upgrade issue - Mailing list pgsql-admin

From Tom Lane
Subject Re: upgrade issue
Date
Msg-id 7865.1029510041@sss.pgh.pa.us
Whole thread Raw
In response to upgrade issue  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "David F. Skoll"
Date:
Subject: Large TEXT fields
Next
From: Joe Conway
Date:
Subject: Re: Large TEXT fields