[asterisk-users] Database postgresql not able to start

[Roderick A. Anderson]

Alex Balashov wrote:
> 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'

Changes to postgresql.conf generally require a restart pf PostgreSQL to 
take affect.

How to do this will depend on the (Linux) distribution you're running 
and/or how you installed PostgreSQL.

And as Alex points out :

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


\\||/
Rod
-- 
> 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
> 
>