От:
"pgsql-admin" <pgsql-admin@fc.emc.com.ph>
Дата:
joydip@cal2.vsnl.net.in writes: >Dear Mike, > > I am trying to create the user but it was giving folllowing errors > > [postgres@ns data]$ su siddharta > su: user siddharta does not exist > > This is how I created the user........ > > [postgres@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'.