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

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