Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qLJaF-002oiA-An for pgsql-docs@arkaria.postgresql.org; Mon, 17 Jul 2023 08:27:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qLJaD-006pnA-6J for pgsql-docs@arkaria.postgresql.org; Mon, 17 Jul 2023 08:27:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qLJaC-006pn2-VZ for pgsql-docs@lists.postgresql.org; Mon, 17 Jul 2023 08:27:52 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qLJaB-0011qV-4e for pgsql-docs@lists.postgresql.org; Mon, 17 Jul 2023 08:27:52 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id B34E5320084E; Mon, 17 Jul 2023 04:27:48 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Mon, 17 Jul 2023 04:27:48 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm3; t=1689582468; x=1689668868; bh=Tl XdcEBtWT2fRMMNwddZ5LnWqcUSSt10X4TLBYYtYbY=; b=JOTSJoPMwVeTWiueB6 jYWIXYMceQDb0rxcwQH0G0aQAGnpdQClY8Mf8aOhWPnee1h5WtnLzV007+gw/KFF /Oh7k6pztGZfgkW5q8bZKX21qspu/YJpPc+3o0/BXy56hh4Hrqx2JIJMVN/O4Pnn 0SwADH9vvNuQAYTIamH2XGNi7vUoMgD/FP8D/P+cQMm3OylMHdRZsTWKNC+O2+9K hLfl/oFP8mLSFaC4aP2/jx9c6FR6uUqwm3etopUNoAf4o8s0RNuFfM77i9xl6sbj odZO0pIOqOx4ZcA+peTWEI6F9p+VlsAZJL5R3CO/gWJc96ybiR0VaxJokWSiSyvC 1fCw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1689582468; x=1689668868; bh=TlXdcEBtWT2fR MMNwddZ5LnWqcUSSt10X4TLBYYtYbY=; b=aXOntIPhVbGvyi74tETr8NpZiY4RS WyYw/teebseQRI17INTPgrFN6P8Qi996m7w+ZJOSkWW6qtrqzyCxRrkbjMovZirk YBKzPby7aCChGRPGePlz0RTJt1zkHElLYEud/7pEPqV4YhATBJGcaNWl0Vs543Ay vcEaDOVwzeRHqcc8D2mio+Z5Qge1bbFLaZqgYKUvKC57CEmsuJFHcc5iuUIwQlap X6X6uAX57ZxfT445F5TwcPAs9KgmgqkBqKQAmWmVQlzuV3x9+YhNCptoH1cuQqd2 PPf/EjFTYziefu/pS5WWnBeho/EeEpQXdukS+A9tbe2JUXwqOOERQu9GA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrgedvgddtgecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnh epvdegudeuhfdtueeltedtveejheehieevueeigeelteegleejleeiueeiheegvefhnecu vehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrg gvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 17 Jul 2023 04:27:46 -0400 (EDT) Date: Mon, 17 Jul 2023 17:27:43 +0900 From: Michael Paquier To: rahimullah.shaheen281@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: Improvement of clarity in pg_ctl command docummentation Message-ID: References: <168940066069.41161.1605487621936927399@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="T4VXCwfBZYPq6Nnf" Content-Disposition: inline In-Reply-To: <168940066069.41161.1605487621936927399@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --T4VXCwfBZYPq6Nnf Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Jul 15, 2023 at 05:57:40AM +0000, PG Doc comments form wrote: > I was reading the documentation about pg_ctl and there everything was well > written about the usage and option that can be used with the pg_ctl command > but there is not mentioned that we can not run pg_ctl command as root and > why we cant run it as root. Yes, I guess that you are right in the fact that we don't document pg_ctl cannot be run as root. The short explanation behind this restriction is that the PostgreSQL backend is considered as having the same rights as the OS user running it, and we don't want to encourage unsecure behaviors where systems could be easily compromised. -- Michael --T4VXCwfBZYPq6Nnf Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmS0+38ACgkQnvQgOdby QH2K4A//XwXMp6uWF7GUcvCIhtH+HFyr8MKjRjhjJh1QKk4Hk1/d23rIWYYbRD8d hgVmFy9qlfvT3zfxcIn37thwM7TNc8grRj7H0FEGsTEWq579ZQrSa9lqLblAG4jS 5CL4S8Pg8aUOCXm82+5UUXfcr29xP6QbmiO2K2Gon3uN/nNyVX80rKZ0KSqIWGlT 7tMcfRnQvf87JT1LmrV5yGVIAg2kHEbrk5Nt16wcMWleE00Qnyi+zGKd3tPtT7iE SKBfAx6X0QlKE3ACiyHBH2pURr+yrEpY+Za/gAiOhYo/v12AufBwKe9uiqryPXRS 8dMzqx6zniA+lwVpOkJ/zPIj6+Van6j5EEONWp2a45wZvQ6a6fWTO4lamdr9E2lB futEusUZnAVJjArhU9v0+NMBR6xj6Pj29fQ0nGejrAFaoeFJ1XaNIS5zGMfRJZTm CXqECdiZigqygp2OP3jM3xyPpjCFYfxghAH1e+MIHRFq8X8Do3eKkToYu9jM97VO IdP5upzQkYrHXoFkDGBNt0BrthholzJhWg8bpFC0Bw7MvpVE5eISrh7TnydE1i3d 2sza6gEJ2bngwM+ESiiyMpT4DDiKaMMKtFSfNa6ckzfOZjPFbqNaZk8vTPQhye2n Vn5Od8NwENvk/1cBsIAnOWOuwA/eN4DysJ3FQS86tWGypqEV8JI= =d6Qg -----END PGP SIGNATURE----- --T4VXCwfBZYPq6Nnf--