Re: Upgrade OOPS

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Michael A Weber <mweber(at)4wre(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Upgrade OOPS
Date: 2004-06-11 07:11:46
Message-ID: 1086937906.2632.2.camel@teetnang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

В Птн, 11.06.2004, в 02:57, Michael A Weber пишет:
> I downloaded the RPMs for RHLinux9 and have run the upgrade, but now I
> receive an error about the database format needing to be upgraded when
> I attempt to start the service. Fortunately at this point, I have
> absolutely NO data that I need to save, so I haven’t lost anything.
> But, I need to upgrade the database format (or so it says) and I have
> no idea how to accomplish that. Have I done something that is not
> fixable at this point? HELP!

as root do

rm -rf /var/lib/pgsql/*

This deletes the old data directory. Upon the next start of the
postgresql service it will create a new one, in the new format.

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lynna Landstreet 2004-06-11 19:06:08 Re: Character encoding in database dumps
Previous Message mike g 2004-06-11 04:37:19 Re: Upgrade OOPS