Re: Hint to set owner for tablespace directory

On 07/09/2018 17:59, Maksim Milyutin wrote:
>> 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.

I think it might be worth clarifying the documentation instead. I'm
looking at the CREATE TABLESPACE reference page and it's not super clear
on first reading.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services