Re: upgrade issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jodi Kanter <jkanter(at)virginia(dot)edu>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: upgrade issue
Date: 2002-08-16 15:00:41
Message-ID: 7865.1029510041@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jodi Kanter <jkanter(at)virginia(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Joe Conway 2002-08-16 17:06:41 Re: Large TEXT fields
Previous Message David F. Skoll 2002-08-16 14:44:35 Large TEXT fields