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

["Rajiv Rajaian" <rajiv(dot)pgsql(at)gmail(dot)com>]

Hi vishal

While running it as "root" user Im getting 
[root(at)g151 ~]# echo "CREATE ROLE globus WITH PASSWORD 'globus' CREATEDB;" | psql -U postgres
psql: FATAL:  Ident authentication failed for user "postgres"

Also with "postgres" user getting the same error 

[postgres(at)g151 ~]$  echo "CREATE ROLE globus WITH PASSWORD 'globus' CREATEDB;" | psql -U postgres
psql: FATAL:  database "postgres" does not exist

On Feb 20, 2008 3:43 PM, Vishal Arora <aroravishal22(at)hotmail(dot)com> wrote:

you have to be Postgres Super user to use this command. and instead of CREATE USER - use CREATE ROLE...

---

Date: Wed, 20 Feb 2008 14:45:50 +0530
From: rajiv(dot)pgsql(at)gmail(dot)com
To: pgsql(at)sheeky(dot)biz
Subject: Re: [ADMIN] How to create a new user with password in commandline with no prompt for password
CC: pgsql-admin(at)postgresql(dot)org

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

---

It's about getting married. Click here! Try it!