Authentication Failed - new user installation - Mailing list pgsql-general

From ray
Subject Authentication Failed - new user installation
Date
Msg-id 534d677e-77f8-49e1-ba25-a6c19487f347@w35g2000prg.googlegroups.com
Whole thread Raw
Responses Re: Authentication Failed - new user installation  (Scott Mead <scott.lists@enterprisedb.com>)
List pgsql-general
I have installed 8.2 on a Windows 2000 laptop.

I think it is installed.  From the pgAdmin, it shows "Servers (1)" and
it is named PostgreSQL Database Server 8.2 (localhost:5432).  Right
clicking for  says I can stop services or disconnect so I am guessing
that it is running.

Is that correct?

Under that, there is a Databases(1) folder with the component
"postgres".  Right clicking on it does not give a choice to start or
stop.  What is this telling me?

On the file menu, when I select "add server" and fill in the boxes, I
get an error message "An error has occurred:  Error connecting to the
server:  FATAL:  password authentication failed for user
myadminaccnt."

When I setup 8.3, I used my myadminaccnt password for the
installation, I used it again on the next request for a password.  So
I have used only it for all the requested passwords.

I don't know if this has any relationship, but when I installed 8.3, I
tried to use myadminaccnt as the user name but it said that was
missing a right so I elected to let 8.3 build a user "postgreadmin"
with the same password.

How can I go forward?  When I build this again on another machine, how
do I avoid this problem?

TIA,
Ray






pgsql-general by date:

Previous
From: Martin Gainty
Date:
Subject: Re: metadata development
Next
From: Scott Mead
Date:
Subject: Re: Authentication Failed - new user installation