While running it as "root" user Im getting
[root@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@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@xxxxxxxxxxx> 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.pgsql@xxxxxxxxx
To: pgsql@xxxxxxxxxx
Subject: Re: How to create a new user with password in commandline with no prompt for password
CC: pgsql-admin@xxxxxxxxxxxxxx
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
It's about getting married. Click here! Try it!