Re: Trouble starting server

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Barry Moore <barry(dot)moore(at)genetics(dot)utah(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Trouble starting server
Date: 2006-02-16 18:30:58
Message-ID: Pine.LNX.4.64.0602161029100.2892@glacier.frostconsultingllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Barry Moore 2006-02-16 18:40:16 Re: Trouble starting server
Previous Message RW 2006-02-16 18:30:56 Re: Switch log (WAL)