X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DDB489DCE4F for ; Mon, 20 Mar 2006 08:09:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63211-02 for ; Mon, 20 Mar 2006 08:09:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 280039DCE38 for ; Mon, 20 Mar 2006 08:09:23 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k2KC3Nom016286; Mon, 20 Mar 2006 17:33:23 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 6FA3C33266C; Mon, 20 Mar 2006 17:33:23 +0530 (IST) Message-ID: <026301c64c17$f39561d0$cd00000a@sandhyar> From: "sandhya" To: Cc: References: Subject: Re: reg:conninfo Date: Mon, 20 Mar 2006 17:45:17 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:18 M:2 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.139 required=5 tests=[AWL=0.138, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.139 X-Spam-Level: X-Archive-Number: 200603/166 X-Sequence-Number: 20923 Yes Andy..Thats what i did. i checked by giving '*' in listen_address also i gave IP of my system.Both things got failed. Whether reload is enough... or we need to restart it? ----- Original Message ----- From: "Andy Shellam" To: "'sandhya'" Cc: Sent: Monday, March 20, 2006 4:53 PM Subject: Re: [ADMIN] reg:conninfo > Check you've not got a firewall blocking port 5432. If running Windows > firewall on XP/2003, you'll need to set an exception for port 5432. > > As you're on a windows system run "ipconfig" from a command prompt, and note > down the IP addresses on your network interfaces. > > Then set listen_interfaces to one of those IPs and try connecting directly > to that IP. > > Andy > > -----Original Message----- > From: sandhya [mailto:sandhyar@amiindia.co.in] > Sent: Monday, 20 March, 2006 11:21 AM > To: andy.shellam@mailnetwork.co.uk > Subject: Re: [ADMIN] reg:conninfo > > I have changed listen_interfaces =*. > and gave pg_ctl reload..But even then it is not connecting > > > > > ----- Original Message ----- > From: "Andy Shellam" > To: "'sandhya'" > Sent: Monday, March 20, 2006 3:59 PM > Subject: RE: [ADMIN] reg:conninfo > > > > If you put localhost in your application, your system (Windows or Linux) > > will do a DNS lookup and return the 127.0.0.1 IP - if you put the IP > > directly it saves this call. > > > > Check your postgresql.conf file, and look for the listen_interfaces > > directive - check it's set to listen_interfaces=*, and not > > listen_interfaces=127.0.0.1. This will bind it to any available network > > adapter on your system. Then reload PGSQL and try connecting on > 10.0.0.205 > > again. > > > > Andy > > > > -----Original Message----- > > From: sandhya [mailto:sandhyar@amiindia.co.in] > > Sent: Monday, 20 March, 2006 10:30 AM > > To: andy.shellam@mailnetwork.co.uk > > Cc: pgsql-admin@postgresql.org > > Subject: Re: [ADMIN] reg:conninfo > > > > Host all all 127.0.0.1/32 md5 This entry is there in configuration file > > already.So no probs..I can connect. > > But..Just i want to know why it is connecting if i mention just localhost > > and why it giving error if i mention the IP of it(the same m/c's) instead > > of local host. > > Have u seen the image i sent in last mail? > > What is wrong if i mention the localhost IP instead of localhost in my > > connection information? > > > > > > ----- Original Message ----- > > From: "Andy Shellam" > > To: "'sandhya'" > > Cc: > > Sent: Monday, March 20, 2006 3:48 PM > > Subject: RE: [ADMIN] reg:conninfo > > > > > > > You should be able to connect if you tell your application to connect to > > > 127.0.0.1, and put > > > > > > Host all all 127.0.0.1/32 md5 > > > > > > In your pg_hba.conf file - this is a system default loopback IP for > > clients > > > on the same machine. > > > > > > Why is it causing you such a problem using localhost as opposed to an IP > > > address? Using localhost (or 127.0.0.1) saves you a slight network > > overhead > > > than connecting on your network interface's IP. > > > > > > Andy > > > > > > -----Original Message----- > > > From: sandhya [mailto:sandhyar@amiindia.co.in] > > > Sent: Monday, 20 March, 2006 10:13 AM > > > To: andy.shellam@mailnetwork.co.uk > > > Cc: Postgres > > > Subject: Re: [ADMIN] reg:conninfo > > > > > > Hi Andy..... > > > You r right.Just i mentioned all these as examples. > > > I want to connect with the localsystem where the server is running. > > > But in my VC application if i mention in connection info host as > localhost > > > it is working fine. > > > But the same if i give my localsystem IP it is showing the following > > error. > > > Why it is working fine in case of local host and why not incase of IP > > > address. > > > I have mentioned the IP in pg_hba.conf and reloaded it. > > > > > > > > > > > > Please tell me, > > > > > > Thank you, > > > Sandhya R > > > > > > > > > ----- Original Message ----- > > > From: "Andy Shellam" > > > To: "'sandhya'" > > > Cc: > > > Sent: Monday, March 20, 2006 3:22 PM > > > Subject: RE: [ADMIN] reg:conninfo > > > > > > > > > > Sandhya, > > > > > > > > You have mentioned 3 different IP addresses for your server in this > > topic > > > so > > > > far. > > > > > > > > Your pg_hba.conf entry says "10.0.3.67/32" - which means only that IP > > can > > > > connect - the IP address/range in pg_hba.conf should be your client IP > > (if > > > > this is on the same server as PGSQL, the best way is to use 127.0.0.1 > > (the > > > > system default localhost IP)). > > > > > > > > Your application appears to be trying to connect to 10.0.0.205, which > is > > > > different to the one you've just said your server is 10.0.2.56. > > > > > > > > Do an "ifconfig" on the console and find out what network adapters > there > > > are > > > > in your server, and what IPs they're bound to - then in your > > > postgresql.conf > > > > bind PostgreSQL to one of them (if you have multiple adapters) (using > > the > > > > listen_address=... option - then you can use that IP to specify as the > > > > connection IP in your application. > > > > > > > > But you need to get some consistency in the IPs your server is > listening > > > on, > > > > and your application is trying to connect to. > > > > > > > > Andy > > > > > > > > -----Original Message----- > > > > From: pgsql-admin-owner@postgresql.org > > > > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of sandhya > > > > Sent: Monday, 20 March, 2006 9:49 AM > > > > To: Robin Iddon > > > > Cc: Postgres > > > > Subject: Re: [ADMIN] reg:conninfo > > > > > > > > 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" > > > > To: "sandhya" > > > > Cc: "Postgres" > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ---------------------------(end of > broadcast)--------------------------- > > > > TIP 2: Don't 'kill -9' the postmaster > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > !DSPAM:14,441e8eac49411083715129! > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >