Skip site navigation (1) Skip section navigation (2)

Re: postmaster blues after system restart

From: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Subject: Re: postmaster blues after system restart
Date: 2005-10-17 23:36:02
Message-ID: C8A515DC-317B-4051-9F6E-97DCCFF87380@sitening.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, 2005-10-14 at 15:49, Thomas F. O'Connell wrote:

>> The culprit that ended up leading to my original post was an NFS
>> script that cleans out /tmp. It was running as the last thing in a
>> given boot level, so it blew away the socket file in /tmp.
>
> I'm sure you already know this, but wildly / randomly deleting  
> things in
> /tmp is a bad idea...

Well, here's the story. It was a Debian box, and somehow, mountnfs.sh  
wound up at S99 in /etc/rc2.d. I'm not sure how that happened, but it  
raises some potential questions:

Converting this to a PostgreSQL on Debian question: is it a good  
admin practice to go ahead and set TMPTIME=-1 in /etc/default/rcS on  
Debian servers running postgres?

If the answer is "yes", then it becomes a more purely Debian  
question: what are the ramifications of not cleaning out /tmp at boot  
using initscripts?

More widely: are there other non-Debian-based distributions that have  
a similar facility for wiping /tmp at boot? Is changing the timing  
easy? Is the disabling mechanism the same?

Maybe not having seen too many prior instances of this particular  
issue is a good sign that no one is obliterating the contents of /tmp  
after postgres has started, but the fact that Debian has tools in  
initscripts that seek to clean out /tmp this makes me think a mention  
of this in the PostgreSQL documentation might be a good idea (perhaps  
in 14.6: Post-Installation Setup?).

But I'd be curious to know the perspective of other Debian/PostgreSQL  
admins on where they think the issue really lies or even whether  
there is a perceived issue.

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Open Source Solutions. Optimized Web Development.

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)


Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2005-10-17 23:50:48
Subject: Re: solaris install - 8.0.3 config fails on openssl, 7.4 config works
Previous:From: Roth, GabrielleDate: 2005-10-17 22:31:45
Subject: Re: solaris install - 8.0.3 config fails on openssl, 7.4 config works

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group