- Архив списков рассылки pgsql-admin

Поиск
Список
Период
Сортировка
От pgsql-admin
Тема
Дата
Msg-id fc.000f567200a5f325000f567200a5f325.a5f36b@fc.emc.com.ph
обсуждение исходный текст
Список pgsql-admin
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'.




В списке pgsql-admin по дате отправления:

Предыдущее
От: Tim Frank
Дата:
Сообщение: Re: Backing up postgresql databases
Следующее
От: "pgsql-admin"
Дата:
Сообщение: Re(2): Re: cannot create new user in postgres