Re: jdbc pg_hba.conf error

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

Bhavana.Rakesh escribió:
> Hi,
> Here's what happens when I specify the port number
> 
> [brakesh(at)lnx383 ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
> psql: could not connect to server: Connection refused
>        Is the server running on host "127.0.0.1" and accepting
>        TCP/IP connections on port 5000?

This one is not listening on port 5000 -- it's the default 5432, unless
you have the port set elsewhere on the .conf file.

> #---------------------------------------------------------------------------
> # CONNECTIONS AND AUTHENTICATION
> #---------------------------------------------------------------------------
> 
> # - Connection Settings -
> 
> listen_addresses = '*'          # what IP address(es) to listen on;
>                                # comma-separated list of addresses;
>                                # defaults to 'localhost', '*' = all
>                                # (change requires restart)
> #port = 5432                            # (change requires restart)
> max_connections = 100                   # (change requires restart)


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support