Authentication Failed - new user installation

From: ray <Ray(dot)Joseph(at)CDICorp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Authentication Failed - new user installation
Date: 2009-03-28 07:51:49
Message-ID: 534d677e-77f8-49e1-ba25-a6c19487f347@w35g2000prg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2009-03-28 09:02:31 New shapshot RPMs (Mar 27, 2009) are ready for testing
Previous Message Simon Riggs 2009-03-28 07:44:49 Re: metadata development