Internet Express for Tru64 UNIX Version 6.10 Administration Guide (5900-1418, March 2011)

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 -m -f ipc.stanza
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 -ef | grep postmaster.
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.
Scaling PostgreSQL 257