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) [email protected] (w) www.noblesys.com We succeed when we exceed our customers expectations! -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tzafrir Cohen Sent: Sunday, November 15, 2009 4:09 AM To: [email protected] Subject: Re: [asterisk-users] Database postgresql not able to start On Sun, Nov 15, 2009 at 06:52:22AM +0000, [email protected] wrote: > > > i have installed database POSTGRESQL for storing call details. when i > restart database i get the error. > > [r...@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:[email protected] +972-50-7952406 mailto:[email protected] http://www.xorcom.com iax:[email protected]/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. _______________________________________________ -- 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
