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
