Re: User can not more login

Michelle Konzack wrote:
> Hello *,
>
> I am searching for a weired error...  Since all users are working fine,
> I was now root and done a 'su - postgresql' to create a new user with
>
> createuser --password devel.debian
> Shall the new user be allowed to create databases? (y/n) n
> Shall the new user be allowed to create more new users? (y/n) n
> Password:
> CREATE USER

--password asks for YOUR password not the new one.

You need to use:

-P or --pwprompt

see createuser --help for more info.

--
Postgresql & php tutorials
http://www.designmagick.com/