| From: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
|---|---|
| To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Cannot restart the postmaster |
| Date: | 2002-02-23 05:04:17 |
| Message-ID: | 200202230503.AAA04778@www.wgcr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2002-02-23 06:25:26 | Re: Regular Expression for 'and' instead of 'or' |
| Previous Message | Neil Conway | 2002-02-23 04:36:39 | Re: Wierdness using SUM to add results of custom C |