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 1gAPOt-0002tl-IL for pgsql-docs@arkaria.postgresql.org; Thu, 11 Oct 2018 01:04:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gAPOr-00059g-Dj for pgsql-docs@arkaria.postgresql.org; Thu, 11 Oct 2018 01:04:25 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gAPOr-00059Z-4R for pgsql-docs@lists.postgresql.org; Thu, 11 Oct 2018 01:04:25 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gAPOk-0004uG-11 for pgsql-docs@lists.postgresql.org; Thu, 11 Oct 2018 01:04:23 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 2EC3521F74; Wed, 10 Oct 2018 21:04:17 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Wed, 10 Oct 2018 21:04:17 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=IqACKHCRtjMNeyQX2wyaglbI6km zwMyxG6+y/VX84o0=; b=O3MvksMlpj+LYTz4GdvfCUPCQVeeFz09cI/l5CWgvcV t6DXHNEdIVfmWWkxUf4RLQCRj3MyK+5J4ghfVGeEo39XSD3jcw4yjs3gQniVX8A4 YTFlLyoorbulZlg/F9Rhak+u03sIfqbzOivMAqIxicS7Ued0iGNrOvG/BAX1IWhg eZftmXXH/svQ2AfhSOxJTb6SZFmZXu5BPEhVREZr/h5qY2xeEniZzfMwv57K/vPc 5kU7/vyaTL/pBQgi6ZFQenU++coU6MrqKInWzHKVfOGqxPQlFHUCjFKUzY06sSs2 1a3+oM9fLxe8Rv8Se4oh6MNRtArtGZxc9O9nQNu1UIA== 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-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=IqACKH CRtjMNeyQX2wyaglbI6kmzwMyxG6+y/VX84o0=; b=StdG5M32PWbWRCRR0DdK3M LEpNUaA50vpnrcLBkAgdYIzITG/vKARvjnv1fY0+QRIpPCDYQo+how8WmFrfV0bn O+tR+3TBiaIMFAolPgXzdCP1ALXepUMKPpHm3IQX+wiIrO8yqK3io+W4npIK7l+c pIfDGKKvPI1gl12Au4k3iwQmaWmWTWBHyYsmxWanr8dC7j4OTF17S3O9kOpiQ1iT Ag4KoPMi3/7n77ucUc+5Y+DaHTn1wAy/YF5896voZhgxpGIvZv15EpClX7TFAyyS KmVpXyFAyBhAjEmwZVA3nTXGrx4pz2/e99VZVTGnyhmiUQOW2Hb9uMVo7PkklNag == X-ME-Sender: X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 1E417E482E; Wed, 10 Oct 2018 21:04:14 -0400 (EDT) Date: Thu, 11 Oct 2018 10:04:12 +0900 From: Michael Paquier To: Bruce Momjian Cc: ppkrauss@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: please inform data_directory Message-ID: <20181011010412.GF2204@paquier.xyz> References: <153653649616.23138.1453197444453120513@wrigleys.postgresql.org> <20181010195959.GB7806@momjian.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="UTZ8bGhNySVQ9LYl" Content-Disposition: inline In-Reply-To: <20181010195959.GB7806@momjian.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --UTZ8bGhNySVQ9LYl Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Oct 10, 2018 at 03:59:59PM -0400, Bruce Momjian wrote: > What do you mean by that? I can call pg_read_file() before calling > 'SHOW data_directory'. Are you saying that pg_read_file can only read > in the data_directory? It is designed that way. Please note that v11 has added a new default role called pg_read_server_files, which allows a role to read files out of the data directory which is the default. -- Michael --UTZ8bGhNySVQ9LYl Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlu+oYwACgkQnvQgOdby QH0JpA//QfgEDpgimJdSzeD4UfgB2WsdE/18Fqavy/70cz7IxMphFIeT3TFSPBdT s2RP8mFPcROhw8IMzGoD/fw6ZrmZS9wGLTHG/tOWfKJtTMWmfCBceQmY8GicnSER JRZcN+fUtLam264bMBVeJr7lxRVPPShTKPaZ/0v60jnsmwAoNRrVstZxlgP0aMDX NQulzumD3UfLG0f5Cob8qfSzl5AiAczYnQVbIPLGFbD3IkumLtPHaK2qbh/3o0Tn WodvrA4kJTj8ZWbN7ihxkTgaiOz4rFnnduNE6Vv9w1isrGxbeJI+vneuWXlB3bFZ 12L241FRakUhm83Aakr+PxdhXxB1BW13vw0/tnrQ69KmoVIUNf2IXFRmNlPctqPM N8xXcE6uXyMvj65GFa6qE+8gFX50OkMpQnXQLz1y0AbWoI8gthDGTNZPMb/Ekogn bmuQqaLGUjAKNxvWFdjtMmB+1Ssx8RTmddUozY3E/K83F7fn9bj03ZaypPaFbEt+ GN3ATH0nNNf33WeOu5Z6rBMVSfQmo24IF1nUECqKKIqWl2zJbndkrWcB16UVZHqB yA8YlK+hxx9JL+ziAIwixvCXzWrqKwl+VLAgOMKr9FqvUjNYtWk6G48e6FCa1995 ZcPrnbxmHkgEhA3z8UqDvp7GTBBTJ9AnVGsPSwzTEW3UM9c3iAk= =zbLG -----END PGP SIGNATURE----- --UTZ8bGhNySVQ9LYl--