Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C59569FC924 for ; Thu, 25 Oct 2007 12:34:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 46711-03 for ; Thu, 25 Oct 2007 12:34:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 298D69FC7E6 for ; Thu, 25 Oct 2007 12:33:06 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so548419ugf for ; Thu, 25 Oct 2007 08:33:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=9DohoCWDFcGMztFVDhEfbsjyRC5OIxrU0ubmZAh+XoU=; b=gb6erdakzwVP/ezwzN2D0FaAJM5xBaKFefhskeJEzHxX6ltR6PNGLsJ4tvUnS50ai0+/jV3SEUSI31WnXSTcQK45okOPULLJFpaVYgYYIaL48l4WgZhFsZILsWLkajil2djFMPjl6rB0rY0372E+eCuQUDNwyLgSneXMUCoY6Go= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=OGgS8S0oBpMs7oAkQXaIiei2l8MSvJJaQMNU/QX1XbpRxgg8ROs2+Yz7LKSn9D8b8A48DVCFcGfQGisHlimemJAaLqippKZdxZdGNvf3vx4FS1y1n+rfVH5a07N4Z9AZGLE4cxbJL68a9aspVtWVfCC/H2G+0/JnETpbp7yPRR4= Received: by 10.66.220.12 with SMTP id s12mr72186ugg.1193326383528; Thu, 25 Oct 2007 08:33:03 -0700 (PDT) Received: by 10.67.40.10 with HTTP; Thu, 25 Oct 2007 08:33:03 -0700 (PDT) Message-ID: Date: Thu, 25 Oct 2007 10:33:03 -0500 From: "Scott Marlowe" To: yogesh Subject: Re: Suse Linux Postgres Cc: pgsql-admin@postgresql.org In-Reply-To: <1193321615.089451.14010@z24g2000prh.googlegroups.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1193321615.089451.14010@z24g2000prh.googlegroups.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/253 X-Sequence-Number: 27167 On 10/25/07, yogesh wrote: > 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 ................... http://www.postgresql.org/docs/8.2/static/libpq-pgpass.html