Re: BUG #5603: pg_tblspc and pg_twoface directories get deleted when starting up service - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5603: pg_tblspc and pg_twoface directories get deleted when starting up service
Date
Msg-id 25153.1295466093@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5603: pg_tblspc and pg_twoface directories get deleted when starting up service  (Nacho Mezzadra <nachomezzadra@gmail.com>)
List pgsql-bugs
Nacho Mezzadra <nachomezzadra@gmail.com> writes:
> Tom, Robert, sorry I am coming back to you after a while, but we still
> have the same issue.  This has been happening in our environments, but
> now it is also happening in customers' environments -which we do not
> set up- and it is also happening.  All environments are always Red Hat
> Enterprise 5.3.

You still haven't given any reason to think this is a Postgres bug,
nor indeed any information beyond what you said originally.

One thing that strikes me is that both pg_tblspc and pg_twophase are
empty and unused during normal operation (if you're not using the
relevant features).  They are scanned during postmaster startup though,
which is why you're getting failures then.  I suspect that these
subdirectories are not in fact getting removed during PG shutdown or
restart, but were deleted some time before that.  In particular I wonder
if somebody's loosed an overaggressive tmp-file-cleaning script on your
whole filesystem.  Something that was removing empty directories that
hadn't been accessed in awhile could explain this.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Nacho Mezzadra
Date:
Subject: Re: BUG #5603: pg_tblspc and pg_twoface directories get deleted when starting up service
Next
From: "Benoygopal"
Date:
Subject: Re: BUG #5791: Tables are not viewing through pgadmin