"Steve Wolfe" <steve@iboats.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.