pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Maksim Milyutin <milyutinma@gmail.com>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Hint to set owner for tablespace directory
Date: Mon, 1 Oct 2018 15:41:38 +0300
Message-ID: <d73e39a0-a25f-447f-4886-05b1bf915663@gmail.com> (raw)
In-Reply-To: <e1e255c1-9ff5-79ff-44d5-9709e1ee7b48@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>
	<91828914-cfa2-b186-01e3-68a39a77f497@gmail.com>
	<8aa308d4-347a-52a3-0294-f0672b091a7e@2ndquadrant.com>
	<542444d9-d768-aa10-07c1-83abd896e86f@2ndquadrant.com>
	<e1e255c1-9ff5-79ff-44d5-9709e1ee7b48@2ndquadrant.com>

01.10.2018 15:15, Peter Eisentraut wrote:

> On 24/09/2018 14:50, Peter Eisentraut wrote:
>> On 11/09/2018 17:10, Peter Eisentraut wrote:
>>> On 07/09/2018 17:59, Maksim Milyutin wrote:
>>>> 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.
>> How about the attached patch?
> I have committed this patch and will close this commitfest item.  I
> don't think the idea with the hints in the code was going anywhere.
>

Yes, thanks. Sorry for so delayed answer, I was busy. You have clearly 
described the workflow to create tablespace (including *chown* command) 
and in general it is enough to resolve the issue with  wrong owner of 
tablespace directory.

-- 
Regards,
Maksim Milyutin





view thread (19+ messages)

Message-ID: <d73e39a0-a25f-447f-4886-05b1bf915663@gmail.com>
Permalink:  ../d73e39a0-a25f-447f-4886-05b1bf915663@gmail.com/
Also on:    postgresql.org/message-id/d73e39a0-a25f-447f-4886-05b1bf915663@gmail.com

 · 

reply
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: <d73e39a0-a25f-447f-4886-05b1bf915663@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