Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: fazDate: 2010-09-25 10:23:12
Subject: BUG #5678: libpq.so.4 is needed for pgadmin3
Previous:From: Dean RasheedDate: 2010-09-25 06:58:34
Subject: Re: Mapping Hibernate boolean to smallint(Postgresql)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group