[asterisk-users] Database postgresql not able to start

[Alex Balashov]

It does not appear that you have PostgreSQL set up to listen on a TCP 
socket, but only UNIX domain socket.  You have this line commented out:

    #listen_addresses = 'localhost'

It is required in order to listen on TCP.  You should uncomment it:

    listen_addresses = '127.0.0.1'

In any case, this is not within the general purview of the list.

asterisk at opensourcesolution.in wrote:

> i have installed database *postgresql*  for storing call details. when i 
> restart database i get the error.
> 
> [*root at localhost server]# psql -h 127.0.0.1 -U asterisk Password
> 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 5432?*
> 
>  
> 
>  *this is my /var/lib/pgsql/data/postgresql.conf*
> 
> *# 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 = 5432
>  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*
> 
>  
> 
>  
> 
> asterisk is not able to make TCP/Ip connection. plz guide me where i am 
> doing wrong.
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users


-- 
Alex Balashov - Principal
Evariste Systems
Web     : http://www.evaristesys.com/
Tel     : (+1) (678) 954-0670
Direct  : (+1) (678) 954-0671