Signiant Support

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


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


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:


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