Re:

Since this person isn't the sysadmin, we can speculate that he was
running it as himself, and thus there was no shutdown script in
/etc/rc.d/. So when the system shuts down it doesn't know how to shut
down postgres properly, sends it a TERM, and then a KILL.

Jim Mercer wrote:
>
> On Thu, Jul 27, 2000 at 12:18:23PM -0400, Mehta, Ashok wrote:
> > I am running postgres on RedHat Linux It was running fine and our sysadmin
> > added a scsi tape device to the kernel and rebooted the machine so the
> > postmaster was killed with -9 signal and after that when I start postmaster
>
> did the sysadmin kill postmaster with -9 or reboot, or both.
>
> reboot does not normally kill things off with a -9, depending on the system
> it uses a progression of other nicer signals.
>
> killing postmaster with -9 is bad, as it doesn't give the process any chance
> to do shutdown/cleanup functions, which might include clearing the socket in
> /tmp.
>
> this might also explain why you got the error after kill -9/reboot, but didn't
> get it after a normal reboot.
>
> if your sysadmin is going around using "kill -9" as a standard shutdown method,
> well, you might want to speak to them about this, as it isn't really a nice
> way to deal with things.
>
> > I get
> > FATAL: StreamServerPort: bind() failed: Permission denied
> > Is another postmaster already running on that port?
> > If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
> > postmaster: cannot create UNIX stream port
> >
> > I have rebooted the machine since then and there is no file in /tmp
> > directory to be removed. I am absolutly positive that another postmaster is
> > not running and that file does not exist.
> >
> >
> > Any suggestions would be appreciated.
> >
> > Thanks
> > Ashok
> >
>
> --
> [ Jim Mercer jim(at)reptiles(dot)org +1 416 410-5633 ]
> [ Reptilian Research -- Longer Life through Colder Blood ]
> [ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]