Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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

pgsql-novice by date

Next:From: Lynna LandstreetDate: 2004-06-11 19:06:08
Subject: Re: Character encoding in database dumps
Previous:From: mike gDate: 2004-06-11 04:37:19
Subject: Re: Upgrade OOPS

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group