Re: How add db users from shell script with their passwords?

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: How add db users from shell script with their passwords?
Дата
Msg-id 200806031300.03277.achill@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Re: How add db users from shell script with their passwords?  ("Medi Montaseri" <montaseri@gmail.com>)
Список pgsql-admin
Στις Tuesday 03 June 2008 11:28:44 ο/η Medi Montaseri έγραψε:
> You can write a program in say Perl and use "create user bob with
> .....options ....encrypted password xxxxx valid until xxx " which is pretty
> much what createuser(1) does.
>

why not just

#!/bin/sh
psql -c "CREATE USER foo PASSWORD 'bar'"


> Cheers
> Medi
>
> On Tue, Jun 3, 2008 at 12:54 AM, Илья Скорик <ilya.skorik@inprint.ru> wrote:
>
> > Dear community, help please.
> >
> > I need to add some standard users to database together with their
> > standard passwords from a shell script. That the script would not ask
> > to enter passwords manually for each user. How it can be made?
> >
> > How I have understood, createuser comand does not allow to make it?
> >
> > In advance thanks.
> >
> > --
> > --
> > С уважением, Илья Скорик
> > специалист
> > Inprint - автоматизация вашего издательства
> >
> > Yours faithfully, Ilya Skorik
> > the expert
> > Inprint - automation of your publishing house
> >
> > e-mail: ilya.skorik@inprint.ru
> > web: http://www.inprint.ru/
> >
> > --
> > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-admin
> >
>



--
Achilleas Mantzios

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

Предыдущее
От: "Medi Montaseri"
Дата:
Сообщение: Re: How add db users from shell script with their passwords?
Следующее
От: Rommel the iCeMAn
Дата:
Сообщение: Re: UUID generation functions