Re: reg:conninfo - Mailing list pgsql-admin

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" <andy.shellam@mailnetwork.co.uk>
To: "'sandhya'" <sandhyar@amiindia.co.in>
Cc: <pgsql-admin@postgresql.org>
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" <andy.shellam@mailnetwork.co.uk>
> To: "'sandhya'" <sandhyar@amiindia.co.in>
> 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" <andy.shellam@mailnetwork.co.uk>
> > To: "'sandhya'" <sandhyar@amiindia.co.in>
> > Cc: <pgsql-admin@postgresql.org>
> > 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" <andy.shellam@mailnetwork.co.uk>
> > > To: "'sandhya'" <sandhyar@amiindia.co.in>
> > > Cc: <pgsql-admin@postgresql.org>
> > > 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" <robin@edesix.com>
> > > > To: "sandhya" <sandhyar@amiindia.co.in>
> > > > Cc: "Postgres" <pgsql-admin@postgresql.org>
> > > > 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
>