Skip site navigation (1) Skip section navigation (2)

Re: Problems connecting from pgAdmin II v1.1 build 59

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: postgresql(at)gremlins(dot)com(dot)hk, PgSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Problems connecting from pgAdmin II v1.1 build 59
Date: 2001-10-30 16:16:39
Message-ID: web-494883@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-novice
Jason,

Thanks for posting such a clear description of your problem.  It makes
it much easier to provide advice.

In the future, you may wish to join the PGSQL-ODBC list for this and
similar problems relating to PgAdmin (there is a PGAdmin list, but last
I checked it was dead).

> RESULT
> ======
> When I try to connect to the server from pgAdmin I get this error:
> 
>   [FATAL 1: user "blahblah" does not exist]

Simple.  You've added the user to the password.file, but not to the
database.  The error above is because the initial authentication
succeeded, but that user has not been created in the database you are
trying to connect to.

Other things to watch out for: 1) I don't believe that PgAdmin supports
crypted passwords at this time.  You'll have to use cleartext.  2) I've
never been clear on the utility of the password.file, except as a way to
further restrict who cna use a particular interface.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh(at)agliodbs(dot)com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

In response to

Responses

pgsql-novice by date

Next:From: Jason WongDate: 2001-10-30 16:49:27
Subject: Re: Problems connecting from pgAdmin II v1.1 build 59
Previous:From: Jason WongDate: 2001-10-30 15:19:29
Subject: Problems connecting from pgAdmin II v1.1 build 59

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group