Re: [cobalt-users] PostgreSLQ problem

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"The Thieving Gypsy" <lists@xxxxxxxxxxxxxxxxxxx> wrote:
> I've got a rather strange problem on one of my RaQ3s:  Postgres has
stopped,
> making the GUI useless, and whenever I try to manually kick-start it, I
get
> the following errors:
>
> [root@xxxxxxxxxxx init.d]# ./postgresql start
> Setting up PostgreSQL: FATAL: StreamServerPort: bind() failed: Permission
> denied
>         Is another postmaster already running on that port?
>         If not, remove socket node (/tmp/.s.PGSQL.5583) and retry.
> /usr/bin/postmaster: cannot create UNIX stream port

I'm not as skilled at administering Postgres as MySQL, but here's what I
know.  Check to see if Postgres is actually running.

ps aux | grep postmaster

If it returns a record (other than "grep postmaster") it's running.
According to the error output above, try deleting /tmp/.s.PGSQL.5583 and
then restarting Postgres.  On a RaQ2 with a copy of Postgres I installed
from source (v 7.0, I don't recall what the RaQ3 has installed, but I think
it's an earlier version), I have to su to the user that Postgres runs as
before starting postmaster.  On my system that user is "postgres", on yours
it might be something different (maybe even "root").  If that's the case,
make sure you are that user before running the startup script.  I hope that
helps.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/