asterisk users - Nov 2009 - Database postgresql not able to start

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20091115/93d34954/attachment.htm

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

On Sun, Nov 15, 2009 at 06:52:22AM +0000, 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? 
I'm not sure about other systems. On my systems working as root is not
the simple way to work with database. Try 'su - postgres' and connect as
that user. It should work as a PostgreSQL admin user.
> 
>  THIS IS MY
> /VAR/LIB/PGSQL/DATA/POSTGRESQL.CONF 
> 
> # CONNECTIONS AND
> AUTHENTICATION
Small hint: Text in ALL CAPS is generally considered as shouting. Please
try to avoid that if you don't really need it.

-- 
               Tzafrir Cohen
icq#16849755              jabber:tzafrir.cohen at xorcom.com
+972-50-7952406           mailto:tzafrir.cohen at xorcom.com
http://www.xorcom.com  iax:guest at local.xorcom.com/tzafrir

asterisk at opensourcesolution.in wrote:
> *this is my /var/lib/pgsql/data/postgresql.conf*
Tzafrir,

In my client, it didn't show in all upper case (SeaMonkey)

Doug



-- 
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."