Re: cannot access directory /pg_tblspc/* - Mailing list pgsql-novice

From Tom Lane
Subject Re: cannot access directory /pg_tblspc/*
Date
Msg-id 21732.1150562689@sss.pgh.pa.us
Whole thread Raw
In response to cannot access directory /pg_tblspc/*  (Charlie <perezchar@gmail.com>)
Responses Re: cannot access directory /pg_tblspc/*  (Charlie <perezchar@gmail.com>)
List pgsql-novice
Charlie <perezchar@gmail.com> writes:
> The problem is when I want to access my database 'test' once the system is
> up, it says it cannot access directory /pg_tblspc/<xxx> where <xxx> is a
> number.

I suspect it says more than that.  Please provide the complete, exact
error message.

> This error can be solved by MANUALLY restarting the service 'postgresql'
> ('service postgresql restart').

That seems pretty strange.  Is it possible your boot sequence is trying
to launch the database before the /bdd volume is mounted?  We've seen
some pretty strange bug reports that turned out to be due to the
postmaster connecting to a working directory that was then hidden by a
subsequent mount operation ...

            regards, tom lane

pgsql-novice by date:

Previous
From: "Greg Quinn"
Date:
Subject: Stored Procedure Question
Next
From: Michael Fuhr
Date:
Subject: Re: Stored Procedure Question