Postgres 9 Installation problems

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

Responses

Browse pgsql-bugs by date

  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)