pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mohamed Fazil <mohdfazil_p_a@yahoo.com>
To: pg-admin postgre <pgsql-admin@postgresql.org>
To: magnus <mha@sollentuna.net>
Subject: Database port changing issue
Date: Fri, 9 Jun 2006 06:30:51 -0700 (PDT)
Message-ID: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com> (raw)

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 

view thread (8+ messages)  latest in thread

Message-ID: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com>
Permalink:  ../20060609133051.51979.qmail@web31010.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20060609133051.51979.qmail@web31010.mail.mud.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mohdfazil_p_a@yahoo.com, mha@sollentuna.net
  Subject: Re: Database port changing issue
  In-Reply-To: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com>
  References: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox