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 =?ISO-8859-1?Q?G=DCND=DCZ?= <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