nbald <nicolas.baldeck@vizille.net> writes:
> this is driving me crazy... Do someone have an idea ?
> # echo 'pgsql:pgsql:100:100:pgsql:/home/pgsql:/bin/sh' >> /etc/passwd
That might have been the only way to create a Unix user account back
around 1972, but it hardly seems like the recommended way now. Doesn't
your distro provide a tool for that?
> # su - pgsql
> warning: cannot change to home directory
> BusyBox v1.7.2 (2010-12-23 22:00:59 CET) built-in shell (ash)
> Enter 'help' for a list of built-in commands.
> $ /tmp/mnt/usb0/part1/usr/bin/postmaster -D '/tmp/mnt/usb0/part1/caisse/db'
> "root" execution of the PostgreSQL server is not permitted.
It sure looks to me like you got the account creation wrong somehow.
Possibly running "id" here would shed some light on what login state
the postmaster is seeing.
regards, tom lane