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