Forum OpenACS Q&A: cant su to postgres
this may seem like a stupid question but its driving me nuts. recently re-installed my debian-sarge system. chucked on apache2 ,php5.0, php5.0-session and postgresql-8.0 using apt-get. Now when I do su - postgres , it dosnt do anything. no errors returned, dosnt even ask for a password. it just stays as whoever im logged in as.
i tried adding the user postgres but it already exsists. which would b be normal i guess.
oh the sources i used for the apt-get was :
deb http://mirrors.lycos-vds.com/debian/ testing main non-free contrib
deb-src http://mirrors.lycos-vds.com/debian/ testing main non-free contrib
deb http://people.debian.org/~dexter php5 sarge
deb http://mirrors.lycos-vds.com/local/debian testing vds
deb-src http://mirrors.lycos-vds.com/local/debian testing vds
i installed this set up only a few days ago and it worked fine. Can anyone point me to where im doing something wrong. Will post more info if needed.
Look at /etc/passwd and see if postgres is set to "nologin" or /bin/false as the shell.
If you have a non-valid shell, you cannot log into the account.