[Slackbuilds-users] Problems with the rc.postgresql script included with Postgresql on SBo

[Sebastian Arcus]

On 14/01/14 22:11, Adis Nezirovic wrote:
> On Tue, Jan 14, 2014 at 5:23 PM, Sebastian Arcus <s.arcus at open-t.co.uk> wrote:
>>> Can you run simple commands (as root) such as:  su - postgres -c "ls /"
>> I can - but I get no output. Could it be something amiss with my box? This
>> is a fresh install
> Please check which shell is configured for postgres UNIX user, it
> looks like you have /bin/false or similar instead of /bin/bash.
Argh - that is so right. I always configure non-interactive users on my 
servers with /bin/false as the shell (which is all users except for 
root, in my case). It never crossed my mind that this would affect the 
workings of the postgres user. I've changed the shell on the postgres 
user and it all works now. Lesson learned - but I'm a bit annoyed that I 
didn't think of that one myself!

Thanks so much

> Did you use instructions from README (or pkgtool setup script) while
> creating postgres user?
>
> Note that package for PostgreSQL 9.3 should also install symlinks to
> binaries in /usr/bin, if that's not the case, then something is wrong
> with your PostgreSQL package.
>