> 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'.
pgsql-admin by date
|Next:||From: Jay Hodges||Date: 2001-03-20 04:42:52|
|Subject: Moving databases|
|Previous:||From: Andrew Perrin||Date: 2001-03-20 00:15:58|
|Subject: auto-starting postmaster with -i option|