Re: Postgres 7.0.2-2 on Red Hat 7.0?

"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.