Обсуждение: Cannot restart the postmaster
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
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
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