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=
=8A.
> A password!

You can change the authentication mode to trust in your pg_hba.conf file (w=
hich is located inside the PGDATA directory). After this you need to reload=
 the server.=20
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 pa=
ssword.=20
>=20
> Ric
>=20
>=20
> On 10/17/11 9:41 PM, "Sachin Srivastava"
> <sachin.srivastava@enterprisedb.com> wrote:
>=20
>>=20
>> On Oct 18, 2011, at 3:49 AM, Ric Eittreim wrote:
>>=20
>>>=20
>>> The following bug has been logged online:
>>>=20
>>> Bug reference:      6260
>>> Logged by:          Ric Eittreim
>>> Email address:      ric@groundtruth.com
>>> PostgreSQL version: 9.0.4
>>> Operating system:   Mac LION
>>> Description:        not accept password
>>> Details:=20
>>>=20
>>> 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.=20
>>> Can you help me please???
>> try giving -U <username> option to psql and then enter the password for
>> that user.
>>=20
>>>=20
>>> --=20
>>> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-bugs
>>=20
>> --
>> Regards,
>> Sachin Srivastava
>> EnterpriseDB, the Enterprise PostgreSQL company.
>>=20
>=20

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