X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 279669FA7B6 for ; Wed, 26 Jul 2006 08:17:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 59118-02 for ; Wed, 26 Jul 2006 08:16:55 -0300 (ADT) X-Greylist: delayed 00:24:55.662409 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id C71FA9FB1CD for ; Wed, 26 Jul 2006 08:16:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from ldap.avg (elz106.internetdsl.tpnet.pl [83.15.159.106]) by svr4.postgresql.org (Postfix) with ESMTP id B297D5AF036 for ; Wed, 26 Jul 2006 10:51:25 +0000 (GMT) Received: from [192.168.49.1] (helo=[192.168.49.15]) by online with esmtpa (Exim 4.62) (envelope-from ) id 1G5g4l-0004A9-PE; Wed, 26 Jul 2006 11:53:11 +0200 Message-ID: <44C748A2.6040400@altvision.pl> Date: Wed, 26 Jul 2006 12:49:06 +0200 From: Marcin Giedz User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: LiveShell Cc: pgsql-admin@postgresql.org Subject: Re: TCP/IP connection on PostGre 8.0 References: <928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com> In-Reply-To: <928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com> Content-Type: multipart/mixed; boundary="------------030605080400020009070505" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.31 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, NORMAL_HTTP_TO_IP X-Spam-Level: X-Archive-Number: 200607/219 X-Sequence-Number: 22465 This is a multi-part message in MIME format. --------------030605080400020009070505 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit LiveShell napisaƂ(a): > Hi all, Hi, > Follosing is the list of RPM installed on my FC4 > postgresql-libs-8.0.8-1.FC4.1 > postgresql-server-8.0.8-1.FC4.1 > postgresql-docs-8.0.8-1.FC4.1 > postgresql-8.0.8-1.FC4.1 > postgresql-devel-8.0.8-1.FC4.1 > And following is the contnet of the > ===postgresql.conf file > #--------------------------------------------------------------------------- > # CONNECTIONS AND AUTHENTICATION > #--------------------------------------------------------------------------- > > # - Connection Settings - > > listen_addresses = 'localhost' # what IP interface(s) to listen on; > # defaults to localhost, '*' = any > listen_addresses = '*' so PG can listen on localhost as well as external interfaces > > port = 5432 > #tcpip_socket = true > max_connections = 100 > # note: increasing max_connections costs about 500 bytes of shared > # memory per connection slot, in addition to costs from shared_buffers > # and max_locks_per_transaction. > #superuser_reserved_connections = 2 > #unix_socket_directory = '' > #unix_socket_group = '' > #unix_socket_permissions = 0777 # octal > #rendezvous_name = '' # defaults to the computer name > > # - Security & Authentication - > > #authentication_timeout = 60 # 1-600, in seconds > #ssl = false > #password_encryption = true > #krb_server_keyfile = '' > #db_user_namespace = false > > =========== pg_hba.conf file > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > # "local" is for Unix domain socket connections only > local all all trust > # IPv4 local connections: > host all all 0.0.0.0 0.0.0.0 trust > # IPv6 local connections: > host all all ::1/128 trust > > But when I try to connect it using pgAdmin3 tool its giving erro : > > "Error Connectiong to the server : coldnnot connect to > server.Connection refused . Is the Sserver running on host " ip add" > and accepting TCP/IP conections on port 5432?" > > the service staus is running. > > And when i used : netstat -a . then only > > Active Internet connections (servers and established) > Proto Recv-Q Send-Q Local Address Foreign Address State > > tcp 0 0 Portal:postgres *:* LISTEN > > Active UNIX domain sockets (servers and established) > Proto RefCnt Flags Type State I-Node Path > unix 2 [ ACC ] STREAM LISTENING 10315 /tmp/.s.PGSQL.5432 > > So Can any body tell me whts the prob with this?? why I am not able to > connect it on tcp ip port??? > BR, Marcin --------------030605080400020009070505 Content-Type: text/x-vcard; charset=utf-8; name="marcin.giedz.vcf" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="marcin.giedz.vcf" YmVnaW46dmNhcmQNCmZuOk1hcmNpbiBHaWVkeg0KbjpHaWVkejtNYXJjaW4NCm9yZzpBbHRW aXNpb24gR3JvdXA7TmV0d29yayBhbmQgTmV3IFRlY2hub2xvZ2llcw0KYWRyOjs7UG9sbmEg MTE7V2Fyc3phd2E7OzAwLTYzMztQb2xza2ENCmVtYWlsO2ludGVybmV0Om1hcmNpbi5naWVk ekBhbHR2aXNpb24ucGwNCnRpdGxlOkRpcmVjdG9yDQp0ZWw7d29yazorNDggMjIgODI1IDg1 IDA4DQp1cmw6aHR0cDovL3d3dy5hbHR2aXNpb24ucGwNCnZlcnNpb246Mi4xDQplbmQ6dmNh cmQNCg0K --------------030605080400020009070505--