Re: Post-Reboot Issue: Postmaster Not Accessible

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Rich Shepard <rshepard(at)appl-ecosys(dot)com> writes:
>    Is there a method other than a reboot to remedy this?

Stop the postmaster, remove the bogus socket file by hand, start the
postmaster.

I imagine that if you check the postmaster log you will notice a bleat
near the beginning about failing to open the socket file (because of
the pre-existence of the root-owned file).  It would come up anyway as
long as it could establish a TCP listen socket.

Offhand I would guess that things got this way because of some errant
tmp-cleaning script; perhaps the socket file got chown'd to root
sometime in the past during the previous postmaster's life.

			regards, tom lane