Re(2): Re: cannot create new user in postgres

From: "pgsql-admin" <pgsql-admin(at)fc(dot)emc(dot)com(dot)ph>
To: joydip(at)cal2(dot)vsnl(dot)net(dot)in
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re(2): Re: cannot create new user in postgres
Date: 2001-03-20 03:19:50
Message-ID: fc.000f567200a5f325000f567200a5f325.a5f388@fc.emc.com.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

joydip(at)cal2(dot)vsnl(dot)net(dot)in writes:
>Dear Mike,
>
> I am trying to create the user but it was giving folllowing errors
>
> [postgres(at)ns data]$ su siddharta
> su: user siddharta does not exist
>
> This is how I created the user........
>
> [postgres(at)ns data]$ createuser siddharta
> Enter user's postgres ID -> 567
> Is user "siddharta" allowed to create databases (y/n) y
> Is user "siddharta" a superuser? (y/n) y
> createuser: siddharta was successfully added
>
> I am looking 4 seriuos help.
>
> Thanks in advance

from 'man createuser'
createuser - Create a new Postgres user
and this will be stored it in the pg_shadow table.

as for the 'su', you cannot switch to the user unless it is
already added in /etc/passwd. you will have to use
'useradd' for this. see 'man useradd'.

Browse pgsql-admin by date

  From Date Subject
Next Message Jay Hodges 2001-03-20 04:42:52 Moving databases
Previous Message Andrew Perrin 2001-03-20 00:15:58 auto-starting postmaster with -i option