Authentication problem - password and authentication for user postgres is failing.

From: Carol Walter <carol(dot)walter(at)sbcglobal(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Authentication problem - password and authentication for user postgres is failing.
Date: 2013-08-12 21:50:16
Message-ID: 9BC5DFDE-9B79-4050-9CCB-2DFD730CF585@sbcglobal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello...
and thank you for your help!

I can't be the only one to whom this has happened. I just set up a new postgreSQL server on a Mac that is running OS 10.6.8. I was using an image that I downloaded from EnterpriseDB. I ran the set up and all was well, I thought, so I tried to start psql. It gave me all the prompts and when I put in the user postgres, it prompted for the password. When I put in the password, it told me that the authentication failed. I know what I intended the password to be and I have typed every permutation of that password I can think of and nothing works. The only think that I can think is that I somehow "fat fingered" the password and I don't have a ghost of a chance to figure out what it is now. Is there a way that I can reset the password? I had the same result when I tried to connect to the database using pgAdmin.

Actually, I don't even know if Postgres started.

Carol

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2013-08-12 22:19:08 Re: Authentication problem - password and authentication for user postgres is failing.
Previous Message raghu ram 2013-08-12 10:08:41 Re: Queries/executions per second