Postgres Pro
Downloads
Home   >   mailing lists

Thread: Cannot restart the postmaster

Cannot restart the postmaster

From
Rich Shepard
Date:
  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.

  Please send suggestions as I'm on a roll now with my accounting package
and I want to continue working on it.

Many thanks,

Rich

Dr. Richard B. Shepard, President

                       Applied Ecosystem Services, Inc. (TM)
            2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
 + 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@appl-ecosys.com
                         http://www.appl-ecosys.com

Re: Cannot restart the postmaster

From
Rich Shepard
Date:
On Sun, 17 Feb 2002, Len Morgan wrote:

> I just had this problem a few hours ago.  It seems that the PG_VERSION file
> is the problem.  Some directories got moved, etc.  You might want to read
> the "Upgrading" section of the Upgrade-rpm-dist  I ended up removing either
> the base or the data directory and then the initdb worked (as did starting
> up postmaster).

Len,

  Yes, PG_VERSION -- both copies -- report 7.1. I've read
/usr/doc/postgresql-7.2/README.rpm-dist and didn't see anything about this
problem. There is plenty of information about saving existing databases
before upgrading, but not on the particular problem. Let me try removing a
directory ...

> Hope that helps

  Yup! That did it. I moved pg_hba.conf to a safe place, rm'd the complete
data/ directory and, as postgres, ran initdb. Voila! Moved pg_hba.conf back
and, as root, restarted the postmaster.

Many thanks! I'll save this message for the next time.

Rich

Dr. Richard B. Shepard, President

                       Applied Ecosystem Services, Inc. (TM)
            2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
 + 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@appl-ecosys.com
                         http://www.appl-ecosys.com

Re: Cannot restart the postmaster

From
Lamar Owen
Date:
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