pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Barry Moore <barry.moore@genetics.utah.edu>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Trouble starting server
Date: Thu, 16 Feb 2006 11:40:16 -0700
Message-ID: <7C295891-3DCE-4606-94D8-7EB5C451F04B@genetics.utah.edu> (raw)
In-Reply-To: <Pine.LNX.4.64.0602161029100.2892@glacier.frostconsultingllc.com>
References: <3DAF6869-77A4-4B3F-ADCF-DBF36ACA5E41@genetics.utah.edu>
	<Pine.LNX.4.64.0602161029100.2892@glacier.frostconsultingllc.com>

Thanks.  I wasn't sure that I should do that since I didn't change  
those permissions since I hadn't done anything with it.  There is a  
new user who is taking over admin of this machine, so I'll have to  
ask if the did anything to affect this.

Barry

On Feb 16, 2006, at 11:30 AM, Jeff Frost wrote:

> 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




view thread (3+ messages)

Message-ID: <7C295891-3DCE-4606-94D8-7EB5C451F04B@genetics.utah.edu>
Permalink:  ../7C295891-3DCE-4606-94D8-7EB5C451F04B@genetics.utah.edu/
Also on:    postgresql.org/message-id/7C295891-3DCE-4606-94D8-7EB5C451F04B@genetics.utah.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: barry.moore@genetics.utah.edu, jeff@frostconsultingllc.com
  Subject: Re: Trouble starting server
  In-Reply-To: <7C295891-3DCE-4606-94D8-7EB5C451F04B@genetics.utah.edu>
  References: <3DAF6869-77A4-4B3F-ADCF-DBF36ACA5E41@genetics.utah.edu> <Pine.LNX.4.64.0602161029100.2892@glacier.frostconsultingllc.com> <7C295891-3DCE-4606-94D8-7EB5C451F04B@genetics.utah.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox