Обсуждение: Re: pg_hba.conf issue
Hi friends, I herewith paste my pg_hba.conf file for your reference. This is in 172.16.84.76 system(Server box) Type Database User IP-Address Method host all all 127.0.0.1/32 md5 host all all 172.16.84.239/32 trust host all all 172.16.84.240/32 md5 host all all 172.16.84.76/32 md5 host all all 172.26.2.20/32 md5 host all all 172.16.82.243/32 md5 Thanks & Regards Jayakumar M -----Original Message----- From: Vishal Arora [mailto:aroravishal22@hotmail.com] Sent: Tuesday, July 03, 2007 12:25 PM To: Jayakumar_Mukundaraju Subject: Re: [ADMIN] pg_hba.conf issue Can you send me your pg_hba.conf file? >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> >To: "Vishal Arora" <aroravishal22@hotmail.com>, ><pgsql-admin@postgresql.org> >Subject: Re: [ADMIN] pg_hba.conf issue >Date: Tue, 3 Jul 2007 10:29:19 +0530 > >Hi friends, > >Yes,In 172.16.84.76 system in pg_hba.conf I added 172.16.85.243 ip >address. Kindly give me explain of IPv4 block... > >Thanks & Regards >Jayakumar M > > >-----Original Message----- >From: Vishal Arora [mailto:aroravishal22@hotmail.com] >Sent: Tuesday, July 03, 2007 9:52 AM >To: Jayakumar_Mukundaraju; pgsql-admin@postgresql.org >Subject: RE: [ADMIN] pg_hba.conf issue > > > > > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> > >To: <pgsql-admin@postgresql.org> > >Subject: [ADMIN] pg_hba.conf issue > >Date: Mon, 2 Jul 2007 19:21:36 +0530 > > > >Hi friends, > > > >I am Jayakumar and new to PostgreSQL world. I am using PostgreSQL >8.1.3 > >in Windows 2000 machine. > > > >My problem is, I am unable to connect to PostgreSQL server from another > >machine's psql client. > > > >My system IP is 172.16.84.76, and client machine IP is 172.16.85.243. > > > >I can connect to the PostgreSQL server with " psql -Uroot > >-h172.16.84.76" > >from same system(172.16.84.76) > > > >If I give the above command from 172.16.85.243, results > > > >D:\\Program Files\PostgreSQL\8.1\bin>psql -Uroot - h172.16.84.76 > >psql: could not connect to server: Connection refused >(0x0000274D/10061) > > Is the server running on host "172.16.84.76" and accepting > > TCP/IP connections on port 5432? > > > >I don't know how to do this in windows. > > > > > >here pg_hba.conf entries follows > >************************************* > >host all all 172.16.84.76/32 md5 > >host all all 172.16.85.243/32 md5 > > > >Is this pg_hba.conf file is located at (172.16.84.76)? Further are these > >entries made in IPv4 block? > > > >here postgre.conf entry follows > >*********************************** > >#---------------------------------------------------------------------- >- > >---- > ># CONNECTIONS AND AUTHENTICATION > >#---------------------------------------------------------------------- >- > >---- > > > ># - Connection Settings - > > > >listen_addresses = '*' # what IP address(es) to listen on; > > # comma-separated list of addresses; > > # defaults to 'localhost', '*' = all > >port = 5432 > >max_connections = 100 > ># note: increasing max_connections costs ~400 bytes of shared memory >per > ># connection slot, plus lock space (see max_locks_per_transaction). >You > ># might also need to raise shared_buffers to support more connections. > > > > > >superuser_reserved_connections = 10 > > > >#unix_socket_directory = '' > >#unix_socket_group = '' > >#unix_socket_permissions = 0777 # octal > >#bonjour_name = '' # defaults to the computer name > > > ># - Security & Authentication - > > > >authentication_timeout = 150 # 1-600, in seconds > > > >#ssl = on > > > >#password_encryption = on > >#db_user_namespace = off > > > ># Kerberos > >#krb_server_keyfile = '' > >#krb_srvname = 'postgres' > >#krb_server_hostname = '' # empty string matches any keytab >entry > >#krb_caseins_users = off > > > ># - TCP Keepalives - > ># see 'man 7 tcp' for details > > > >#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; > > # 0 selects the system default > >#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; > > # 0 selects the system default > >#tcp_keepalives_count = 0 # TCP_KEEPCNT; > > # 0 selects the system default > > > >Please find my problem, give me the solution... > > > >Thanks & Regards > >Jayakumar M > > > > > > > >DISCLAIMER: > >This email (including any attachments) is intended for the sole use of >the > >intended recipient/s and may contain material that is CONFIDENTIAL AND > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or >copying or > >distribution or forwarding of any or all of the contents in this >message is > >STRICTLY PROHIBITED. If you are not the intended recipient, please >contact > >the sender by email and delete all copies; your cooperation in this >regard > >is appreciated. > > > >---------------------------(end of >broadcast)--------------------------- > >TIP 4: Have you searched our list archives? > > > > http://archives.postgresql.org > >_________________________________________________________________ >http://liveearth.msn.com > > > > >DISCLAIMER: >This email (including any attachments) is intended for the sole use of the >intended recipient/s and may contain material that is CONFIDENTIAL AND >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or >distribution or forwarding of any or all of the contents in this message is >STRICTLY PROHIBITED. If you are not the intended recipient, please contact >the sender by email and delete all copies; your cooperation in this regard >is appreciated. > >---------------------------(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://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migr ation_HM_mini_2G_0507 DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain materialthat is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distributionor forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intendedrecipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
Where is the entry for client machine with IP 172.16.85.243 ? I can see an entry for host all all 172.16.82.243/32 md5 It should be host all all 172.16.85.243/32 md5 Please check that. - Vishal >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> >To: "Vishal Arora" <aroravishal22@hotmail.com>, ><pgsql-admin@postgresql.org> >Subject: Re: [ADMIN] pg_hba.conf issue >Date: Tue, 3 Jul 2007 12:38:38 +0530 > >Hi friends, > >I herewith paste my pg_hba.conf file for your reference. This is in >172.16.84.76 system(Server box) > >Type Database User IP-Address Method > >host all all 127.0.0.1/32 md5 >host all all 172.16.84.239/32 trust >host all all 172.16.84.240/32 md5 >host all all 172.16.84.76/32 md5 >host all all 172.26.2.20/32 md5 >host all all 172.16.82.243/32 md5 > >Thanks & Regards >Jayakumar M > > >-----Original Message----- >From: Vishal Arora [mailto:aroravishal22@hotmail.com] >Sent: Tuesday, July 03, 2007 12:25 PM >To: Jayakumar_Mukundaraju >Subject: Re: [ADMIN] pg_hba.conf issue > > >Can you send me your pg_hba.conf file? > > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> > >To: "Vishal Arora" <aroravishal22@hotmail.com>, > ><pgsql-admin@postgresql.org> > >Subject: Re: [ADMIN] pg_hba.conf issue > >Date: Tue, 3 Jul 2007 10:29:19 +0530 > > > >Hi friends, > > > >Yes,In 172.16.84.76 system in pg_hba.conf I added 172.16.85.243 ip > >address. Kindly give me explain of IPv4 block... > > > >Thanks & Regards > >Jayakumar M > > > > > >-----Original Message----- > >From: Vishal Arora [mailto:aroravishal22@hotmail.com] > >Sent: Tuesday, July 03, 2007 9:52 AM > >To: Jayakumar_Mukundaraju; pgsql-admin@postgresql.org > >Subject: RE: [ADMIN] pg_hba.conf issue > > > > > > > > > > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> > > >To: <pgsql-admin@postgresql.org> > > >Subject: [ADMIN] pg_hba.conf issue > > >Date: Mon, 2 Jul 2007 19:21:36 +0530 > > > > > >Hi friends, > > > > > >I am Jayakumar and new to PostgreSQL world. I am using PostgreSQL > >8.1.3 > > >in Windows 2000 machine. > > > > > >My problem is, I am unable to connect to PostgreSQL server from >another > > >machine's psql client. > > > > > >My system IP is 172.16.84.76, and client machine IP is 172.16.85.243. > > > > > >I can connect to the PostgreSQL server with " psql -Uroot > > >-h172.16.84.76" > > >from same system(172.16.84.76) > > > > > >If I give the above command from 172.16.85.243, results > > > > > >D:\\Program Files\PostgreSQL\8.1\bin>psql -Uroot - h172.16.84.76 > > >psql: could not connect to server: Connection refused > >(0x0000274D/10061) > > > Is the server running on host "172.16.84.76" and accepting > > > TCP/IP connections on port 5432? > > > > > >I don't know how to do this in windows. > > > > > > > > >here pg_hba.conf entries follows > > >************************************* > > >host all all 172.16.84.76/32 md5 > > >host all all 172.16.85.243/32 md5 > > > > > > >Is this pg_hba.conf file is located at (172.16.84.76)? Further are >these > > > >entries made in IPv4 block? > > > > > > >here postgre.conf entry follows > > >*********************************** > > > >#---------------------------------------------------------------------- > >- > > >---- > > ># CONNECTIONS AND AUTHENTICATION > > > >#---------------------------------------------------------------------- > >- > > >---- > > > > > ># - Connection Settings - > > > > > >listen_addresses = '*' # what IP address(es) to listen on; > > > # comma-separated list of addresses; > > > # defaults to 'localhost', '*' = all > > >port = 5432 > > >max_connections = 100 > > ># note: increasing max_connections costs ~400 bytes of shared memory > >per > > ># connection slot, plus lock space (see max_locks_per_transaction). > >You > > ># might also need to raise shared_buffers to support more >connections. > > > > > > > > >superuser_reserved_connections = 10 > > > > > >#unix_socket_directory = '' > > >#unix_socket_group = '' > > >#unix_socket_permissions = 0777 # octal > > >#bonjour_name = '' # defaults to the computer name > > > > > ># - Security & Authentication - > > > > > >authentication_timeout = 150 # 1-600, in seconds > > > > > >#ssl = on > > > > > >#password_encryption = on > > >#db_user_namespace = off > > > > > ># Kerberos > > >#krb_server_keyfile = '' > > >#krb_srvname = 'postgres' > > >#krb_server_hostname = '' # empty string matches any keytab > >entry > > >#krb_caseins_users = off > > > > > ># - TCP Keepalives - > > ># see 'man 7 tcp' for details > > > > > >#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; > > > # 0 selects the system default > > >#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; > > > # 0 selects the system default > > >#tcp_keepalives_count = 0 # TCP_KEEPCNT; > > > # 0 selects the system default > > > > > >Please find my problem, give me the solution... > > > > > >Thanks & Regards > > >Jayakumar M > > > > > > > > > > > >DISCLAIMER: > > >This email (including any attachments) is intended for the sole use >of > >the > > >intended recipient/s and may contain material that is CONFIDENTIAL >AND > > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or > >copying or > > >distribution or forwarding of any or all of the contents in this > >message is > > >STRICTLY PROHIBITED. If you are not the intended recipient, please > >contact > > >the sender by email and delete all copies; your cooperation in this > >regard > > >is appreciated. > > > > > >---------------------------(end of > >broadcast)--------------------------- > > >TIP 4: Have you searched our list archives? > > > > > > http://archives.postgresql.org > > > >_________________________________________________________________ > >http://liveearth.msn.com > > > > > > > > > >DISCLAIMER: > >This email (including any attachments) is intended for the sole use of >the > >intended recipient/s and may contain material that is CONFIDENTIAL AND > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or >copying or > >distribution or forwarding of any or all of the contents in this >message is > >STRICTLY PROHIBITED. If you are not the intended recipient, please >contact > >the sender by email and delete all copies; your cooperation in this >regard > >is appreciated. > > > >---------------------------(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://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migr >ation_HM_mini_2G_0507 > > > > >DISCLAIMER: >This email (including any attachments) is intended for the sole use of the >intended recipient/s and may contain material that is CONFIDENTIAL AND >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or >distribution or forwarding of any or all of the contents in this message is >STRICTLY PROHIBITED. If you are not the intended recipient, please contact >the sender by email and delete all copies; your cooperation in this regard >is appreciated. > >---------------------------(end of broadcast)--------------------------- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match _________________________________________________________________ http://im.live.com/messenger/im/home/?source=hmtextlinkjuly07
Hi Vishal, Thanks for the guidline.. I changed in pg_hba.conf as 172.16.85.243/32... I created one superuser as postgres, I am usingthat user id only. Thanks & Regards Jayakumar M -----Original Message----- From: Vishal Arora [mailto:aroravishal22@hotmail.com] Sent: Tuesday, July 03, 2007 12:57 PM To: Jayakumar_Mukundaraju Subject: Re: [ADMIN] pg_hba.conf issue One more thing I forgot to ask do you have root as the database user in your server? - Vishal >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> >To: "Vishal Arora" <aroravishal22@hotmail.com>, ><pgsql-admin@postgresql.org> >Subject: Re: [ADMIN] pg_hba.conf issue >Date: Tue, 3 Jul 2007 12:38:38 +0530 > >Hi friends, > >I herewith paste my pg_hba.conf file for your reference. This is in >172.16.84.76 system(Server box) > >Type Database User IP-Address Method > >host all all 127.0.0.1/32 md5 >host all all 172.16.84.239/32 trust >host all all 172.16.84.240/32 md5 >host all all 172.16.84.76/32 md5 >host all all 172.26.2.20/32 md5 >host all all 172.16.82.243/32 md5 > >Thanks & Regards >Jayakumar M > > >-----Original Message----- >From: Vishal Arora [mailto:aroravishal22@hotmail.com] >Sent: Tuesday, July 03, 2007 12:25 PM >To: Jayakumar_Mukundaraju >Subject: Re: [ADMIN] pg_hba.conf issue > > >Can you send me your pg_hba.conf file? > > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> > >To: "Vishal Arora" <aroravishal22@hotmail.com>, > ><pgsql-admin@postgresql.org> > >Subject: Re: [ADMIN] pg_hba.conf issue > >Date: Tue, 3 Jul 2007 10:29:19 +0530 > > > >Hi friends, > > > >Yes,In 172.16.84.76 system in pg_hba.conf I added 172.16.85.243 ip > >address. Kindly give me explain of IPv4 block... > > > >Thanks & Regards > >Jayakumar M > > > > > >-----Original Message----- > >From: Vishal Arora [mailto:aroravishal22@hotmail.com] > >Sent: Tuesday, July 03, 2007 9:52 AM > >To: Jayakumar_Mukundaraju; pgsql-admin@postgresql.org > >Subject: RE: [ADMIN] pg_hba.conf issue > > > > > > > > > > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> > > >To: <pgsql-admin@postgresql.org> > > >Subject: [ADMIN] pg_hba.conf issue > > >Date: Mon, 2 Jul 2007 19:21:36 +0530 > > > > > >Hi friends, > > > > > >I am Jayakumar and new to PostgreSQL world. I am using PostgreSQL > >8.1.3 > > >in Windows 2000 machine. > > > > > >My problem is, I am unable to connect to PostgreSQL server from >another > > >machine's psql client. > > > > > >My system IP is 172.16.84.76, and client machine IP is 172.16.85.243. > > > > > >I can connect to the PostgreSQL server with " psql -Uroot > > >-h172.16.84.76" > > >from same system(172.16.84.76) > > > > > >If I give the above command from 172.16.85.243, results > > > > > >D:\\Program Files\PostgreSQL\8.1\bin>psql -Uroot - h172.16.84.76 > > >psql: could not connect to server: Connection refused > >(0x0000274D/10061) > > > Is the server running on host "172.16.84.76" and accepting > > > TCP/IP connections on port 5432? > > > > > >I don't know how to do this in windows. > > > > > > > > >here pg_hba.conf entries follows > > >************************************* > > >host all all 172.16.84.76/32 md5 > > >host all all 172.16.85.243/32 md5 > > > > > > >Is this pg_hba.conf file is located at (172.16.84.76)? Further are >these > > > >entries made in IPv4 block? > > > > > > >here postgre.conf entry follows > > >*********************************** > > > >#---------------------------------------------------------------------- > >- > > >---- > > ># CONNECTIONS AND AUTHENTICATION > > > >#---------------------------------------------------------------------- > >- > > >---- > > > > > ># - Connection Settings - > > > > > >listen_addresses = '*' # what IP address(es) to listen on; > > > # comma-separated list of addresses; > > > # defaults to 'localhost', '*' = all > > >port = 5432 > > >max_connections = 100 > > ># note: increasing max_connections costs ~400 bytes of shared memory > >per > > ># connection slot, plus lock space (see max_locks_per_transaction). > >You > > ># might also need to raise shared_buffers to support more >connections. > > > > > > > > >superuser_reserved_connections = 10 > > > > > >#unix_socket_directory = '' > > >#unix_socket_group = '' > > >#unix_socket_permissions = 0777 # octal > > >#bonjour_name = '' # defaults to the computer name > > > > > ># - Security & Authentication - > > > > > >authentication_timeout = 150 # 1-600, in seconds > > > > > >#ssl = on > > > > > >#password_encryption = on > > >#db_user_namespace = off > > > > > ># Kerberos > > >#krb_server_keyfile = '' > > >#krb_srvname = 'postgres' > > >#krb_server_hostname = '' # empty string matches any keytab > >entry > > >#krb_caseins_users = off > > > > > ># - TCP Keepalives - > > ># see 'man 7 tcp' for details > > > > > >#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; > > > # 0 selects the system default > > >#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; > > > # 0 selects the system default > > >#tcp_keepalives_count = 0 # TCP_KEEPCNT; > > > # 0 selects the system default > > > > > >Please find my problem, give me the solution... > > > > > >Thanks & Regards > > >Jayakumar M > > > > > > > > > > > >DISCLAIMER: > > >This email (including any attachments) is intended for the sole use >of > >the > > >intended recipient/s and may contain material that is CONFIDENTIAL >AND > > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or > >copying or > > >distribution or forwarding of any or all of the contents in this > >message is > > >STRICTLY PROHIBITED. If you are not the intended recipient, please > >contact > > >the sender by email and delete all copies; your cooperation in this > >regard > > >is appreciated. > > > > > >---------------------------(end of > >broadcast)--------------------------- > > >TIP 4: Have you searched our list archives? > > > > > > http://archives.postgresql.org > > > >_________________________________________________________________ > >http://liveearth.msn.com > > > > > > > > > >DISCLAIMER: > >This email (including any attachments) is intended for the sole use of >the > >intended recipient/s and may contain material that is CONFIDENTIAL AND > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or >copying or > >distribution or forwarding of any or all of the contents in this >message is > >STRICTLY PROHIBITED. If you are not the intended recipient, please >contact > >the sender by email and delete all copies; your cooperation in this >regard > >is appreciated. > > > >---------------------------(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://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migr >ation_HM_mini_2G_0507 > > > > >DISCLAIMER: >This email (including any attachments) is intended for the sole use of the >intended recipient/s and may contain material that is CONFIDENTIAL AND >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or >distribution or forwarding of any or all of the contents in this message is >STRICTLY PROHIBITED. If you are not the intended recipient, please contact >the sender by email and delete all copies; your cooperation in this regard >is appreciated. > >---------------------------(end of broadcast)--------------------------- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match _________________________________________________________________ Need a brain boost? Recharge with a stimulating game. Play now! http://club.live.com/home.aspx?icid=club_hotmailtextlink1 DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain materialthat is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distributionor forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intendedrecipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
Dear Vishal, Its working fine...Thanks lot... Thanks & Regards Jayakumar M -----Original Message----- From: Vishal Arora [mailto:aroravishal22@hotmail.com] Sent: Tuesday, July 03, 2007 2:12 PM To: Jayakumar_Mukundaraju Subject: Re: [ADMIN] pg_hba.conf issue Is it working now? >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> >To: "Vishal Arora" <aroravishal22@hotmail.com>, ><pgsql-admin@postgresql.org> >Subject: Re: [ADMIN] pg_hba.conf issue >Date: Tue, 3 Jul 2007 13:04:02 +0530 > >Hi Vishal, > >Thanks for the guidline.. I changed in pg_hba.conf as 172.16.85.243/32... I >created one superuser as postgres, I am using that user id only. > >Thanks & Regards >Jayakumar M > > >-----Original Message----- >From: Vishal Arora [mailto:aroravishal22@hotmail.com] >Sent: Tuesday, July 03, 2007 12:57 PM >To: Jayakumar_Mukundaraju >Subject: Re: [ADMIN] pg_hba.conf issue > >One more thing I forgot to ask do you have root as the database user in >your >server? > >- Vishal > > > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> > >To: "Vishal Arora" <aroravishal22@hotmail.com>, > ><pgsql-admin@postgresql.org> > >Subject: Re: [ADMIN] pg_hba.conf issue > >Date: Tue, 3 Jul 2007 12:38:38 +0530 > > > >Hi friends, > > > >I herewith paste my pg_hba.conf file for your reference. This is in > >172.16.84.76 system(Server box) > > > >Type Database User IP-Address Method > > > >host all all 127.0.0.1/32 md5 > >host all all 172.16.84.239/32 trust > >host all all 172.16.84.240/32 md5 > >host all all 172.16.84.76/32 md5 > >host all all 172.26.2.20/32 md5 > >host all all 172.16.82.243/32 md5 > > > >Thanks & Regards > >Jayakumar M > > > > > >-----Original Message----- > >From: Vishal Arora [mailto:aroravishal22@hotmail.com] > >Sent: Tuesday, July 03, 2007 12:25 PM > >To: Jayakumar_Mukundaraju > >Subject: Re: [ADMIN] pg_hba.conf issue > > > > > >Can you send me your pg_hba.conf file? > > > > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> > > >To: "Vishal Arora" <aroravishal22@hotmail.com>, > > ><pgsql-admin@postgresql.org> > > >Subject: Re: [ADMIN] pg_hba.conf issue > > >Date: Tue, 3 Jul 2007 10:29:19 +0530 > > > > > >Hi friends, > > > > > >Yes,In 172.16.84.76 system in pg_hba.conf I added 172.16.85.243 ip > > >address. Kindly give me explain of IPv4 block... > > > > > >Thanks & Regards > > >Jayakumar M > > > > > > > > >-----Original Message----- > > >From: Vishal Arora [mailto:aroravishal22@hotmail.com] > > >Sent: Tuesday, July 03, 2007 9:52 AM > > >To: Jayakumar_Mukundaraju; pgsql-admin@postgresql.org > > >Subject: RE: [ADMIN] pg_hba.conf issue > > > > > > > > > > > > > > > >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju@satyam.com> > > > >To: <pgsql-admin@postgresql.org> > > > >Subject: [ADMIN] pg_hba.conf issue > > > >Date: Mon, 2 Jul 2007 19:21:36 +0530 > > > > > > > >Hi friends, > > > > > > > >I am Jayakumar and new to PostgreSQL world. I am using PostgreSQL > > >8.1.3 > > > >in Windows 2000 machine. > > > > > > > >My problem is, I am unable to connect to PostgreSQL server from > >another > > > >machine's psql client. > > > > > > > >My system IP is 172.16.84.76, and client machine IP is 172.16.85.243. > > > > > > > >I can connect to the PostgreSQL server with " psql -Uroot > > > >-h172.16.84.76" > > > >from same system(172.16.84.76) > > > > > > > >If I give the above command from 172.16.85.243, results > > > > > > > >D:\\Program Files\PostgreSQL\8.1\bin>psql -Uroot - h172.16.84.76 > > > >psql: could not connect to server: Connection refused > > >(0x0000274D/10061) > > > > Is the server running on host "172.16.84.76" and accepting > > > > TCP/IP connections on port 5432? > > > > > > > >I don't know how to do this in windows. > > > > > > > > > > > >here pg_hba.conf entries follows > > > >************************************* > > > >host all all 172.16.84.76/32 md5 > > > >host all all 172.16.85.243/32 md5 > > > > > > > > > >Is this pg_hba.conf file is located at (172.16.84.76)? Further are > >these > > > > > >entries made in IPv4 block? > > > > > > > > > >here postgre.conf entry follows > > > >*********************************** > > > > > >#---------------------------------------------------------------------- > > >- > > > >---- > > > ># CONNECTIONS AND AUTHENTICATION > > > > > >#---------------------------------------------------------------------- > > >- > > > >---- > > > > > > > ># - Connection Settings - > > > > > > > >listen_addresses = '*' # what IP address(es) to listen on; > > > > # comma-separated list of addresses; > > > > # defaults to 'localhost', '*' = all > > > >port = 5432 > > > >max_connections = 100 > > > ># note: increasing max_connections costs ~400 bytes of shared memory > > >per > > > ># connection slot, plus lock space (see max_locks_per_transaction). > > >You > > > ># might also need to raise shared_buffers to support more > >connections. > > > > > > > > > > > >superuser_reserved_connections = 10 > > > > > > > >#unix_socket_directory = '' > > > >#unix_socket_group = '' > > > >#unix_socket_permissions = 0777 # octal > > > >#bonjour_name = '' # defaults to the computer name > > > > > > > ># - Security & Authentication - > > > > > > > >authentication_timeout = 150 # 1-600, in seconds > > > > > > > >#ssl = on > > > > > > > >#password_encryption = on > > > >#db_user_namespace = off > > > > > > > ># Kerberos > > > >#krb_server_keyfile = '' > > > >#krb_srvname = 'postgres' > > > >#krb_server_hostname = '' # empty string matches any keytab > > >entry > > > >#krb_caseins_users = off > > > > > > > ># - TCP Keepalives - > > > ># see 'man 7 tcp' for details > > > > > > > >#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; > > > > # 0 selects the system default > > > >#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; > > > > # 0 selects the system default > > > >#tcp_keepalives_count = 0 # TCP_KEEPCNT; > > > > # 0 selects the system default > > > > > > > >Please find my problem, give me the solution... > > > > > > > >Thanks & Regards > > > >Jayakumar M > > > > > > > > > > > > > > > >DISCLAIMER: > > > >This email (including any attachments) is intended for the sole use > >of > > >the > > > >intended recipient/s and may contain material that is CONFIDENTIAL > >AND > > > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or > > >copying or > > > >distribution or forwarding of any or all of the contents in this > > >message is > > > >STRICTLY PROHIBITED. If you are not the intended recipient, please > > >contact > > > >the sender by email and delete all copies; your cooperation in this > > >regard > > > >is appreciated. > > > > > > > >---------------------------(end of > > >broadcast)--------------------------- > > > >TIP 4: Have you searched our list archives? > > > > > > > > http://archives.postgresql.org > > > > > >_________________________________________________________________ > > >http://liveearth.msn.com > > > > > > > > > > > > > > >DISCLAIMER: > > >This email (including any attachments) is intended for the sole use of > >the > > >intended recipient/s and may contain material that is CONFIDENTIAL AND > > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or > >copying or > > >distribution or forwarding of any or all of the contents in this > >message is > > >STRICTLY PROHIBITED. If you are not the intended recipient, please > >contact > > >the sender by email and delete all copies; your cooperation in this > >regard > > >is appreciated. > > > > > >---------------------------(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://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_mig r > >ation_HM_mini_2G_0507 > > > > > > > > > >DISCLAIMER: > >This email (including any attachments) is intended for the sole use of >the > >intended recipient/s and may contain material that is CONFIDENTIAL AND > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying >or > >distribution or forwarding of any or all of the contents in this message >is > >STRICTLY PROHIBITED. If you are not the intended recipient, please >contact > >the sender by email and delete all copies; your cooperation in this >regard > >is appreciated. > > > >---------------------------(end of broadcast)--------------------------- > >TIP 9: In versions below 8.0, the planner will ignore your desire to > > choose an index scan if your joining column's datatypes do not > > match > >_________________________________________________________________ >Need a brain boost? Recharge with a stimulating game. Play now! >http://club.live.com/home.aspx?icid=club_hotmailtextlink1 > > > > >DISCLAIMER: >This email (including any attachments) is intended for the sole use of the >intended recipient/s and may contain material that is CONFIDENTIAL AND >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or >distribution or forwarding of any or all of the contents in this message is >STRICTLY PROHIBITED. If you are not the intended recipient, please contact >the sender by email and delete all copies; your cooperation in this regard >is appreciated. > >---------------------------(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://im.live.com/messenger/im/home/?source=hmtextlinkjuly07 DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain materialthat is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distributionor forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intendedrecipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.