Re: HELP FOR POSTGRESQL NEEDED...

Hello ozric,

Saturday, July 6, 2002, 9:22:44 AM, you wrote:


ot> Hello.I am experiencing a quite strange behavior with my
ot> postgreSQL database.

ot> I have edited the file pg_hba.conf like this:

ot> # TYPE     DATABASE    IP_ADDRESS    MASK               AUTH_TYPE  AUTH_ARGUMENT
ot> local      all                                                                       password
ot> host       all         127.0.0.1     255.255.255.255                   password

ot> in order to require user authentication.This works perfectly when
ot> I connect to the database with psql or pgaccess and I'm able to
ot> perform

ot> all kinds of queries.

ot> However when I try to connect to the database with C++ even though
ot> it allows me to connect (providing the correct username &
ot> password)

ot> all the queries fail...The C++ code I use is the following:

Did you start the postmaster with -i parameter so that it allows
TCP/IP connections ?
Run a nmap localhost command to check if your 5432 port is open. If
PostgreSQL is running and accepting connections, it should be listed
as open.
Psql will connect through unix sockets, not as TCP sockets.

------------- 
Best regards,Steve Howe                           mailto:howe@carcass.dhs.org