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 78F8C9FA621 for ; Fri, 9 Jun 2006 10:30:58 -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 31466-06 for ; Fri, 9 Jun 2006 10:30:52 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31010.mail.mud.yahoo.com (web31010.mail.mud.yahoo.com [68.142.200.173]) by postgresql.org (Postfix) with SMTP id DFDB49FA61D for ; Fri, 9 Jun 2006 10:30:52 -0300 (ADT) Received: (qmail 51981 invoked by uid 60001); 9 Jun 2006 13:30:51 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=zkQl1kWwjIzjKs4As6/BmnBhiVzn2dw5ZosZfVhDU7eldRO0XaV/40VeiVNntaLcGcIYxRvBB2t52+49a00Mvag4+uCfZm97nMsYOn0vICJ/UOIpt+01IenpGZPhm8R+MYeYWeonsqBPjR61+UiYSsOCK+vjPeP0cGlPdDmOKeY= ; Message-ID: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com> Received: from [220.227.114.194] by web31010.mail.mud.yahoo.com via HTTP; Fri, 09 Jun 2006 06:30:51 PDT Date: Fri, 9 Jun 2006 06:30:51 -0700 (PDT) From: Mohamed Fazil Subject: Database port changing issue To: pg-admin postgre , magnus MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2126614750-1149859851=:48316" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/63 X-Sequence-Number: 22025 --0-2126614750-1149859851=:48316 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 --0-2126614750-1149859851=:48316 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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 --0-2126614750-1149859851=:48316--