Re: Upgrade OOPS - Mailing list pgsql-novice

From Markus Bertheau
Subject Re: Upgrade OOPS
Date
Msg-id 1086937906.2632.2.camel@teetnang
Whole thread Raw
In response to Upgrade OOPS  ("Michael A Weber" <mweber@4wre.com>)
List 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@bluetwanger.de>


pgsql-novice by date:

Previous
From: mike g
Date:
Subject: Re: Upgrade OOPS
Next
From: Lynna Landstreet
Date:
Subject: Re: Character encoding in database dumps