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

From Maksim Milyutin
Subject Re: Hint to set owner for tablespace directory
Date
Msg-id 91828914-cfa2-b186-01e3-68a39a77f497@gmail.com
Whole thread Raw
In response to Re: Hint to set owner for tablespace directory  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: Hint to set owner for tablespace directory  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
On 09/07/2018 06:05 PM, Peter Eisentraut wrote:

> On 07/09/2018 11:59, Maksim Milyutin wrote:
>> OK. However I think it would be helpful to leave the mention about
>> setting necessary owner for tablespace directory. My final version of
>> hint is "You might need to fix permissions on this directory or its
>> parents or install the PostgreSQL system user as the owner of this
>> directory." And updated version of patch is attached.
> You are still proposing to hint that the permissions on the tablespace
> directory might be correct but that the main database instance is
> running under the wrong user.

Not exactly this way. The case that motivated me to make this patch was 
the novice user after installing postgres from package (with setting up 
postgres user and initializing PGDATA with right permissions) tried to 
create the necessary tablespace directories from himself (the owner of 
those directories was that user). The error message "could not set 
permissions on directory ..." disoriented that user. The need to change 
the owner of those directories came after careful reading of 
documentation. I think it would be helpful to show the proposed hint to 
more operatively resolve the problem.

-- 
Regards, Maksim Milyutin



pgsql-hackers by date:

Previous
From: Chris Travers
Date:
Subject: [PATCH] Fix for infinite signal loop in parallel scan
Next
From: Peter Eisentraut
Date:
Subject: Re: pgsql: Refactor dlopen() support