From: | r d <rd0002(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Postgres 9 Installation problems |
Date: | 2010-09-25 10:21:39 |
Message-ID: | AANLkTim8vyp+SzECuWfZztqA4kw8rz3K8Lw-Ljck8cZ7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | faz | 2010-09-25 10:23:12 | BUG #5678: libpq.so.4 is needed for pgadmin3 |
Previous Message | Dean Rasheed | 2010-09-25 06:58:34 | Re: Mapping Hibernate boolean to smallint(Postgresql) |