Thanks Robin. What u said is right! But my problem is i am not trying connecting from any remote client. In my ConnectionInfo if i mention the host as, host=localhost.The connection is successful. But the same if i give my localsystem IP where my server is running.. host = 10.0.2.56(my localhost IP). The Connection is failed. Why is this so?Whether i need to give only localhost in my application (or) why it is not accepting when i gave IP of the same system(When the entry of this IP is already present in pg_hba.conf file)? ----- Original Message ----- From: "Robin Iddon" <robin@xxxxxxxxxx> To: "sandhya" <sandhyar@xxxxxxxxxxxxxx> Cc: "Postgres" <pgsql-admin@xxxxxxxxxxxxxx> Sent: Monday, March 20, 2006 2:28 PM Subject: Re: [ADMIN] reg:conninfo > Try looking at the manual for the postmaster process ... > > A simple way of achieving what you want is adding the -i option to the > postmaster command line which allows TCP/IP connections. Otherwise only > localhost can connect. > > There are possibly other ways of configuring this same option, but we > use the -i on the command line to the postmaster process. > > Hope this helps, > > Robin > > sandhya wrote: > > >hi, > > > > I am using postgres8.0.3 on windows.When i am compiling a small sample i am facing problem in connection information. > > > >I have given entry in my pg_hba.conf file: > >host all all 10.0.3.67/32 md5 > > > >And in my application when i pass host in conninfo as, > >host=10.0.3.67...It is not connecting..and throwing error like, > >Is server running on 10.0.0.205..etc > >But when i give as, > >host=localhost..It is running fine. > >After each change i am doing pg_reload. > >What i need to do inorder to mention the IP in my application instead of localhost? > >Please tell me. > > > >Thank you, > >Sandhya > > > > > > > > > > > > >
