Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g4QJw-00084D-N1 for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Sep 2018 12:50:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g4QJu-0002sg-PC for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Sep 2018 12:50:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g4QJt-0002sV-R8 for pgsql-hackers@lists.postgresql.org; Mon, 24 Sep 2018 12:50:34 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g4QJd-0002mp-H4 for pgsql-hackers@postgresql.org; Mon, 24 Sep 2018 12:50:33 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id 4E5AE20B1C; Mon, 24 Sep 2018 08:50:15 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute7.internal (MEProxy); Mon, 24 Sep 2018 08:50:15 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=YTrKojyeLe1mjMpximlpo68Pfx5pk KtuiDrpKaNFgOs=; b=lO1P39XHJNYjaznCygUBJMU5+Yb2Stllp3OyJjW7X2JJl aYDsNOjCIGd9HYMf2B1KbTNPsmgU8S582He2G9XDjcYmcU3zif0l1bbaeYjTXJ0C hWmrXu3VhftLejOpuv+Dq0Fa1Vqlo3eg7MtKbFOMRR1zv9Fts9IRsQYqMd1f5XFv Cna6CNLpCmgn0yuTyPt9jkyZkal2i4QpbcSJ3620Vkg9StEFY5Yl3d2p8CCdWJh3 dtSf4S4q1/Q+QseMnjv5TfqGjQB8F2m9DRbr+6waR21f/MPStjtKl6LNWVR8ekOn MySj4Tx7fTXMbf8iB7vBZ2wnbbzSyaZoXG3NbOgOA== X-ME-Proxy: X-ME-Sender: Received: from april.pezone.net (static-84-42-175-93.net.upcbroadband.cz [84.42.175.93]) by mail.messagingengine.com (Postfix) with ESMTPA id 033A9E4118; Mon, 24 Sep 2018 08:50:13 -0400 (EDT) Subject: Re: Hint to set owner for tablespace directory From: Peter Eisentraut To: Maksim Milyutin 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> <91828914-cfa2-b186-01e3-68a39a77f497@gmail.com> <8aa308d4-347a-52a3-0294-f0672b091a7e@2ndquadrant.com> Cc: Tom Lane , PostgreSQL-development Openpgp: preference=signencrypt Autocrypt: addr=peter.eisentraut@2ndquadrant.com; prefer-encrypt=mutual; keydata= xsFNBFUUt6kBEADZd9NNTBJbHmAXXJgPGOdd6Q73l80oifIVgn2tRxP9dYkCfTlo/yLqbKTl JNqTcyM6XrJDnB2sMEUGYCewYZXl+9C4bBJWyNqcEI1ae9u71vEq/fknFLArJ+2wN+f7QuRx Q8d94ZJAiJQ5g3fNk2HVeedCQCKP5dCzU+ZLt2dbsx1PDZLjTO9gf+JswWuGFb5wY5PZVM5V hq66Xk7ZJzHuARacza2RT7J2fkMmQBY+kr7L98Perb0GhafnlhXB0PvUB+N3xpmggMfwuhTu BngS/G/r3GvemxJuFxouw8xsMqrsfdksJXA2gLXYtwRCssdPV3PO0rlD9twqDo8URfIJ5fb6 1g/MV8aTOKjg3Q8MpJPtkwJqN4o3PvbwYdedeFnOVkkYAJdu/aX1v1BeCBDu7Hy3sF52scD3 pQbyQSl9vUDpTLarASAxNbAV0NRJE8dp4vfW6AH1ccryGiFqw/czPK/iN0+MT8wsjAW6WW4w hvjm5UPA1KTwi3ZT8eT5uycuH7QpuNk7LnGGXQ6KaRALFywzkr0A0V0AvFNa+l4wstMaXaB6 dmMXyF0/hfryqyOeu1gAdq4q0/PNC2dPgb/6uoh4eMjN6A5GXcprilhz5DulmsilY21hfSoU S64ODed96pKhprsOxjZiDRsN1QM5MwB+uwVWUNfsX7fIxE0BrwARAQABzSdQZXRlciBFaXNl bnRyYXV0IDxwZXRlckBlaXNlbnRyYXV0Lm9yZz7CwXoEEwEIACQCGwMFCwkIBwMFFQoJCAsF FgIDAQACHgECF4AFAlUUuKQCGQEACgkQoZ8SQ+xBJp8llw//RbGoXnF72FZTlOFsnNyxnWbF vViPCfdAlZl1GGK9OYCvV1dp/956HuhB0wpaGQHiBmQfOPJf/jLOPjXFYm2iEChEycrBChuE j4TSYemMp5BSPILYk9Uwd16kVD/+U6fQfK6H5pOhfBvbM6asMnmpY2wQuvktxHvaGlytFw84 EzFWNZtAZfxkw28w3AhIQkKe9hJanfyDL750RcbyEr8AAHty5IErrvS7tM5vQwIeh5BF26ND CyKPRdZgOgMpcwFfROKBDpAt052CgWIpNdhBdfIKlkCs4/ILxmC3rT/Mb/qZiHcoMMwEu6k+ T7vRAFZZAk62Yrr/U8/vUGKlzRZQoo86fyojCfI0ibCIc0z8rwCVY9P40G9wD9BTCZS/z8Vh jjpBlNnIKw2hM6hbxavKndCJjFFJD08rXrTyrLF/of18xD37vNdYooP9VATB5QjOWFRrscSZ 4a89e+to3m7YVnd4xdXwGp47dYusoax84C8tg1gZrH38ol9dPmnKX6GZrXeS7tH9k8VeUpJ8 HQbRThQRWAT936QpYbLConBmOtmbLmjQOGtiXPo1oK57X/7U/WBja5vWmm2q+Yxtt+3uHGVg DdDU4CJpXo4lX0v2n3QV5EBSW9hjdF3bNfl6GFBb1pPEhqNcMDUc7zkx/2uENdAdk/BnqMgH umip7b0pVfvOwU0EVRS3qQEQAJf6p0P7D+hMYUgCPkvgrcz6OJYsAYdUMUmokfqmkKwK0oJM ew8TNGM53ocKAgQGma5f10rwbZNPlpVPNRX5hwUmwVlcwSut0oE+JfUBH7mpysWvpF05RKIy q9RCoJZrAbXS7Tig56A1QD8IcM00rERZMcCOlI1+q9m4u9AOI+0LyGGSH+VvoyDHD/Jew4R2 TmPEF8Pu7lYiNYK88Q6u0kBkc+Tz3BNlyc6fi3HxnFfp0b75HLXPSTu2SwA/0Q31wHZXwrEU BR9KgSn/qbgy8ydPc97i82fhiFE3cbGexfPrQSMYmDGi+dcQ0s+AMQwC3XyMC0JkHpYUuFkR QdlIvaIhgFUUN2Vr4xF2ADaNTNFc4DYaiPHFAgHZw+3pZWqS4uIiWgJynrEaHw4F3QWU8/JB iyEWDhNq4WBrRA0u914TCCAoFOOKMnRdl8eJrRQKM/5/lXbHFjjlI/LDKhLRFsuQsnJJ3331 RjCzpHPZG5/p5KR1RHiAXa0p/DW5lXyq21hS3kjDlleoHqOxCN/cy0Jgz7qLDq1vZoCl67Sy RAH60c2Xu4may9SVltmot0OzWVHdrfS+85FQGp9580DaeLio7YMFKy2bfEvwQJ/c9xD2QPB+ oSb3V8ueSznXBG5+dyfOsZFRPxceA0wA2rSWZSjxLdKxvyGTj9vsCjaDu13rABEBAAHCwV8E GAEIAAkFAlUUt6kCGwwACgkQoZ8SQ+xBJp+HJhAAxmSTsC5y7p9Zu+nnLpucv/h88oEx985e qWeXzQiwM3pfRZS+PdTH9TyzHK0KOgKoAiubk0vt+BrT91D9d0G5kVQaTctAErGBoMkTaZJT XVEcNphiPzysdSqvprjojMp1y7rG8AP+Xd6m0rE1LRnkRRm8HyI8vdXsuLQPITGWXDLMjaNq AOV3BUnzkgtjMuIYw7SCr+12ZOb5dEKvaG4kjC4kaJ/TLbuBhVANcXkC90yp0AOZLs/cB1Dj OAXno/RUUruJ3r27a+pFv768UAi9QWcdw58yPxreMNMLqAgsS9oTHwHfGNWcB2dJ4UW+GMLJ hTf9TjQ2f+N/sIx5XMQ9pYw6CAJMK29qPx6/ZayrPxf22EXf0D3zTwIEZgwfSkynFVwV25L7 awQq60fifdMYheSxq7GbhpsixmcD+e161cCmLIt75YDt5bQ0B1yf7EmxG8n7pGZAOM6LoNsU fkSldba5XVwh8LuN5mK0nQBELGW6Os4TDq4REggLpfcvFC215zpuo0iCGnmE/Bns4nowqUSP u4tkWL+nxW4qgv8wo8HJ52jd79EJ8iqfIBoidBfy9AIUiEUApGQzWPu6yWcI8fY0rN5D+tc+ Yw1Zt6Mm+huYJpgCRsTcfzEcahnBn521CWcWvhW1ff3KFileFMtNmnBBhMncmRKHphtTKEpN 3jI= Organization: 2ndQuadrant Message-ID: <542444d9-d768-aa10-07c1-83abd896e86f@2ndquadrant.com> Date: Mon, 24 Sep 2018 14:50:12 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <8aa308d4-347a-52a3-0294-f0672b091a7e@2ndquadrant.com> Content-Type: multipart/mixed; boundary="------------0E87FF0A08882F2CB37FD151" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------0E87FF0A08882F2CB37FD151 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services --------------0E87FF0A08882F2CB37FD151 Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="0001-doc-Clarify-CREATE-TABLESPACE-documentation.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="0001-doc-Clarify-CREATE-TABLESPACE-documentation.patch" RnJvbSBlYjA3OTY5MjFiNmViZmUyMzc1MDM3ZDkwM2EwODFhN2I4ZjQ1YzBiIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBFaXNlbnRyYXV0IDxwZXRlcl9lQGdteC5u ZXQ+CkRhdGU6IE1vbiwgMjQgU2VwIDIwMTggMTQ6NDc6MDkgKzAyMDAKU3ViamVjdDogW1BB VENIXSBkb2M6IENsYXJpZnkgQ1JFQVRFIFRBQkxFU1BBQ0UgZG9jdW1lbnRhdGlvbgoKQmUg bW9yZSBzcGVjaWZpYyBhYm91dCB3aGVuIGFuZCBob3cgdG8gY3JlYXRlIHRoZSBkaXJlY3Rv cnkgYW5kIHdoYXQKcGVybWlzc2lvbnMgaXQgc2hvdWxkIGhhdmUuCi0tLQogZG9jL3NyYy9z Z21sL3JlZi9jcmVhdGVfdGFibGVzcGFjZS5zZ21sIHwgMTcgKysrKysrKysrKysrKy0tLS0K IDEgZmlsZSBjaGFuZ2VkLCAxMyBpbnNlcnRpb25zKCspLCA0IGRlbGV0aW9ucygtKQoKZGlm ZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlc3BhY2Uuc2dtbCBiL2Rv Yy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlc3BhY2Uuc2dtbAppbmRleCAxOGZhNWYwZWJm Li5jNjIxZWMyYzZiIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJs ZXNwYWNlLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGVzcGFjZS5z Z21sCkBAIC05Miw3ICs5Miw4IEBAIDx0aXRsZT5QYXJhbWV0ZXJzPC90aXRsZT4KICAgICAg IDxsaXN0aXRlbT4KICAgICAgICA8cGFyYT4KICAgICAgICAgVGhlIGRpcmVjdG9yeSB0aGF0 IHdpbGwgYmUgdXNlZCBmb3IgdGhlIHRhYmxlc3BhY2UuIFRoZSBkaXJlY3RvcnkKLSAgICAg ICAgc2hvdWxkIGJlIGVtcHR5IGFuZCBtdXN0IGJlIG93bmVkIGJ5IHRoZQorICAgICAgICBt dXN0IGV4aXN0ICg8Y29tbWFuZD5DUkVBVEUgVEFCTEVTUEFDRTwvY29tbWFuZD4gd2lsbCBu b3QgY3JlYXRlIGl0KSwKKyAgICAgICAgc2hvdWxkIGJlIGVtcHR5LCBhbmQgbXVzdCBiZSBv d25lZCBieSB0aGUKICAgICAgICAgPHByb2R1Y3RuYW1lPlBvc3RncmVTUUw8L3Byb2R1Y3Ru YW1lPiBzeXN0ZW0gdXNlci4gIFRoZSBkaXJlY3RvcnkgbXVzdCBiZQogICAgICAgICBzcGVj aWZpZWQgYnkgYW4gYWJzb2x1dGUgcGF0aCBuYW1lLgogICAgICAgIDwvcGFyYT4KQEAgLTEz NywxNSArMTM4LDIzIEBAIDx0aXRsZT5Ob3RlczwvdGl0bGU+CiAgIDx0aXRsZT5FeGFtcGxl czwvdGl0bGU+CiAKICAgPHBhcmE+Ci0gICBDcmVhdGUgYSB0YWJsZXNwYWNlIDxsaXRlcmFs PmRic3BhY2U8L2xpdGVyYWw+IGF0IDxsaXRlcmFsPi9kYXRhL2RiczwvbGl0ZXJhbD46Cisg ICBUbyBjcmVhdGUgYSB0YWJsZXNwYWNlIDxsaXRlcmFsPmRic3BhY2U8L2xpdGVyYWw+IGF0 IGZpbGUgc3lzdGVtIGxvY2F0aW9uCisgICA8bGl0ZXJhbD4vZGF0YS9kYnM8L2xpdGVyYWw+ LCBmaXJzdCBjcmVhdGUgdGhlIGRpcmVjdG9yeSB1c2luZyBvcGVyYXRpbmcKKyAgIHN5c3Rl bSBmYWNpbGl0aWVzIGFuZCBzZXQgdGhlIGNvcnJlY3Qgb3duZXJzaGlwOgorPHByb2dyYW1s aXN0aW5nPgorbWtkaXIgL2RhdGEvZGJzCitjaG93biBwb3N0Z3Jlczpwb3N0Z3JlcyAvZGF0 YS9kYnMKKzwvcHJvZ3JhbWxpc3Rpbmc+CisgICBUaGVuIGlzc3VlIHRoZSB0YWJsZXNwYWNl IGNyZWF0aW9uIGNvbW1hbmQgaW5zaWRlCisgICA8cHJvZHVjdG5hbWU+UG9zdGdyZVNRTDwv cHJvZHVjdG5hbWU+OgogPHByb2dyYW1saXN0aW5nPgogQ1JFQVRFIFRBQkxFU1BBQ0UgZGJz cGFjZSBMT0NBVElPTiAnL2RhdGEvZGJzJzsKIDwvcHJvZ3JhbWxpc3Rpbmc+CiAgIDwvcGFy YT4KIAogICA8cGFyYT4KLSAgIENyZWF0ZSBhIHRhYmxlc3BhY2UgPGxpdGVyYWw+aW5kZXhz cGFjZTwvbGl0ZXJhbD4gYXQgPGxpdGVyYWw+L2RhdGEvaW5kZXhlczwvbGl0ZXJhbD4KLSAg IG93bmVkIGJ5IHVzZXIgPGxpdGVyYWw+Z2VuZXZpZXZlPC9saXRlcmFsPjoKKyAgIFRvIGNy ZWF0ZSBhIHRhYmxlc3BhY2Ugb3duZWQgYnkgYSBkaWZmZXJlbnQgZGF0YWJhc2UgdXNlciwg dXNlIGEgY29tbWFuZAorICAgbGlrZSB0aGlzOgogPHByb2dyYW1saXN0aW5nPgogQ1JFQVRF IFRBQkxFU1BBQ0UgaW5kZXhzcGFjZSBPV05FUiBnZW5ldmlldmUgTE9DQVRJT04gJy9kYXRh L2luZGV4ZXMnOwogPC9wcm9ncmFtbGlzdGluZz48L3BhcmE+Ci0tIAoyLjE5LjAKCg== --------------0E87FF0A08882F2CB37FD151--