pg_hba.conf off the top of my head is my first suspect. Compare with the same login info from pgsql on the shell.
Scott (mobile phone signal is weak right now) On May 11, 2011 2:19 PM, "hatem gamal elzanaty" <[email protected]> wrote: > to plug > i'm facing problem to connect to postgresql via c language the situation > as follows > after making successful connection and terminating the software if i try > making connection with wrong password the postgresql does not refuse > making the connection at all and still making the connection > > does you know what is the problem please can you help in that > thanks in advance > hatem gamal > > ########################################### > # this file named : pgsql.c > ########################################### > #include <stdio.h> > #include <libpq-fe.h> > #include "tools.h" > > int main( ) > { > PGconn *c=ConnectDB(); > CloseConn(c); > return 0; > } > > ########################################### > # this file named : tools.h > ########################################### > #include <libpq-fe.h> > PGconn *ConnectDB() > { > PGconn *conn = NULL; > > // Make a connection to the database > conn = PQconnectdb("hostaddr='127.0.0.1' port='5432' user='test' > password='test22' dbname=contact "); > > // Check to see that the backend connection was successfully made > if (PQstatus(conn) != CONNECTION_OK) > { > printf("Connection to database failed\n"); > } > else > { > > printf("Connection to database - OK\n"); > } > > return conn; > } > > > void CloseConn(PGconn *conn) > { > PQfinish(conn); > } > > > /* > PLUG: http://plug.org, #utah on irc.freenode.net > Unsubscribe: http://plug.org/mailman/options/plug > Don't fear the penguin. > */ /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
