Re: pgadmin

Leonardo,

> i've got pgadmin II v 1.2 and postgre 7.1.1 and I'm having trouble
> connecting to my database.  Pgamin is running on xp and postgre is
> running on a redhat linux box.

Let me warn you right off; PGAdmin, as far as I know, has not been
 tested with XP.

> The error i'm getting happens when i'm trying to connect:
> Number: -214721843
> Description: No pg_hba.conf entry for host 192.168.0.2, user leoj,
> database sbm

> There is a line in my pg_hba.conf that reads:
> host         sbm         192.168.0.2   255.255.255.255    password
> leoj
>
> I've tried it with with a number of combination including:
> host   all   192.168.0.2   255.255.255.0    trust
> host   sbm   192.168.0.2   255.255.255.255  ident  leoj
>
> I've started postmaster with -i and I have tcpip_socket = true in
> postgresql.conf.

I've run into this problem before.  Generally, it's caused by one of a
 few things:
1) I actually have *two* pg_hba.conf files on my machine, and
 Postmaster is reading the wrong one due to wrong startup parameters.
2) I need to stop and re-start postmaster because it isn't noticing the
 change for some reason.
3) My local DNS is screwed up, and the Postgres server is seeing the
 client machine as the wrong IP.

If none of those is the case, then try joining the pgsql-odbc list and
 see if anyone else can help you.

-Josh

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