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 EF3AC9FA61D for ; Fri, 9 Jun 2006 10:43:44 -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 37286-06 for ; Fri, 9 Jun 2006 10:43:38 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.197]) by postgresql.org (Postfix) with ESMTP id 247659FA621 for ; Fri, 9 Jun 2006 10:43:37 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id h30so507480wxd for ; Fri, 09 Jun 2006 06:43:36 -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:references; b=ds9hYQTMzXZC3QgkCLcl0fEWjUInmaVw1Jng2VfhByMI9N8IiUeW2Os8kuizuBzUavQzNz3Lb3jFdKYBwhnkUlAyRDr5k43Vr9kjaKd6uPC7o5rFS3QCuAjgKoXu6z/rxJNTntAq0FwblBrXv0S6e6bFrHQoXsYiS7MOti/suUQ= Received: by 10.70.14.5 with SMTP id 5mr621916wxn; Fri, 09 Jun 2006 06:43:36 -0700 (PDT) Received: by 10.70.75.9 with HTTP; Fri, 9 Jun 2006 06:43:36 -0700 (PDT) Message-ID: <1d219a6f0606090643h25ec6f8fqe61998eea3143684@mail.gmail.com> Date: Fri, 9 Jun 2006 09:43:36 -0400 From: "Chris Hoover" To: "Mohamed Fazil" Subject: Re: Database port changing issue Cc: "pg-admin postgre" , magnus In-Reply-To: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_32446_12521897.1149860616256" References: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/67 X-Sequence-Number: 22029 ------=_Part_32446_12521897.1149860616256 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline sounds like you might have a firewall blocking the new port. Make sure you can connect locally the the database, and then get a hole poked in your iptables firewall (assuming this is a linux server) HTH, Chris 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 > ------=_Part_32446_12521897.1149860616256 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
sounds like you might have a firewall blocking the new port.  Make sure you can connect locally the the database, and then get a hole poked in your iptables firewall (assuming this is a linux server)

HTH,

Chris


On 6/9/06, Mohamed Fazil <mohdfazil_p_a@yahoo.com> 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


------=_Part_32446_12521897.1149860616256--