From: Maksim Milyutin <milyutinma@gmail.com>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Hint to set owner for tablespace directory
Date: Fri, 7 Sep 2018 18:59:34 +0300
Message-ID: <91828914-cfa2-b186-01e3-68a39a77f497@gmail.com> (raw)
In-Reply-To: <b1a2ea3c-9472-2ca3-a5ab-ada7215a0d65@2ndquadrant.com>
References: <5ca60e1a-26f9-89fd-e912-021dd2b8afe2@gmail.com>
<1bc2bc14-e42a-8d9c-d47c-3afac05de347@2ndquadrant.com>
<2615ea98-6537-1fcf-667a-09022063336a@postgrespro.ru>
<17440.1535723980@sss.pgh.pa.us>
<c0b574a8-1a8f-2e74-981c-f4206b0e385a@gmail.com>
<b1a2ea3c-9472-2ca3-a5ab-ada7215a0d65@2ndquadrant.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: milyutinma@gmail.com, peter.eisentraut@2ndquadrant.com, tgl@sss.pgh.pa.us
Subject: Re: Hint to set owner for tablespace directory
In-Reply-To: <91828914-cfa2-b186-01e3-68a39a77f497@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox