[asterisk-users] Database postgresql not able to start

[Tzafrir Cohen]

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