Обсуждение: Postgresql 8.0.10 on FC4

Hello list,

I downloaded the 8.0.10 rpms for FC4 yesterday and after installing
it, postgresql won't start. I get the following error: "An old
version of the database format was found...."  My previous postgresql
version was 8.0.8 and I read nothing on the release notes about a
dump/restore/initdb requirement. I compared the postgresql startup
scripts (/etc/init.d/postgresql) for versions 8.0.8 and 8.0.10 and
the difference was the 8.0.10 no longer has the variable
$PGMAJORVERSION, i.e:

137c140
<               if [ `cat "$PGDATA/PG_VERSION"` != "$PGVERSION" ]
---
 >               if [ x`cat "$PGDATA/PG_VERSION"` !=
x"$PGMAJORVERSION" ]

After doing the necessary changes, the database started and
everything seems fine. I just want to make sure I didn't ruin
anything and the change was harmless (sorry, i'm a newbie). Thank you.

dianne

Hi,

On Fri, 2007-01-19 at 12:52 -0800, Dianne Yumul wrote:

> I downloaded the 8.0.10 rpms for FC4 yesterday and after installing
> it, postgresql won't start. I get the following error: "An old
> version of the database format was found...."  My previous postgresql
> version was 8.0.8 and I read nothing on the release notes about a
> dump/restore/initdb requirement.

:-( I realized that a few days before while building Mammoth RPMs, but I
could not find time to commit the fix and then rebuild new sets.

<snip>
> After doing the necessary changes, the database started and
> everything seems fine.

http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsqlrpms/patches/8.0/postgresql.init.diff?r1=1.3&r2=1.4

is the fix that I just committed to CVS.

>  I just want to make sure I didn't ruin anything and the change was harmless

That is almost ok.

I will be building new sets for 8.0.10 over the weekend and push them to
FTP site.

Thanks for the report.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/