Hi vishal While running it as "root" user Im getting [EMAIL PROTECTED] ~]# 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 [EMAIL PROTECTED] ~]$ 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Re: [ADMIN] How to create a new user with password in commandline > with no prompt for password > CC: [email protected] > > > Hi Shane > Thanks for u r suggestions > I tried to create user with the following command ..Im getting > authentication error for postgres user > > [EMAIL PROTECTED] echo "CREATE USER globus WITH PASSWORD 'globus' CREATEDB;" | > psql -U postgres > psql: FATAL: IDENT authentication failed for user "postgres" > > > > Get Sheeky @ http://Sheeky.Biz <http://sheeky.biz/> > > > > ------------------------------ > It's about getting married. Click here! Try > it!<http://ss1.richmedia.in/recurl.asp?pid=201> >
