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 1B5709FA5DD for ; Fri, 9 Jun 2006 17:13:50 -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 80778-07 for ; Fri, 9 Jun 2006 17:13:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx1.linuxlouis.net (mx1.linuxlouis.net [70.88.107.105]) by postgresql.org (Postfix) with ESMTP id 6B0CF9FA1A8 for ; Fri, 9 Jun 2006 17:13:44 -0300 (ADT) Received: from [10.0.2.58] (host4.sbnair.com [216.163.34.50]) (authenticated bits=0) by mx1.linuxlouis.net (8.13.4/8.13.4) with ESMTP id k59KEVKr010541 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 9 Jun 2006 16:14:32 -0400 Message-ID: <4489D671.1040208@linuxlouis.net> Date: Fri, 09 Jun 2006 16:13:37 -0400 From: louis gonzales User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Guido Barosio CC: Mohamed Fazil , pg-admin postgre , magnus Subject: Re: Database port changing issue References: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/85 X-Sequence-Number: 22047 I'm sorry but this is wrong, localhost IS 127.0.0.1 and IS a fundamental component of TCP/IP. UNIX Domain sockets - known to most as file descriptors - are entirely different! localhost != UNIX Domain sockets! I wish people would read up on this to stop perpetuating the misunderstanding of 'localhost' and UNIX domain sockets. From below, and from what another has already mentioned - that seems more plausible - is that with the listen_address = '*' and with IPv6 enabled, there is potentially a confliect there. 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 > > >