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 6A61B9FA7B6 for ; Wed, 26 Jul 2006 07:46:33 -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 52544-09 for ; Wed, 26 Jul 2006 07:46:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id BF7649FA4E0 for ; Wed, 26 Jul 2006 07:45:59 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so583208nfc for ; Wed, 26 Jul 2006 03:45:58 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=QGRE8Xe19ydq7WbzsIl0LrilCs6MxUzelMLoMjiYtZrCm3sN+kKzTVkSq49wiXNntXICHuE9ddCih5IVcfzZ38+ugXs1tDXs+N3xXiufNbS7usVDig3NgSpNEMEPRI+lunrIqOA5++b9+ksMZ6nXYUK1rUcrdMnMk2ZDw/hy//w= Received: by 10.82.109.9 with SMTP id h9mr202944buc; Wed, 26 Jul 2006 03:45:58 -0700 (PDT) Received: by 10.82.127.10 with HTTP; Wed, 26 Jul 2006 03:45:57 -0700 (PDT) Message-ID: <928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com> Date: Wed, 26 Jul 2006 16:15:57 +0530 From: LiveShell To: pgsql-admin@postgresql.org Subject: TCP/IP connection on PostGre 8.0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_14187_23124631.1153910757994" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.509 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_50_60, HTML_MESSAGE, NORMAL_HTTP_TO_IP, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/218 X-Sequence-Number: 22464 ------=_Part_14187_23124631.1153910757994 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all, 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 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.Connectionrefused . 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??? ------=_Part_14187_23124631.1153910757994 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi all,
          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
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???

 

 

 

 

 

 

 
 
 
------=_Part_14187_23124631.1153910757994--