|PostgreSQL Reference Manual - Volume 1 - SQL Language Reference|
by The PostgreSQL Global Development Group
Paperback (6"x9"), 716 pages
RRP £32.00 ($49.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
ipcclean -- remove shared memory and semaphores from a failed PostgreSQL server
ipcclean removes all shared memory segments and
semaphore sets owned by the current user. It is intended to be
used for cleaning up after a crashed
PostgreSQL server (
postgres). Note that immediately restarting the
server will also clean up shared memory and semaphores, so this
command is of little real utility.
Only the database administrator should execute this program as it can cause bizarre behavior (i.e., crashes) if run during multiuser execution. If this command is executed while a server is running, the shared memory and semaphores allocated by that server will be deleted, which would have rather severe consequences for that server.
This script is a hack, but in the many years since it was written,
no one has come up with an equally effective and portable solution.
postgres can now clean up by
itself, it is unlikely that
ipcclean will be
improved upon in the future.
The script makes assumptions about the output format of the
utility which may not be true across different operating systems.
Therefore, it may not work on your particular OS. It's wise to
look at the script before trying it.
|ISBN 0954612027||PostgreSQL Reference Manual - Volume 1 - SQL Language Reference||See the print edition|