Обсуждение: Postgres 9 Installation problems
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
Hi, On Sat, 2010-09-25 at 12:21 +0200, r d wrote: > 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). As of PostgreSQL 9.0, parallel installation is enabled, I mean, you will be able to install 9.1 along with 9.0 when it is released. So, init script name changed to reflect PostgreSQL version. > --> I expect the installer to install the system service into the list > ofervices/daemons which are started at boot. Nope. RPMs have never ever added PostgreSQL to startup sequence by default. > b) The binaries (pg_dump, pg_restore, psql ...) of the new version are > now in their own directory (/usr/pgsql-9.0/bin etc). Right, see above. > 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 Well, we used alternatives method for that: $ ls -l `which psql` /usr/bin/psql -> /etc/alternatives/pgsql-psql # ls -l /etc/alternatives/pgsql-psql /etc/alternatives/pgsql-psql -> /usr/pgsql-9.0/bin/psql However, we omitted that for some specific binaries like pg_ctl, which is pretty intentional. > 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. You need to take dump using 9.0's pg_dump so that you will be able to restore it... > 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. Right, RPMs don't do such interactive work. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Devrim GÜNDÜZ <devrim@gunduz.org> writes: > On Sat, 2010-09-25 at 12:21 +0200, r d wrote: >> --> I expect the installer to install the system service into the list >> ofervices/daemons which are started at boot. > Nope. RPMs have never ever added PostgreSQL to startup sequence by > default. Right. Years ago I put out a version of the Red Hat Postgres RPMs that did do that, and was roundly chastized for it. An RPM is *not* supposed to assume that merely being installed means that the user wants it to start running a service. Otherwise, simply doing "install everything from the DVD" would be a disaster. regards, tom lane