[cobalt-developers] Re: Postgresql cannot be restarted

[Bruce Timberlake <bruce.timberlake@xxxxxxx>]

Jody Sanders wrote:
> 
> OK.
> 
> I've tried everything.
> 
> I have a problem in that Postgresql will *not* start on my machine, tried a
> reboot.
> 
> ./postgresql restart comes up with the following:
> 
> Shutting down PostgreSQL: not running!
> Setting up PostgreSQL: failed!
> 
> Examining /var/log/postgresql:
> 
> 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.
> /usr/bin/postmaster: cannot create UNIX stream port

Check the ownership and permissions on /tmp (which is/should be
symlinked to /home/tmp). /home/tmp should be owned by root (user and
group), and have "drwxrwxrwt" permissions. (If it doesn't, do "chmod
a+tw tmp" or "chmod 1777 tmp" to set it correctly.)

FYI - With the t bit set, only the owner of a file or the owner of the
directory can delete a file. This is what allows multiple programs to
"dump" files in /tmp without anyone else being able to remove them.

-- 
Bruce Timberlake
Technology Engineer
Sun Cobalt Server Appliances
Sun Microsystems, Inc.

E: bruce.timberlake@xxxxxxx
U: http://www.sun.com/cobalt/