[asterisk-users] Database postgresql not able to start

[James Texter]

I thought that too, but I already checked.  Postgresql is priority 64,
Asterisk is priority 90.  Watching the boot sequence, I can see that
Postgresql is clearly started before Asterisk.  It may be that there is
something in my config that causes this happen, but it's reproducable on
any box I setup.

 --
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 Barry L.
Kline
Sent: Monday, November 16, 2009 8:24 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] Database postgresql not able to start

James Texter wrote:
> 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.
>

This sounds as though you have Asterisk starting before PostgreSQL.  If
you're using CentOS or RHEL or other RHEL-inspired distro look at
/etc/init.d/asterisk and /etc/init.d/postgresql.

Compare the line in each that looks like:

# chkconfig:  2345 xx yy

The 'xx' is the start priority.  If the number is lower in the asterisk
file than it is in the postgresql file then that's your problem.  You
need PG to start before Asterisk.

man chkconfig

for further details on what you can do.

Barry


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