[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] BUG #5249: PGUSER has to be set in the console for PSQL to
From:       Ashish Anand <Ashish.The.Dev () gmail ! com>
Date:       2009-12-19 8:04:59
Message-ID: c92445880912182352i7859e69ekf30d71768cd4e3b2 () mail ! gmail ! com
[Download RAW message or body]

Yes, the file is there as of now and its contents are:
localhost:5432:*:postgres:bar


I am not sure if the file was there when it actually happened. But the repro
steps are complete in themselves and can be reproed on any fresh install of
ver 8.4.1.

Thanks,
Ashish.

On Sat, Dec 19, 2009 at 5:57 AM, Alvaro Herrera
<alvherre@commandprompt.com>wrote:

> Ashis Anand escribió:
>
> > Problem Statement: PGUSER has to be set for PSQL to authenticate. If left
> > unset the connection to database fails with the error mentioned below.
> >
> > STEPS:
> > 1. Install PostgreSQL.
> > 2. Start psql from start menu
> > 3. create a role for the user 'foo' through the following statement
> >         CREATE ROLE foo LOGIN CREATEDB CREATEROLE PASSWORD 'bar'
> > 4. Create a database mydb
> >          CREATE DATABASE mydb WITH OWNER = foo
> > 5. Open your normal console where pguser is not set
> > 6. Run: "psql mydb"
> > 7. Enter the password as 'bar'
> >
> > Actual output:
> > psql: FATAL:  password authentication failed for user "foo"
>
> Hmm.  Do you have a pgpass.conf file with a conflicting password for
> user foo?
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>

[Attachment #3 (text/html)]

<span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: \
13px; border-collapse: collapse; "><div>Yes, the file is there as of now and its \
contents are:</div><div>localhost:5432:*:postgres:bar</div><div>

<br></div><div><br></div><div>I am not sure if the file was there when it actually \
happened. But the repro steps are complete in themselves and can be reproed on any \
fresh install of ver 8.4.1.</div><div><br></div><div>Thanks,</div>

<div>Ashish.</div></span><br><div class="gmail_quote">On Sat, Dec 19, 2009 at 5:57 \
AM, Alvaro Herrera <span dir="ltr">&lt;<a \
href="mailto:alvherre@commandprompt.com">alvherre@commandprompt.com</a>&gt;</span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex;">

Ashis Anand escribió:<br>
<br>
&gt; Problem Statement: PGUSER has to be set for PSQL to authenticate. If left<br>
&gt; unset the connection to database fails with the error mentioned below.<br>
&gt;<br>
&gt; STEPS:<br>
&gt; 1. Install PostgreSQL.<br>
&gt; 2. Start psql from start menu<br>
&gt; 3. create a role for the user &#39;foo&#39; through the following statement<br>
&gt;         CREATE ROLE foo LOGIN CREATEDB CREATEROLE PASSWORD &#39;bar&#39;<br>
&gt; 4. Create a database mydb<br>
&gt;          CREATE DATABASE mydb WITH OWNER = foo<br>
&gt; 5. Open your normal console where pguser is not set<br>
&gt; 6. Run: &quot;psql mydb&quot;<br>
&gt; 7. Enter the password as &#39;bar&#39;<br>
&gt;<br>
&gt; Actual output:<br>
&gt; psql: FATAL:  password authentication failed for user &quot;foo&quot;<br>
<br>
Hmm.  Do you have a pgpass.conf file with a conflicting password for<br>
user foo?<br>
<font color="#888888"><br>
--<br>
Alvaro Herrera                                <a href="http://www.CommandPrompt.com/" \
target="_blank">http://www.CommandPrompt.com/</a><br> The PostgreSQL Company - \
Command Prompt, Inc.<br> </font></blockquote></div><br>



[prev in list] [next in list] [prev in thread] [next in thread]