Signiant Support

After a Reboot of a Linux Manager, the Database Will Not Start Print


Problem:   

 After a reboot of the Manager the postgres database fails to start.  How can I see what the issue is?

Resolution:

Start the database from the command line:

    # su - postgres
    # ./pg_ctl start -D <install_dir>db/pgsql/data


In this case the command line output reveals that the shared_buffers parameter for postgres is set to 30000 and that the SHMMAX kernel parameter is not large enough to allocate the space needed. Taking a look at the /etc/sysctl.conf files shows that the parameter is set but contains a typo:

    kernal.shmmax=294033920

Changing the parameter to kernel.shmmax and rebooting the machine corrected the issue.