I don't understand. If I create new users they still look for /usr/bin instead of /usr/local/pgsql/bin. I suppose that is why nspostgres is giving errors. AOL4 starts normal. It serves pages.
When I come back in the afternoon I'll probably start from scratch. I'll take the time to dump RH8 in favor of FreeBSD, but... I'll post my env in case anyone sees the obvious.
[service0@localhost service0]$ createdb service0
/usr/bin/createdb: line 172: /usr/bin/psql: No such file or directory
createdb: database creation failed
[service0@localhost service0]$ env
HOSTNAME=localhost.localdomain
SHELL=/bin/bash
TERM=vt100
HISTSIZE=1000
USER=service0
LD_LIBRARY_PATH=:/usr/local/pgsql/lib
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL=/var/spool/mail/service0
PATH=/usr/local/bin/:/usr/local/pgsql:/usr/local/pgsql/bin:/usr/local/pgsql/include:/usr/local/pgsql/data:/usr/local/pgsql/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/local/pgsql/bin:/home/service0/bin
INPUTRC=/etc/inputrc
PWD=/home/service0
LANG=en_US.UTF-8
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1
HOME=/home/service0
LOGNAME=service0
LESSOPEN=|/usr/bin/lesspipe.sh %s
G_BROKEN_FILENAMES=1
_=/bin/env
[service0@localhost service0]$
