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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
