Hi,
I updated PostgreSQL from 8.4.4 to 9.0.0 from repo (PGDG) via yum and it
leaves some business unfinished IMHO.
I have a Fedora Core FC12 (Linux 2.6.32.21-168.fc12.x86_64) up-to-date.
So, after the upgrade, I found the following:
a) The postgresql service is not present anymore, so I must start it by hand
like this: sudo /etc/init.d/postgresql-9.0 start
(and register the service by hand so that it does start with system
startup).
--> I expect the installer to install the system service into the list of
services/daemons which are started at boot.
b) The binaries (pg_dump, pg_restore, psql ...) of the new version are now
in their own directory (/usr/pgsql-9.0/bin etc).
The installer did not append a PATH entry to that new hierarchy or set the
links to the binaries into /usr/bin.
--> I expect a PATH entry to point to wherever the binaries are, or that
there are links in /usr/bin
c) pg_restore from PostgreSQL 9 apparently does not recognize compressed
files generated by pg_dump from V 8.4.4
pg_restore V9 either said that the file was invalid, or it would just hang.
I had to gunzip the dump by hand and then load it using psql.
--> I expect pg_restore to work with a dump produced by pg_dump, or at least
to tell me what is wrong.
d) The new updated installation does not take over the settings (*.conf)
from the previous one.
Don't know if this is as designed so I decided to report it.
Apart form that, thanks lots for the new PostgreSQL to everybody involved.
Greetings from Vienna,
RD