Обсуждение: Authentication problem - password and authentication for user postgres is failing.

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
triedto start psql.  It gave me all the prompts and when I put in the user postgres, it prompted for the password.
WhenI put in the password, it told me that the authentication failed.  I know what I intended the password to be and I
havetyped every permutation of that password I can think of and nothing works.  The only think that I can think is that
Isomehow "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
thatI 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

On Mon, Aug 12, 2013 at 05:50:16PM -0400, Carol Walter wrote:
> 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.

You can modify pg_hba.conf, change md5 to trust, bounce the server or do
pg_ctl reload, and you should be able to log in without a password and
change it.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +