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 3DC229FA5FB for ; Wed, 26 Jul 2006 14:45:24 -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 48434-08 for ; Wed, 26 Jul 2006 14:45:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail11.bluewin.ch (mail11.bluewin.ch [195.186.18.61]) by postgresql.org (Postfix) with ESMTP id 063F39FA418 for ; Wed, 26 Jul 2006 14:45:05 -0300 (ADT) Received: from [192.168.1.74] (62.203.181.72) by mail11.bluewin.ch (Bluewin 7.3.110.2) id 44A3D2BF006234ED for pgsql-admin@postgresql.org; Wed, 26 Jul 2006 17:45:03 +0000 From: Ivo Rossacher To: pgsql-admin@postgresql.org Subject: Re: TCP/IP connection on PostGre 8.0 Date: Wed, 26 Jul 2006 19:44:47 +0200 User-Agent: KMail/1.8.2 References: <928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com> In-Reply-To: <928fe9b50607260345g293de5fbj88851541c0b8d2ae@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200607261944.48146.rossacher@bluewin.ch> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200607/223 X-Sequence-Number: 22469 Am Mittwoch, 26. Juli 2006 12.45 schrieb LiveShell: > 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; Are you connecting from an other host? This other host might not have access to your localhost address. > # defaults to localhost, '*' = any > port = 5432 > #tcpip_socket = true Uncommenting the above might help as well as starting the server with the option -i. > 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 This are definitly not recommended values for production use. Chapter 19 of server documentation might be of interest here. > > 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???