From: Chris Hoover <revoohc@gmail.com>
To: Mohamed Fazil <mohdfazil_p_a@yahoo.com>
Cc: pg-admin postgre <pgsql-admin@postgresql.org>
Cc: magnus <mha@sollentuna.net>
Subject: Re: Database port changing issue
Date: Fri, 9 Jun 2006 09:43:36 -0400
Message-ID: <1d219a6f0606090643h25ec6f8fqe61998eea3143684@mail.gmail.com> (raw)
In-Reply-To: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com>
References: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com>
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
>
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: revoohc@gmail.com, mohdfazil_p_a@yahoo.com, mha@sollentuna.net
Subject: Re: Database port changing issue
In-Reply-To: <1d219a6f0606090643h25ec6f8fqe61998eea3143684@mail.gmail.com>
References: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com> <1d219a6f0606090643h25ec6f8fqe61998eea3143684@mail.gmail.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