Hi Vishal Now I m able to create new user using command line I ve created a database named 'postgres' for postgres user and I ve created the new user in comand line
The steps I ve used [EMAIL PROTECTED] ~]# su postgres -c "createdb postgres" could not change directory to "/root" CREATE DATABASE [EMAIL PROTECTED] ~]# echo "CREATE USER globus WITH PASSWORD 'globus' CREATEDB;" | psql -U postgres -d postgres psql: FATAL: Ident authentication failed for user "postgres" [EMAIL PROTECTED] ~]# su postgres -c "echo \"CREATE USER globus WITH PASSWORD 'globus' CREATEDB;\" | psql -U postgres -d postgres" could not change directory to "/root" CREATE USER [EMAIL PROTECTED] ~]# su globus -c "createdb rftDatabase" could not change directory to "/root" CREATE DATABASE Thanks to Vishal, Shane and pgsql-admin list Thanks/Regards Rajiv Project Associate, CARE,MIT, Anna University
