[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.
> 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
>>> 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
>>> 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
>>> 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:
>> Sachin Srivastava
>> EnterpriseDB, the Enterprise PostgreSQL company.
EnterpriseDB, the Enterprise PostgreSQL company.
pgsql-bugs by date
|Next:||From: Vishnu S.||Date: 2011-10-18 06:05:11|
|Subject: Re: Tablespace files deleted in continuous run|
|Previous:||From: Sachin Srivastava||Date: 2011-10-18 04:41:36|
|Subject: Re: BUG #6260: not accept password|