Re: pg_hba.conf issue - Mailing list pgsql-admin

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