Re: Backend working directories and absolute file paths - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Backend working directories and absolute file paths
Date
Msg-id 21494.1120164536@sss.pgh.pa.us
Whole thread Raw
In response to Re: Backend working directories and absolute file paths  (Greg Stark <gsstark@mit.edu>)
Responses Re: Backend working directories and absolute file paths
Re: Backend working directories and absolute file paths
List pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> However it might be nice to have dumps go to a configurable place. 

You'd have to talk to your kernel provider about that one; we don't have
any direct control over where or even whether core dumps occur.

> There's another approach that seems more robust. When initdb is run randomly
> generate a unique id. Then whenever creating files include that unique id in
> the first block of the file. Whenever you open a file sanity check the first
> block. If it doesn't match PANIC immediately. (hm, actually you don't even
> need to PANIC, jut shutting the one backend should be enough.)

This adds overhead, rather than removing it as I was hoping to do.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Backend working directories and absolute file paths
Next
From: Josh Berkus
Date:
Subject: Re: Checkpoint cost, looks like it is WAL/CRC