Re: Hint to set owner for tablespace directory - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Hint to set owner for tablespace directory
Date
Msg-id 17440.1535723980@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hint to set owner for tablespace directory  (Maksim Milyutin <milyutinma@gmail.com>)
Responses Re: Hint to set owner for tablespace directory
List pgsql-hackers
Maksim Milyutin <milyutinma@gmail.com> writes:
> 30.08.2018 19:52, Peter Eisentraut wrote:
>> I think the hint is backwards.  When you don't have permission to chmod
>> the tablespace directory, you probably want to fix the permissions on
>> the tablespace directory or its parent.

> In this case I propose to:
> - replace my initial hint message to the guess what to do if errno == 
> EPERM, smth like "You might need to install the PostgreSQL system user 
> as the owner of this directory";
> - add another hint if errno == EACCES: "Fix permissions on the parent 
> directories".

I agree with what I think Peter is saying: the hint should just recommend
fixing permissions on the directory, for either errno code.  The more
detail you try to give, the more likely the hint will be wrong
... especially when you're dealing with errno codes that aren't all that
well standardized, as these aren't.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Georgy Buranov
Date:
Subject: PostgreSQL logical decoder output plugin - unchanged toast data
Next
From: Tom Lane
Date:
Subject: Re: psql \dC incorrectly shows casts "with inout" as "binary coercible" on 9.5.14 and 11beta3