Re: Cannot restart the postmaster

Поиск
Список
Период
Сортировка
От Lamar Owen
Тема Re: Cannot restart the postmaster
Дата
Msg-id 200202230503.AAA04778@www.wgcr.org
обсуждение исходный текст
Ответ на Cannot restart the postmaster  (Rich Shepard <rshepard@appl-ecosys.com>)
Список 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 по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Wierdness using SUM to add results of custom C
Следующее
От: Kenneth Gangstoe
Дата:
Сообщение: Re: game db