Thread: reg:conninfo
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
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 > > > > > >
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 > > > > > > > > > > > > >
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,441e792649411059313318!
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,441e7eaf49417887321075!
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,441e7eaf49417887321075! >
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" <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 > > > >
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" <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 > > > > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend !DSPAM:14,441e84c449416144812637!
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!
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" <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 >
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 >
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: >
localhost 127.0.0.1------->What is the importance of it? Is there any document to know about this? ----- Original Message ----- From: "Louis Gonzales" <louis.gonzales@linuxlouis.net> To: "Robin Iddon" <robin@edesix.com> Cc: "Postgres" <pgsql-admin@postgresql.org> 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 >
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" <louis.gonzales@linuxlouis.net> > To: "Robin Iddon" <robin@edesix.com> > Cc: "Postgres" <pgsql-admin@postgresql.org> > 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 > > >