Re: Database port changing issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <mohdfazil_p_a@xxxxxxxxx> 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


--
Guido Barosio
-----------------------
http://www.globant.com
guido.barosio@xxxxxxxxxxx


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux