Re: Trouble starting server - Mailing list pgsql-admin

From Jeff Frost
Subject Re: Trouble starting server
Date
Msg-id Pine.LNX.4.64.0602161029100.2892@glacier.frostconsultingllc.com
Whole thread Raw
In response to Trouble starting server  (Barry Moore <barry.moore@genetics.utah.edu>)
Responses Re: Trouble starting server
List pgsql-admin
On Thu, 16 Feb 2006, Barry Moore wrote:

> So with my minimal system admin skills I'm guessing that '/tmp/.s.PGSQL.5432'
> is lock file where the system puts a lock on port 5432 for postmaster to
> listen, but the pg_ctl and postmaster commands can't create that file because
> /tmp is writeable only by root (drwxr-xr-x   11 root root  4096 Feb 16 11:06
> tmp).  Of course I can't start the postmaster as root, so I'm a bit perplexed
> as to what to do, and why I never had this problem before.

You need to change the permissions on /tmp.  I'd be curious to know how it got
this way.  Has anyone done chmods on /tmp?  It should be 1777/drwxrwxrwt, so a
chmod 1777 /tmp should fix it
for you.


--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-admin by date:

Previous
From: Barry Moore
Date:
Subject: Trouble starting server
Next
From: RW
Date:
Subject: Re: Switch log (WAL)