Re: User can not more login - Mailing list pgsql-general

From Chris
Subject Re: User can not more login
Date
Msg-id 44E018E8.4070100@gmail.com
Whole thread Raw
In response to User can not more login  (Michelle Konzack <linux4michelle@freenet.de>)
Responses Re: User can not more login  (Michelle Konzack <linux4michelle@freenet.de>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Best approach for a "gap-less" sequence
Next
From: "Philippe Lang"
Date:
Subject: Re: Migrating PostgreSQL database to MySQL/MS Access