Re: Hint to set owner for tablespace directory

On 23/08/2018 13:24, Maksim Milyutin wrote:
> I have noticed the novice users are stuck trying to create tablespace
> over a directory whose owner is not the system postgres user. They
> observed the message "could not set permissions on directory ...:
> permission denied".
>
> I want to add patch that prints hint to set required owner for the
> tablespace directory if this is the cause of the problem (*errno ==
> EPERM* after calling *chmod*).

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. But the hint says to run the
database server as a different user. That's a bit unusual.

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