[asterisk-users] Database postgresql not able to start

[James Texter]

I found that on a clean boot, I could not connect to Postgresql either.
In my /etc/rc.local, I unload cdr_pgsql.so, sleep 15, then reload the
module, and that seems to work.  After bootup, cdr_pgsql.so is able to
connect immediately.

 --
James Texter III
Sr. Software Engineer
NOBLE SYSTEMS 
4151 Ashford Dunwoody Road, Suite 600  | Atlanta, GA 30319-1452
(o) 404.851.1331 ext. 357
(f)  404.851.1421
(e) jtexter3 at noblesys.com
(w) www.noblesys.com

We succeed when we exceed our customer’s expectations!

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Tzafrir
Cohen
Sent: Sunday, November 15, 2009 4:09 AM
To: asterisk-users at lists.digium.com
Subject: Re: [asterisk-users] Database postgresql not able to start

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

_______________________________________________
-- 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


CONFIDENTIAL NOTICE : If you have received this email in error, 
please immediately notify the sender by email at the address 
shown above. This email may contain confidential or legally 
privileged information that is intended only for the use of the 
individual or entity named in this email. If you are not the 
intended recipient, you are hereby notified that any 
disclosure, copying, distribution or reliance upon the contents 
of this email is strictly prohibited. Please delete from your 
files if you are not the intended recipient. Thank you for your 
compliance.