Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C834D2E004D for ; Wed, 20 Feb 2008 05:15:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 93860-03-2 for ; Wed, 20 Feb 2008 05:15:48 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178]) by postgresql.org (Postfix) with ESMTP id 054E62E0050 for ; Wed, 20 Feb 2008 05:15:51 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d37so4343841pye.29 for ; Wed, 20 Feb 2008 01:15:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=iJPyv/gKOOtCo3wGy4266n4yxY7j5TD7oYd4W5xdAxY=; b=GhZ755PMzDBGClh7wsOzYyGZIdP0Py2x2kQqifxk+epVZfPkBB2MG3DLJmcdG5secTaoPc6i79Rgy+qnSUstt0fner/NAH4mnn3GcLp+0oUauNPOP6lULmkMXCP+WOBjsE4zmDmsV/bLdXSfMFysIVx/4Fmtvsq66T32nMAAVJ8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=WFvSyp5V2hJhHeWvx/ZHCEhWosY31V57ck6Ev/w1IRkuUxtnE3hbbsm7spOV5r/EIBcNvWi4hNZRRg4eXdrFf7uVLeosmmTotU8HXHMPFu8wEC+gCRWiyT374/khDT8QenVfbDEq32pEAu4S+LxtTDw+pLI9JKMELkIfL7OgWhI= Received: by 10.140.134.15 with SMTP id h15mr5548179rvd.48.1203498950089; Wed, 20 Feb 2008 01:15:50 -0800 (PST) Received: by 10.141.152.4 with HTTP; Wed, 20 Feb 2008 01:15:50 -0800 (PST) Message-ID: <238696420802200115m522cfd11h2f37d87845c2d6e0@mail.gmail.com> Date: Wed, 20 Feb 2008 14:45:50 +0530 From: "Rajiv Rajaian" To: "Shane Ambler" Subject: Re: How to create a new user with password in commandline with no prompt for password Cc: pgsql-admin@postgresql.org In-Reply-To: <47BBDF78.7070801@Sheeky.Biz> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5995_12694330.1203498950081" References: <238696420802192330g69e3c447jeadd1d3d31506eda@mail.gmail.com> <47BBDF78.7070801@Sheeky.Biz> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200802/225 X-Sequence-Number: 28299 ------=_Part_5995_12694330.1203498950081 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 > ------=_Part_5995_12694330.1203498950081 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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

------=_Part_5995_12694330.1203498950081--