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 05F889FA61D for ; Fri, 9 Jun 2006 10:40:26 -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 39571-01 for ; Fri, 9 Jun 2006 10:40:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.183]) by postgresql.org (Postfix) with ESMTP id 4C0CA9FA621 for ; Fri, 9 Jun 2006 10:40:15 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id c30so823043pyc for ; Fri, 09 Jun 2006 06:40:13 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=hPvH5GgPv0qXL1BieRh4Un+FoYa3B/Z9lHHxoPzYXRlcWKWF4w+9MOWSqq9DxyhYkbs63Ovn6wiESdLY9flFdkotzoHZwB3BED136fx3QD6p9jGqaTAmRFpHugDGaK8zlpj/XD7efyx5RRcRUdAUsg3OdYESa/p7+H14AcoCzU4= Received: by 10.35.134.12 with SMTP id l12mr4089672pyn; Fri, 09 Jun 2006 06:40:13 -0700 (PDT) Received: by 10.35.22.20 with HTTP; Fri, 9 Jun 2006 06:40:13 -0700 (PDT) Message-ID: Date: Fri, 9 Jun 2006 14:40:13 +0100 From: "Guido Barosio" To: "Mohamed Fazil" Subject: Re: Database port changing issue Cc: "pg-admin postgre" , magnus In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/66 X-Sequence-Number: 22028 s/that your will listen /your server will listen/ eof :x On 6/9/06, Guido Barosio wrote: > That's because your listen_addresses parameter points to localhost, > and that means that your will listen for connections through unix > sockets instead of via TCP/IP. > > In order to change this, you'll need to replace the string localhost > with the proper value. (A bad habit, to replace the 'localhost' with a > '*'). > > Read the man page :) > > # - Connection Settings - > listen_addresses = 'localhost' # what IP address(es) to listen on; > > # Would be something like: > listen_addresses = '*' > > Best wishes, > Guido > > > > > > > > On 6/9/06, Mohamed Fazil wrote: > > > > Hi to all, > > > > I am facing an issue while changing database port in the new version 8.1. > > The previous version which i used was 7.3 and for the port change i used to > > change in postgresql.conf > > > > From PG 7.3 > > #--------------------------------------------------------------------------- > > # CONNECTIONS AND AUTHENTICATION > > #--------------------------------------------------------------------------- > > # - Connection Settings - > > #tcpip_socket = false > > #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 > > port = 5432 > > #unix_socket_directory = '' > > #unix_socket_group = '' > > #unix_socket_permissions = 0777 # octal > > #virtual_host = '' # what interface to listen on; defaults to any > > #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 > > > > > > Now for the port change in the newer version i tried to change the same as > > shown below in postgresql.conf. > > > > From PG 8.1 > > #--------------------------------------------------------------------------- > > # CONNECTIONS AND AUTHENTICATION > > #--------------------------------------------------------------------------- > > # - Connection Settings - > > listen_addresses = 'localhost' # what IP address(es) to listen on; > > # comma-separated list of addresses; > > # defaults to 'localhost', '*' = all > > port = 5478 > > 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 = 2 > > #unix_socket_directory = '' > > #unix_socket_group = '' > > #unix_socket_permissions = 0777 # octal > > #bonjour_name = '' # defaults to the computer name > > # - Security & Authentication - > > #authentication_timeout = 60 # 1-600, in seconds > > #ssl = off > > #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 > > > > But i am getting an error as mentioned below > > > > org.postgresql.util.PSQLException: Connection refused. > > Check that the hostname and port are correct and that the postmaster is > > accepting TCP/IP connections. > > > > What are the changes that i have to do for changing port. > > > > If i am replacing it to 5432, it is working fine. > > > > I had a great support and help from this mailing team and i expect the same. > > > > Thanks to all in advance. > > > > Regards > > > > Mohamed Fazil > > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > > -- > Guido Barosio > ----------------------- > http://www.globant.com > guido.barosio@globant.com > -- Guido Barosio ----------------------- http://www.globant.com guido.barosio@globant.com