Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 269669FC723 for ; Thu, 25 Oct 2007 11:37:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 37541-07 for ; Thu, 25 Oct 2007 11:37:09 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 09EE69FC732 for ; Thu, 25 Oct 2007 11:37:08 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id l9PEb19a029418 for ; Thu, 25 Oct 2007 11:37:02 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id l9PEDVJk022956 for pgsql-admin@postgresql.org; Thu, 25 Oct 2007 11:13:31 -0300 (ADT) (envelope-from news) From: yogesh X-Newsgroups: pgsql.admin Subject: Suse Linux Postgres Date: Thu, 25 Oct 2007 14:13:35 -0000 Organization: http://groups.google.com Lines: 27 Message-ID: <1193321615.089451.14010@z24g2000prh.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1) Gecko/20061023 SUSE/2.0-30 Firefox/2.0,gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 SUMAN1, 1.1 SIFY Complaints-To: groups-abuse@google.com Injection-Info: z24g2000prh.googlegroups.com; posting-host=124.30.27.18; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/251 X-Sequence-Number: 27165 Hello Frnds, I am using the Postgres on Linux, its the default that gets installed with the Suse Linux. Now when i run the psql command it ask for password....I have created a role named "abccc" now i want to assign it a password......how to do it in Linux......... before trying this I was trying to install the Pl/java but it was giving problem that is authentication failed for the USer "abccc" if i give the password ........as i have created the "abccc" role without password...........by using command createuser abbccc. If i remove the Password option then it ask that,,,,,,, Postgres option is not without password(something like this not exact).......Then i tried to alter the user to set the password for it.......and face the following problem...... any kind of suggestion would be appreciated ................... Best Regards, Yogesh Arora.