5.Look for the postmaster process:
#ps -ef grep postmaster
If the postmaster process failed to start, increase your kernel's shared memory size limits, as follows:
a.Review the /usr/internet/pgsql/data/postmaster.log file for an error message produced when trying to startup the postmaster. Most likely, you will see an error message similar to the following message:
IpcMemoryCreate: shmget(key=5432001,
size=28901376, 03600) failed: Invalid argument
1.The maximum size for shared memory segments on your system was exceeded. You need to raise the SHMMAX parameter in your kernel
to be at least the size number reported in the error, in this case, 28901376 bytes.
2.The requested shared memory segment was too small for your system. You need to lower the SHMMIN parameter in your kernel.
3.The requested shared memory segment already exists but is of the wrong size. This is most likely the case if an old version of PostgreSQL crashed and didn't clean up. The `ipcclean' utility can be used to remedy this.
The PostgreSQL Administrator's Guide contains more information about shared memory configuration.
b.The actual numbers reported in the error message will be different. You will need to modify the parameters in your kernel, and in the shm_max and sem_mni values, as follows:
1)Determine the appropriate shm_max value. This should be the number of bytes reported in the error message (in this example, 28901376).
2)Determine the appropriate sem_mni value. It should be greater than
max_connections / 16. (For example, if max_connections is set to 512, then sem_mni will need to be greater than 32. Set it to 33 or higher.)
3)Change the following values:
Create a small file named, for example, ipc.stanza and use the appropriate values. For example:
ipc:
shm_max=28901376 sem_mni=33
4)Execute:
#/sbin/sysconfigdb
5)Assure that the ipc parameters were added:
# tail /etc/sysconfigtab
6.Reboot the system.
After rebooting, you can check that the changes have taken effect by this command:
#/sbin/sysconfig -q ipc
PostgreSQL will also start. Confirm that PostgreSQL is running by this command:
#ps
If the postmaster process still did not start, review the /usr/internet/pgsql/data/ postmaster.log file for an error message.
For information on what may be causing the error, review the PostgreSQL documentation at http://www.postgresql.org or from the installed documentation in the /usr/internet/ pgsql/docs directory.
