Re: Cannot restart the postmaster - Mailing list pgsql-general

From Lamar Owen
Subject Re: Cannot restart the postmaster
Date
Msg-id 200202230503.AAA04778@www.wgcr.org
Whole thread Raw
In response to Cannot restart the postmaster  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On Monday 18 February 2002 07:59 pm, Rich Shepard wrote:
>   I've upgraded from 7.1.3 to 7.2, and I've tried to restart the postmaster
> using (as root), /etc/rc.d/init.d/postgresql restart. However, this is what
> I see:

> $An old version of the database format was found.\nYou need to upgrade the
> data format before using PostgreSQL.\nSee
> /usr/doc/postgresql-7.2/README.rpm-dist for more information.

>   I have no data in template1, and according to the README.rpm-dist,
> restarting the postmaster (and I did a separate 'stop' and 'start', too)
> should upgrade the database format. T'ain't workin' here.

Well, you have to make a dump to upgrade with.  My recommendation is to
downgrade to 7.1.3, make a full dump, upgrade to 7.2, blow out theold
database in /var/lib/pgsql/data/*, start 7.2, then pull in the dump.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Wierdness using SUM to add results of custom C
Next
From: Kenneth Gangstoe
Date:
Subject: Re: game db