Re: Cannot restart the postmaster

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