PDA

View Full Version : PostgreSQL doesn´t start after reboot


bas1968
01-26-2007, 05:51 PM
After a php upgrade to 4.4.4 I have build the customapache and I have 2 problems now. The PostgreSQL doesn´t start anymore after a reboot. I need to start it with service postgresql start. How can I get this back to autostart when the server reboots? I am using CentOS.

Another problem when I try to aktualize the awstats, I get this error:

Error: Couldn't open server log file "/var/log/httpd/domains/voiptele.com.br.log" : Permission denied

Setup ('/etc/awstats/awstats.voiptele.com.br.conf' file, web server or permissions) may be wrong.
Check config file, permissions and AWStats documentation (in 'docs' directory).

freshmint
01-27-2007, 05:47 AM
After a php upgrade to 4.4.4 I have build the customapache and I have 2 problems now. The PostgreSQL doesn´t start anymore after a reboot. I need to start it with service postgresql start. How can I get this back to autostart when the server reboots? I am using CentOS.

Another problem when I try to aktualize the awstats, I get this error:

Error: Couldn't open server log file "/var/log/httpd/domains/voiptele.com.br.log" : Permission denied

Setup ('/etc/awstats/awstats.voiptele.com.br.conf' file, web server or permissions) may be wrong.
Check config file, permissions and AWStats documentation (in 'docs' directory).

chkconfig --add postgresql

Check the file permissions - make sure it's readable by the user running awstats.

bas1968
01-27-2007, 06:35 AM
chkconfig --add postgresql

Check the file permissions - make sure it's readable by the user running awstats.


chkconfig --add postgresql doesn´t work. I still need to restart PostgreSQL manual

freshmint
01-27-2007, 06:49 AM
After adding it, it may be off. What's the output for this command?

chkconfig list | grep postgresql

If you didn't get an error after adding it and the output for the above command says it's off, try this:

chkconfig postgresql on

bas1968
01-27-2007, 07:41 AM
After adding it, it may be off. What's the output for this command?

chkconfig list | grep postgresql

If you didn't get an error after adding it and the output for the above command says it's off, try this:

chkconfig postgresql on

When I type chkconfig list | grep postgresql it shown nothing. After I tried chkconfig --list postgresql it shows these results:

[root@server3 ~]# chkconfig --list postgresql
postgresql 0:off 1:off 2:on 3:on 4:on 5:on 6:off

bas1968
01-27-2007, 07:43 AM
After adding it, it may be off. What's the output for this command?

chkconfig list | grep postgresql

If you didn't get an error after adding it and the output for the above command says it's off, try this:

chkconfig postgresql on

It was showing smilies, I copied the result again:

[root@server3 ~]# chkconfig --list postgresql
postgresql 0:off 1:off 2:on 3:on 4:on 5:on 6:off

freshmint
01-27-2007, 08:10 AM
It was showing smilies, I copied the result again:

[root@server3 ~]# chkconfig --list postgresql
postgresql 0:off 1:off 2:on 3:on 4:on 5:on 6:off

In that case you might try:

chkconfig --level 016 postgresql on

bas1968
01-27-2007, 02:19 PM
In that case you might try:

Thanks!! It solved my problem