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

Re: danger of stats_temp_directory = /dev/shm

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: danger of stats_temp_directory = /dev/shm
Date: 2013-04-25 01:42:45
Message-ID: 20130425014245.GR2169@eldon.alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Jeff Janes escribió:
> With the stats file split patch 187492b6c2e8cafc5 introduced in 9.3dev, now
> after a crash the postmaster will try to delete all files in the directory
> stats_temp_directory.  When that is just a subdirectory of PGDATA, this is
> fine. But it seems rather hostile when it is set to a shared directory,
> like the popular /dev/shm.

> Does this need to be fixed, or at least documented?

I think we need it fixed so that it only deletes the files matching a
well-known pattern.  In fact, there's an XXX comment about this in the
code:

	/* XXX should we try to ignore files other than the ones we write? */

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


In response to

Responses

pgsql-hackers by date

Next:From: KONDO MitsumasaDate: 2013-04-25 02:49:40
Subject: Re: Failing start-up archive recovery at Standby mode in PG9.2.4
Previous:From: Kyotaro HORIGUCHIDate: 2013-04-25 01:32:30
Subject: Re: Failing start-up archive recovery at Standby mode in PG9.2.4

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