Postgres Pro
Downloads
Home   >   mailing lists

Re: How to create a new user with password in commandline with no prompt for password - Mailing list pgsql-admin

From Rajiv Rajaian
Subject Re: How to create a new user with password in commandline with no prompt for password
Date
Msg-id 238696420802200115m522cfd11h2f37d87845c2d6e0@mail.gmail.com
Whole thread Raw
In response to Re: How to create a new user with password in commandline with no prompt for password  (Shane Ambler <pgsql@Sheeky.Biz>)
List pgsql-admin
Tree view
Hi Shane
Thanks for u r suggestions
I tried to create user with the following command ..Im getting authentication error for postgres user

[root@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

pgsql-admin by date:

Previous
From: Shane Ambler
Date:
Subject: Re: How to create a new user with password in commandline with no prompt for password
Next
From: Dimitri Fontaine
Date:
Subject: Re: Database Loading