From sandhyar@amiindia.co.in Mon Mar 20 08:16:21 2006 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 228559DCE39 for ; Mon, 20 Mar 2006 04:16:21 -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 02065-03 for ; Mon, 20 Mar 2006 04:16:21 -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 1BB6B9DCE26 for ; Mon, 20 Mar 2006 04:16:10 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k2K8A4BO032323 for ; Mon, 20 Mar 2006 13:40:04 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id F3E1733266C; Mon, 20 Mar 2006 13:39:53 +0530 (IST) Message-ID: <01bd01c64bf7$553bb720$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Cc: "sandhya" Subject: reg:conninfo Date: Mon, 20 Mar 2006 13:51:48 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01BA_01C64C25.6EECC730" 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:21 M:1 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.14 required=5 tests=[AWL=0.138, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.14 X-Spam-Level: X-Archive-Number: 200603/156 X-Sequence-Number: 20913 This is a multi-part message in MIME format. ------=_NextPart_000_01BA_01C64C25.6EECC730 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi, =20 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=20 And in my application when i pass host in conninfo as, host=3D10.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=3Dlocalhost..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 ------=_NextPart_000_01BA_01C64C25.6EECC730 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi,
  
   I am using postgres8.0.3 on = windows.When i am=20 compiling a small sample i am facing problem in connection=20 information.
 
I have given entry in my pg_hba.conf = file:
host          =  =20 all           &nbs= p;=20 all           &nbs= p;    =20 10.0.3.67/32          &= nbsp;      =20 md5 
 
And in my application when i pass host in conninfo=20 as,
host=3D10.0.3.67...It is = not=20 connecting..and throwing error  like,
Is server running on 10.0.0.205..etc
But when i give as,
host=3Dlocalhost..It is = running=20 fine.
After each change i am doing pg_reload.
What i need to do inorder to mention the IP in my = application=20 instead of localhost?
Please tell me.
 
Thank you,
Sandhya
 
 
 
 
------=_NextPart_000_01BA_01C64C25.6EECC730-- From robin@edesix.com Mon Mar 20 08:58:49 2006 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 3FC7A9DC953 for ; Mon, 20 Mar 2006 04:58:49 -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 08668-09 for ; Mon, 20 Mar 2006 04:58:50 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 552B59DC812 for ; Mon, 20 Mar 2006 04:58:47 -0400 (AST) Received: from ranger.systems.pipex.net (ranger.systems.pipex.net [62.241.162.32]) by svr4.postgresql.org (Postfix) with ESMTP id 747735AF8F6 for ; Mon, 20 Mar 2006 08:58:49 +0000 (GMT) Received: from flange.edesix.com (81-86-64-236.dsl.pipex.com [81.86.64.236]) by ranger.systems.pipex.net (Postfix) with ESMTP id A4C1DE00036F; Mon, 20 Mar 2006 08:58:43 +0000 (GMT) Received: from visitor4.edesix.com ([192.168.1.154]) by flange.edesix.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.50) id 1FLGDq-0006HO-M2; Mon, 20 Mar 2006 08:58:43 +0000 Message-ID: <441E6EC1.3070508@edesix.com> Date: Mon, 20 Mar 2006 08:58:41 +0000 From: Robin Iddon User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: sandhya Cc: Postgres Subject: Re: reg:conninfo References: <01bd01c64bf7$553bb720$cd00000a@sandhyar> In-Reply-To: <01bd01c64bf7$553bb720$cd00000a@sandhyar> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/157 X-Sequence-Number: 20914 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 > > > > > > From sandhyar@amiindia.co.in Mon Mar 20 09:42:23 2006 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 23F5C9DC9DF for ; Mon, 20 Mar 2006 05:42:23 -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 15865-06 for ; Mon, 20 Mar 2006 05:42:23 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 24F589DC942 for ; Mon, 20 Mar 2006 05:42:20 -0400 (AST) Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by svr4.postgresql.org (Postfix) with ESMTP id 34DB55AF94A for ; Mon, 20 Mar 2006 09:42:16 +0000 (GMT) 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 k2K9ac4X018148; Mon, 20 Mar 2006 15:06:38 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id CE66933266C; Mon, 20 Mar 2006 15:06:38 +0530 (IST) Message-ID: <01e301c64c03$73922bd0$cd00000a@sandhyar> From: "sandhya" To: "Robin Iddon" Cc: "Postgres" References: <01bd01c64bf7$553bb720$cd00000a@sandhyar> <441E6EC1.3070508@edesix.com> Subject: Re: reg:conninfo Date: Mon, 20 Mar 2006 15:18:33 +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:21 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/158 X-Sequence-Number: 20915 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 > > > > > > > > > > > > > From andy.shellam@mailnetwork.co.uk Mon Mar 20 09:52:59 2006 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 BE1069DCC14 for ; Mon, 20 Mar 2006 05:52:59 -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 18887-10 for ; Mon, 20 Mar 2006 05:53:01 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id A732B9DC9DF for ; Mon, 20 Mar 2006 05:52:56 -0400 (AST) Received: from [213.146.143.243] (port=37217 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FLH47-00082r-79; Mon, 20 Mar 2006 09:52:43 +0000 Reply-To: From: "Andy Shellam" To: "'sandhya'" Cc: Subject: Re: reg:conninfo Date: Mon, 20 Mar 2006 09:52:48 -0000 Organization: the mail network Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcZMAq4H8/4IsnARSN2xdl9yehjHjwAAKmQg In-Reply-To: <01e301c64c03$73922bd0$cd00000a@sandhyar> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.201 required=5 tests=[AWL=0.201] X-Spam-Score: 0.201 X-Spam-Level: X-Archive-Number: 200603/159 X-Sequence-Number: 20916 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,441e792649411059313318! From andy.shellam@mailnetwork.co.uk Mon Mar 20 10:18:22 2006 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 A8CAC9DCA12 for ; Mon, 20 Mar 2006 06:18:22 -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 28032-06 for ; Mon, 20 Mar 2006 06:18:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 55FFF9DC9D2 for ; Mon, 20 Mar 2006 06:18:20 -0400 (AST) Received: from [213.146.143.243] (port=46134 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FLHSw-00085M-L0; Mon, 20 Mar 2006 10:18:22 +0000 Reply-To: From: "Andy Shellam" To: "'sandhya'" Cc: Subject: Re: reg:conninfo Date: Mon, 20 Mar 2006 10:18:27 -0000 Organization: the mail network Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcZMBfqgNCN4sBI7TdOnv/ET6GHxLAAAWISA In-Reply-To: <020801c64c06$d0754960$cd00000a@sandhyar> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.195 required=5 tests=[AWL=0.195] X-Spam-Score: 0.195 X-Spam-Level: X-Archive-Number: 200603/160 X-Sequence-Number: 20917 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,441e7eaf49417887321075! From andy.shellam@mailnetwork.co.uk Mon Mar 20 10:29:49 2006 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 630B99DC84A for ; Mon, 20 Mar 2006 06:29:49 -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 44449-01 for ; Mon, 20 Mar 2006 06:29:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 3FC239DC812 for ; Mon, 20 Mar 2006 06:29:47 -0400 (AST) Received: from [213.146.143.243] (port=50193 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FLHe1-00086t-GE for pgsql-admin@postgresql.org; Mon, 20 Mar 2006 10:29:49 +0000 Reply-To: From: "Andy Shellam" To: Subject: FW: reg:conninfo Date: Mon, 20 Mar 2006 10:29:54 -0000 Organization: the mail network Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcZMCGqvf51KMsmMT8+gDs0mzBNf4gAAEMGgAAAgbsA= X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.19 required=5 tests=[AWL=0.190] X-Spam-Score: 0.19 X-Spam-Level: X-Archive-Number: 200603/162 X-Sequence-Number: 20919 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 From sandhyar@amiindia.co.in Mon Mar 20 10:23:45 2006 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 06D5B9DCD5F for ; Mon, 20 Mar 2006 06:23:45 -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 28503-05 for ; Mon, 20 Mar 2006 06:23:45 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 765D19DCCAF for ; Mon, 20 Mar 2006 06:23:41 -0400 (AST) Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by svr4.postgresql.org (Postfix) with ESMTP id B6B545AF8E9 for ; Mon, 20 Mar 2006 10:23:43 +0000 (GMT) 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 k2KAI2Yk026856; Mon, 20 Mar 2006 15:48:02 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 0B08B33266C; Mon, 20 Mar 2006 15:48:02 +0530 (IST) Message-ID: <023301c64c09$3baa9710$cd00000a@sandhyar> From: "sandhya" To: Cc: References: Subject: Re: reg:conninfo Date: Mon, 20 Mar 2006 15:59:56 +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/161 X-Sequence-Number: 20918 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,441e7eaf49417887321075! > From robin@edesix.com Mon Mar 20 10:31:52 2006 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 A560D9DCC14 for ; Mon, 20 Mar 2006 06:31:52 -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 45031-02 for ; Mon, 20 Mar 2006 06:31:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from blaster.systems.pipex.net (blaster.systems.pipex.net [62.241.163.7]) by postgresql.org (Postfix) with ESMTP id 667639DCC2E for ; Mon, 20 Mar 2006 06:31:50 -0400 (AST) Received: from flange.edesix.com (81-86-64-236.dsl.pipex.com [81.86.64.236]) by blaster.systems.pipex.net (Postfix) with ESMTP id EC201E000099 for ; Mon, 20 Mar 2006 10:31:51 +0000 (GMT) Received: from visitor4.edesix.com ([192.168.1.154]) by flange.edesix.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.50) id 1FLHfy-0004Lb-OU for pgsql-admin@postgresql.org; Mon, 20 Mar 2006 10:31:50 +0000 Message-ID: <441E8498.1050902@edesix.com> Date: Mon, 20 Mar 2006 10:31:52 +0000 From: Robin Iddon User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: Postgres Subject: Re: reg:conninfo References: <01bd01c64bf7$553bb720$cd00000a@sandhyar> <441E6EC1.3070508@edesix.com> <01e301c64c03$73922bd0$cd00000a@sandhyar> In-Reply-To: <01e301c64c03$73922bd0$cd00000a@sandhyar> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.214 required=5 tests=[AWL=0.025, MISSING_HEADERS=0.189] X-Spam-Score: 0.214 X-Spam-Level: X-Archive-Number: 200603/163 X-Sequence-Number: 20920 Sandhya, If you use localhost you will be creating a UNIX domain socket. If you use the IP address you will create a TCP/IP socket. Did you try running with -i yet? It doesn't mean accept remote connections, it means accept TCP/IP connection. Without it, you cannot connect to an IP address ... Robin sandhya wrote: >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 > > > > From andy.shellam@mailnetwork.co.uk Mon Mar 20 10:35:00 2006 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 0F0219DCE40 for ; Mon, 20 Mar 2006 06:35:00 -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 43634-06 for ; Mon, 20 Mar 2006 06:35:01 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 96B399DCE42 for ; Mon, 20 Mar 2006 06:34:57 -0400 (AST) Received: from [213.146.143.243] (port=52249 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FLHj1-00087g-AQ; Mon, 20 Mar 2006 10:34:59 +0000 Reply-To: From: "Andy Shellam" To: "'Robin Iddon'" Cc: Subject: Re: reg:conninfo Date: Mon, 20 Mar 2006 10:35:04 -0000 Organization: the mail network Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcZMCZtE223VlHI1TCaiK1Ru0gDwRAAADn3A In-Reply-To: <441E8498.1050902@edesix.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.185 required=5 tests=[AWL=0.185] X-Spam-Score: 0.185 X-Spam-Level: X-Archive-Number: 200603/164 X-Sequence-Number: 20921 Robin, I believe this is on a Windows machine (judging by the screenshot I was sent of the error message.) I think it's that PGSQL is set to only listen on the localhost IP. Andy -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Robin Iddon Sent: Monday, 20 March, 2006 10:32 AM Cc: Postgres Subject: Re: [ADMIN] reg:conninfo Sandhya, If you use localhost you will be creating a UNIX domain socket. If you use the IP address you will create a TCP/IP socket. Did you try running with -i yet? It doesn't mean accept remote connections, it means accept TCP/IP connection. Without it, you cannot connect to an IP address ... Robin sandhya wrote: >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 > > > > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend !DSPAM:14,441e84c449416144812637! From andy.shellam@mailnetwork.co.uk Mon Mar 20 11:23:35 2006 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 D93959DC870 for ; Mon, 20 Mar 2006 07:23:35 -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 51234-10 for ; Mon, 20 Mar 2006 07:23:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 0B5139DC812 for ; Mon, 20 Mar 2006 07:23:32 -0400 (AST) Received: from [213.146.143.243] (port=7943 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FLIU3-00089l-PM; Mon, 20 Mar 2006 11:23:35 +0000 Reply-To: From: "Andy Shellam" To: "'sandhya'" Cc: Subject: Re: reg:conninfo Date: Mon, 20 Mar 2006 11:23:28 -0000 Organization: the mail network Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcZMD4I+jkiawwL7RiKgG5sMLJVi5QAAPFKw In-Reply-To: <024a01c64c10$5c60e700$cd00000a@sandhyar> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.181 required=5 tests=[AWL=0.181] X-Spam-Score: 0.181 X-Spam-Level: X-Archive-Number: 200603/165 X-Sequence-Number: 20922 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! From sandhyar@amiindia.co.in Mon Mar 20 12:09:28 2006 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 > From louis.gonzales@linuxlouis.net Mon Mar 20 12:29:49 2006 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 0501B9DC852 for ; Mon, 20 Mar 2006 08:29:49 -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 66915-05 for ; Mon, 20 Mar 2006 08:29:52 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 1B73A9DD06A for ; Mon, 20 Mar 2006 08:29:48 -0400 (AST) Received: from svcstatl08.hotspot.t-mobile.com (m70195e42.tmodns.net [66.94.25.112]) by svr4.postgresql.org (Postfix) with ESMTP id 22CC75AF091 for ; Mon, 20 Mar 2006 12:29:51 +0000 (GMT) Received: from [10.223.217.228] (228.217.223.10.in-addr.arpa [10.223.217.228]) by svcstatl08.hotspot.t-mobile.com (8.12.10+Sun/8.12.10) with ESMTP id k2KCTjsN024277; Mon, 20 Mar 2006 07:29:46 -0500 (EST) Message-ID: <441EA039.70106@linuxlouis.net> Date: Mon, 20 Mar 2006 07:29:45 -0500 From: Louis Gonzales User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Robin Iddon Cc: Postgres Subject: Re: reg:conninfo References: <01bd01c64bf7$553bb720$cd00000a@sandhyar> <441E6EC1.3070508@edesix.com> <01e301c64c03$73922bd0$cd00000a@sandhyar> <441E8498.1050902@edesix.com> In-Reply-To: <441E8498.1050902@edesix.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 mlx=0 adultscore=0 adjust=0 reason=mlx engine=3.1.0-06031500 definitions=3.0.0-06032000 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200603/168 X-Sequence-Number: 20925 I'm sorry, please don't confuse a UNIX domain socket with "localhost" which are _not_ the same at all. A UNIX domain socket is nothing more than a file *usually* located in a temporary directory, used for inter-process communication. "localhost" - 127.0.0.1, also used on any TCP/IP configured system, including Windows, which does not support UNIX domain sockets, by default - _is_ a special network address, the loopback device and is used generally to ensure proper functionality of the TCP/IP stack. Robin Iddon wrote: > Sandhya, > > > If you use localhost you will be creating a UNIX domain socket. If > you use the IP address you will create a TCP/IP socket. > > Did you try running with -i yet? It doesn't mean accept remote > connections, it means accept TCP/IP connection. Without it, you > cannot connect to an IP address ... > > Robin > > sandhya wrote: > From sandhyar@amiindia.co.in Mon Mar 20 12:27:58 2006 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 E645A9DCE38 for ; Mon, 20 Mar 2006 08:27:58 -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 65802-09 for ; Mon, 20 Mar 2006 08:28:01 -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 0948B9DCE40 for ; Mon, 20 Mar 2006 08:27:49 -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 k2KCLhcR020038; Mon, 20 Mar 2006 17:51:43 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 3F03033266C; Mon, 20 Mar 2006 17:51:43 +0530 (IST) Message-ID: <027201c64c1a$83052150$cd00000a@sandhyar> From: "sandhya" To: Cc: References: Subject: Re: reg:conninfo Date: Mon, 20 Mar 2006 18:03:37 +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.138 required=5 tests=[AWL=0.137, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.138 X-Spam-Level: X-Archive-Number: 200603/167 X-Sequence-Number: 20924 Hi Andy, Now it is working fine.After mentioning listen_address = '*' ..I have restarted the postgres server. Then it is working fine. Thanks for your help..... -Sandhya ----- 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 > From skn@gsecone.com Mon Mar 20 12:44:54 2006 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 47D869DCC2E for ; Mon, 20 Mar 2006 08:44:54 -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 68771-07 for ; Mon, 20 Mar 2006 08:44:56 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 545229DC9CE for ; Mon, 20 Mar 2006 08:44:51 -0400 (AST) Received: from gsecone.com (gsecone.com [59.144.0.4]) by svr4.postgresql.org (Postfix) with ESMTP id C87DE5AF05F for ; Mon, 20 Mar 2006 12:44:54 +0000 (GMT) Received: from [127.0.0.1] ([192.168.2.1]) by gsecone.com (8.12.8/8.12.8) with ESMTP id k2KCF4vE002727; Mon, 20 Mar 2006 17:45:04 +0530 Message-ID: <441EA3A2.4020402@gsecone.com> Date: Mon, 20 Mar 2006 18:14:18 +0530 From: "Kannan.S" User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: sandhya Cc: Louis Gonzales , Robin Iddon , Postgres Subject: Re: reg:conninfo References: <01bd01c64bf7$553bb720$cd00000a@sandhyar> <441E6EC1.3070508@edesix.com> <01e301c64c03$73922bd0$cd00000a@sandhyar> <441E8498.1050902@edesix.com> <441EA039.70106@linuxlouis.net> <02e001c64c1c$713c4b90$cd00000a@sandhyar> In-Reply-To: <02e001c64c1c$713c4b90$cd00000a@sandhyar> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200603/170 X-Sequence-Number: 20927 http://en.wikipedia.org/wiki/Loopback sandhya wrote: > localhost 127.0.0.1------->What is the importance of it? > Is there any document to know about this? > > ----- Original Message ----- > From: "Louis Gonzales" > To: "Robin Iddon" > Cc: "Postgres" > Sent: Monday, March 20, 2006 5:59 PM > Subject: Re: [ADMIN] reg:conninfo > > > >> I'm sorry, please don't confuse a UNIX domain socket with "localhost" >> which are _not_ the same at all. A UNIX domain socket is nothing more >> than a file *usually* located in a temporary directory, used for >> inter-process communication. "localhost" - 127.0.0.1, also used on any >> TCP/IP configured system, including Windows, which does not support UNIX >> domain sockets, by default - _is_ a special network address, the >> loopback device and is used generally to ensure proper functionality of >> the TCP/IP stack. >> >> Robin Iddon wrote: >> >> >>> Sandhya, >>> >>> >>> If you use localhost you will be creating a UNIX domain socket. If >>> you use the IP address you will create a TCP/IP socket. >>> >>> Did you try running with -i yet? It doesn't mean accept remote >>> connections, it means accept TCP/IP connection. Without it, you >>> cannot connect to an IP address ... >>> >>> Robin >>> >>> sandhya wrote: >>> >>> >> ---------------------------(end of broadcast)--------------------------- >> TIP 1: if posting/reading through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org so that your >> message can get through to the mailing list cleanly >> >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > > From sandhyar@amiindia.co.in Mon Mar 20 12:41:39 2006 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 410AB9DC84A for ; Mon, 20 Mar 2006 08:41:39 -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 67752-09 for ; Mon, 20 Mar 2006 08:41:42 -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 87B9A9DC812 for ; Mon, 20 Mar 2006 08:41:36 -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 k2KCZVHg022921; Mon, 20 Mar 2006 18:05:31 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 8292D33266C; Mon, 20 Mar 2006 18:05:31 +0530 (IST) Message-ID: <02e001c64c1c$713c4b90$cd00000a@sandhyar> From: "sandhya" To: "Louis Gonzales" , "Robin Iddon" Cc: "Postgres" References: <01bd01c64bf7$553bb720$cd00000a@sandhyar> <441E6EC1.3070508@edesix.com> <01e301c64c03$73922bd0$cd00000a@sandhyar> <441E8498.1050902@edesix.com> <441EA039.70106@linuxlouis.net> Subject: Re: reg:conninfo Date: Mon, 20 Mar 2006 18:17:26 +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:16 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.138 required=5 tests=[AWL=0.137, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.138 X-Spam-Level: X-Archive-Number: 200603/169 X-Sequence-Number: 20926 localhost 127.0.0.1------->What is the importance of it? Is there any document to know about this? ----- Original Message ----- From: "Louis Gonzales" To: "Robin Iddon" Cc: "Postgres" Sent: Monday, March 20, 2006 5:59 PM Subject: Re: [ADMIN] reg:conninfo > I'm sorry, please don't confuse a UNIX domain socket with "localhost" > which are _not_ the same at all. A UNIX domain socket is nothing more > than a file *usually* located in a temporary directory, used for > inter-process communication. "localhost" - 127.0.0.1, also used on any > TCP/IP configured system, including Windows, which does not support UNIX > domain sockets, by default - _is_ a special network address, the > loopback device and is used generally to ensure proper functionality of > the TCP/IP stack. > > Robin Iddon wrote: > > > Sandhya, > > > > > > If you use localhost you will be creating a UNIX domain socket. If > > you use the IP address you will create a TCP/IP socket. > > > > Did you try running with -i yet? It doesn't mean accept remote > > connections, it means accept TCP/IP connection. Without it, you > > cannot connect to an IP address ... > > > > Robin > > > > sandhya wrote: > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >