Thread: Upgrade OOPS

If you are upgrading from a prior version of postgresql you normally
need to backup the database via pg_dump, upgrade, create a new database
and import the data.

See http://www.postgresql.org/docs/7.4/static/install-upgrading.html

Mike
On Thu, 2004-06-10 at 19:57, Michael A Weber wrote:
> 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!
>
>
>
> Michael A Weber
>
> Weber Racing Equipment, Inc.
>
> 440-327-7702
>
> 440-327-6899 fax
>
> mweber@4wre.com
>
>
>
>

В Птн, 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>