Re: BUG #6260: not accept password

[Please reply to the list]
On Oct 18, 2011, at 10:45 AM, Ric Eittreim wrote:

> Hello Sachin - I have tried that and appreciate the suggestion - just did
> not work. When I did the install, I remember twice it asked for a name,
> both times I gave the same one (4 characters) - so now I'm wondering if
> the system asks automatically for a password (now I'm questioning my
> memory of the install process a few hours ago) - I have done so many
> iterations of trying to get this working I have myself completely
> confused. What I would like to do is start over, delete that account and
> setup a new one but I cannot even get to the psql prompt as it requiresŠ.
> A password!

You can change the authentication mode to trust in your pg_hba.conf file (which is located inside the PGDATA directory). After this you need to reload the server.
You wont be asked a password this time. Log in and the change the password of the user using ALTER ROLE (see http://www.postgresql.org/docs/9.0/static/sql-alterrole.html)
Then you can change the authentication settings back and use the changed password.
>
> Ric
>
>
> On 10/17/11 9:41 PM, "Sachin Srivastava"
> <sachin(dot)srivastava(at)enterprisedb(dot)com> wrote:
>
>>
>> On Oct 18, 2011, at 3:49 AM, Ric Eittreim wrote:
>>
>>>
>>> The following bug has been logged online:
>>>
>>> Bug reference: 6260
>>> Logged by: Ric Eittreim
>>> Email address: ric(at)groundtruth(dot)com
>>> PostgreSQL version: 9.0.4
>>> Operating system: Mac LION
>>> Description: not accept password
>>> Details:
>>>
>>> I just installed Postgres for the first time to learn sql. After what
>>> appeared to be a successful install, I enter psql and it prompts for a
>>> password. I enter the same password that is requested (twice) during
>>> the
>>> install but no matter what I try, it claims "incorrect password
>>> attempts" -
>>> I used only 4 simple characters (rwe9) as this is just a place to
>>> learn.
>>> Can you help me please???
>> try giving -U <username> option to psql and then enter the password for
>> that user.
>>
>>>
>>> --
>>> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-bugs
>>
>> --
>> Regards,
>> Sachin Srivastava
>> EnterpriseDB, the Enterprise PostgreSQL company.
>>
>

--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.