Re: Postgres 7.0.2-2 on Red Hat 7.0?

From: teg(at)redhat(dot)com (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=)
To: "Steve Wolfe" <steve(at)iboats(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres 7.0.2-2 on Red Hat 7.0?
Date: 2000-10-25 21:24:38
Message-ID: xuyu2a0y5pl.fsf@hoser.devel.redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Steve Wolfe" <steve(at)iboats(dot)com> writes:

> > Better yet, install the PostgreSQL 7.0.2 packages that come with RedHat
> > 7. They are derived from the 7.0.2-2 packages on the postgresql ftp
> > site.
>
> RedHat's installation of PostgreSQL is abominable.

It's the same one as Lamar's, and I think it's a good one - and
complies with FHS.

> It does not put it in the default location

Yes - programs, libraries in /usr, databases etc. in
/var/lib/pgsql. Nice and FHS-compliant.

> and it puts the binaries (psql, pg_dump, etc.) in /bin

/usr/bin, of course, where they belong

> and the shared libraries in /lib or /usr/lib.

/usr/lib - see above.

Using /usr is what distributions are supposed to do. /usr/local is for
local use, and in Red Hat typically means "not managed by
rpm". Lamar's RPMs also go in /usr - since this is the correct
location.

> So, if you ever decide to upgrade, you have to go hunting in /bin and /lib
> (or is it /usr/lib?) and delete all of the old files before the new
> installation will work correctly.

rpm -e postgresql postgresql-devel [...other postgres packages...]

or just

rpm -e `rpm -qa|grep postgresql`

Or use gnorpm, kpackage or whatever GUI tool you prefer.

> If they had just installed it in the default directory, and put
> /usr/local/pgsql/bin in the path and /usr/local/pgsql/lib in
> ld.so.conf, it would be good. They could even put
> the base directory in /var to keep themselves happy.

We put it in the right place to keep our users happy and conform to
FHS. Distributions should never touch /usr/local.

> But the way they did it makes upgrades very difficult.

Just install it in /usr (use "--prefix"), or better: Use supplied RPMs
or make your own.

--
Trond Eivind Glomsrød
Red Hat, Inc.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2000-10-25 21:43:24 Re: Postgres 7.0.2-2 on Red Hat 7.0?
Previous Message Peter Eisentraut 2000-10-25 20:32:36 Re: MySQL -> pgsql