Hint to set owner for tablespace directory

From: Maksim Milyutin <milyutinma(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Hint to set owner for tablespace directory
Date: 2018-08-23 11:24:25
Message-ID: 5ca60e1a-26f9-89fd-e912-021dd2b8afe2@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

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*).

--
Regards,
Maksim Milyutin

Attachment Content-Type Size
owner_tbsp_hint.patch text/x-patch 785 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Luzanov 2018-08-23 12:39:07 Re: [HACKERS] proposal: schema variables
Previous Message David Rowley 2018-08-23 10:58:26 Make executor's Range Table an array instead of a List