Re: Postgresql wont restart. Can I clear shared memmory segments without rebooting?

[Mitchell Laks <mlaks@post.harvard.edu>]

On 15:30 Wed 06 Jan     , Kun Niu wrote:
> Before you execute "echo 3 > /proc/sys/vm/drop_caches", you'd better
> run "sync" first.:D

Thank you, a good point.

I was mostly interested as a matter of knowledge, as I did not go into linux to 
become a 'cargo culter' and reboot without knowing what it did. Rebooting will close
everything safely as well as free the unfreed shared memory segments. 

I wanted to know for knowledge sake... !

On the other hand, 
ipcs
look for postgresql owned shared memory
and 
ipcrm -s <ID> of those

would seem to be ok as long as no postgresql process is goind on in the background.

After reading about the different ways of doing this, which include rebooting, at the
postgresql mailing list, I would likely proceed in order of choice

1. reboot
or else if I am feeling really bold and adventurous, and have everything backed up nicely,
2. ipcs, then ipcrm -s <ID>

Thank you again!

Mitchell Laks