Jeff Davis <jdavis@dynworks.com> writes:
> Basically, psql would sit there trying to connect, meanwhile all the
> attempted connections wouldn't die.
More details please? What do you mean exactly by the above statements?
> I had to "kill -9" all the
> postgres/postmaster processes.
Killing individual backends with kill -9 is NOT NOT NOT a recommended
procedure. In theory you can get away with it but why take risks?
Use the documented shutdown procedures to give the thing some chance
of cleaning up after itself.
regards, tom lane