Re: How to create a new user with password in commandline with no prompt for password

From: "Rajiv Rajaian" <rajiv(dot)pgsql(at)gmail(dot)com>
To: "Shane Ambler" <pgsql(at)sheeky(dot)biz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to create a new user with password in commandline with no prompt for password
Date: 2008-02-20 09:15:50
Message-ID: 238696420802200115m522cfd11h2f37d87845c2d6e0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-es-ayuda

Hi Shane
Thanks for u r suggestions
I tried to create user with the following command ..Im getting
authentication error for postgres user

[root(at)g151~]# echo "CREATE USER globus WITH PASSWORD 'globus' CREATEDB;" |
psql -U postgres
psql: FATAL: IDENT authentication failed for user "postgres"

> Get Sheeky @ http://Sheeky.Biz
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dimitri Fontaine 2008-02-20 09:17:48 Re: Database Loading
Previous Message Shane Ambler 2008-02-20 08:06:16 Re: How to create a new user with password in commandline with no prompt for password

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Rajiv Rajaian 2008-02-20 10:19:42 Re: How to create a new user with password in commandline with no prompt for password
Previous Message Jose Maria Mencia Fernandez 2008-02-20 08:48:18 Re: Re[2]: tsearch2 vs. like