Actually you should blow it away and install in /opt/pgsql. /usr/local source should only be used on systems where the program is used locally only. Hence it is technically correct according to FHS but in my discussions on the FHS list, /opt/pgsql is more correct if any of the programs will be shared.
Also, there are three possible places to put the PG system data: /pgsql/sydata/data, /srv/dbdata/pgsql, or /opt/mysystem/pgsql/data (which would be where to put it for a binary distro for sure). I am not sure if PG can create seperate data files per tablespaces as does Oracle, but if it does, each users data should be in thier home directory.
