Re: Postgres 7.0.2-2 on Red Hat 7.0?

Steve Wolfe wrote:
>   RedHat's installation of PostgreSQL is abominable.  It does not put it in
> the default location, and it puts the binaries (psql, pg_dump, etc.) in
> /bin, and the shared libraries in /lib or /usr/lib.

It is explained in numerous places (in particular, the README.rpm file
that is distributed with the RPM's) why those locations have to be the
way they are.  But it boils down to PostgreSQL wanting to be installed
in a non-standard place -- standard meaning Linux Standard Base, or
Filesystem Hierarchy Standard (which is inluded in the LSB).  The RedHat
RPM installation is FHS-compliant -- which RedHat desires greatly.

> /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.  But the way they did
> it makes upgrades very difficult.

Not if you just do 'rpm -U' -- the RPM just simply handles it.  It knows
where every file is -- you need not concern yourself with those details.

Just make sure to do a pg_dumpall before upgrading.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11