pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rajiv Rajaian <rajiv.pgsql@gmail.com>
To: pgsql-admin@postgresql.org
Subject: How to create a new user with password in commandline with no prompt for password
Date: Wed, 20 Feb 2008 13:00:40 +0530
Message-ID: <238696420802192330g69e3c447jeadd1d3d31506eda@mail.gmail.com> (raw)

Hi all
Im using postgresql-8.0.3-1.
I need to create a new user in postgresql with password ..But it should not
prompt me to get the password ..ie only through command line I've to give
the password as input
Steps i had done are as follows

[root@g151 ~]# su postgres -c "createuser -A -d  globus"
could not change directory to "/root"
CREATE USER

[root@g151 ~]# su globus -c "createdb rftDatabase"
could not change directory to "/root"
CREATE DATABASE

Also in /var/lib./pgsql/data/pg_hba.conf I ve added the entry as

host    rftDatabase     "globus"        "172.16.10.151"  255.255.255.0   md5

Now when i tried to login to that database I got the following error

[root@g151 ~]# psql -U globus -d rftdatabase
psql: FATAL:  Ident authentication failed for user "globus"

Also with password promt it was prompting password ..But I haven't created
the user with password
 [root@g151 ~]# psql -U globus -d rftdatabase -W
Password:


Is it possible to create any new user in postgresql with password through
command line and with no prompt for password.??Is there any option in
Postgresql?
Also  if  I create  a new user with su postgres -c "createuser -A -d
globus" .Will it set any default password while creating the user ??

Please I need some valuable suggestion s

Thanks /Regards
Rajiv
Project Associate
CARE,MIT,
Anna University

view thread (5+ messages)  latest in thread

Message-ID: <238696420802192330g69e3c447jeadd1d3d31506eda@mail.gmail.com>
Permalink:  ../238696420802192330g69e3c447jeadd1d3d31506eda@mail.gmail.com/
Also on:    postgresql.org/message-id/238696420802192330g69e3c447jeadd1d3d31506eda@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: rajiv.pgsql@gmail.com
  Subject: Re: How to create a new user with password in commandline with no prompt for password
  In-Reply-To: <238696420802192330g69e3c447jeadd1d3d31506eda@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox