[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.srivast...@enterprisedb.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: r...@groundtruth.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@postgresql.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.
