From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Maksim Milyutin <milyutinma@gmail.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 17:05:21 +0200
Message-ID: <b1a2ea3c-9472-2ca3-a5ab-ada7215a0d65@2ndquadrant.com> (raw)
In-Reply-To: <c0b574a8-1a8f-2e74-981c-f4206b0e385a@gmail.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>
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. I don't think that is a plausible
situation. Clearly changing the tablespace directory permissions is
much simpler than changing the entire database setup.
The normal error situation here is that the tablespace directory has
been created in a way that the "postgres" user can't access the way it
wants. I don't see how the existing messaging is insufficient in that case.
If anything, we should look to create some consistency with initdb. It
basically does the same thing when it creates a new data directory. I'm
not aware of a need to add more hints there either.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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: peter.eisentraut@2ndquadrant.com, milyutinma@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Hint to set owner for tablespace directory
In-Reply-To: <b1a2ea3c-9472-2ca3-a5ab-ada7215a0d65@2ndquadrant.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