Re: User can not more login

From: Chris <dmagick(at)gmail(dot)com>
To: Michelle Konzack <linux4michelle(at)freenet(dot)de>
Cc: pgSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: Re: User can not more login
Date: 2006-08-14 06:32:08
Message-ID: 44E018E8.4070100@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Lang 2006-08-14 09:32:14 Re: Migrating PostgreSQL database to MySQL/MS Access
Previous Message Chris 2006-08-14 06:01:28 Re: Best approach for a "gap-less" sequence