Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzlAY-0007gm-82 for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 19:51:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzlAW-0001QZ-RI for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 19:51:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzlAW-0001QQ-5h for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 19:51:28 +0000 Received: from aye.elm.relay.mailchannels.net ([23.83.212.6]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzlAT-0001EM-BP for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 19:51:27 +0000 X-Sender-Id: hostpapa|x-authuser|list.pg.gavan@pendari.org Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id 477D7622052; Tue, 21 Dec 2021 19:51:20 +0000 (UTC) Received: from hp309.hostpapa.com (unknown [127.0.0.6]) (Authenticated sender: hostpapa) by relay.mailchannels.net (Postfix) with ESMTPA id 7D852621E09; Tue, 21 Dec 2021 19:51:19 +0000 (UTC) X-Sender-Id: hostpapa|x-authuser|list.pg.gavan@pendari.org Received: from hp309.hostpapa.com (hp309.hostpapa.com [69.90.160.170]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384) by 100.100.11.82 (trex/6.4.3); Tue, 21 Dec 2021 19:51:20 +0000 X-MC-Relay: Neutral X-MailChannels-SenderId: hostpapa|x-authuser|list.pg.gavan@pendari.org X-MailChannels-Auth-Id: hostpapa X-Tank-Print: 6318d09678082e64_1640116280031_2616533034 X-MC-Loop-Signature: 1640116280030:737865343 X-MC-Ingress-Time: 1640116280030 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=pendari.org ; s=default; h=Content-Transfer-Encoding:Content-Type:MIME-Version:References :In-Reply-To:Message-ID:Date:Subject:Cc:To:From:Sender:Reply-To:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:List-Id:List-Help:List-Unsubscribe:List-Subscribe: List-Post:List-Owner:List-Archive; bh=ho5nWt6eecPAaIQXUqNGdqwSHuscaqdXIBqWHeLyV8Y=; b=AHiQGQAuPTJD+oiZJPSv3XBxIw jm2gFtUlWu7S9gaydFzOv34l4ETSJ969ogI9q3K58XfRQR+TiqqNfVPlYpD7LgeX7p4vMCvbpdT7H DWzMew9h/AfwMwv9lfC9c1Tv9ANpYYHv0BMFHyo+vXpSDrqgGkv/gR6wzC2P6WAjuoYT6zMoqgijK Hh4QLTseqdSjv538Pk6BZTpPUjU89Mj9WUI1NIGyAR4d9ZXAnN+2YeSnkhcAH9mRk7emBtOkgQpyz QmsxOmSF+Wztip4opiH+QOkyuNO063pZmY2qCXAqFv/I1ddFH8oWCaW+T6dSoLjxyyMcSc0q1GXgE JQTZ8UaA==; Received: from [103.152.126.17] (port=63428 helo=[192.168.20.22]) by hp309.hostpapa.com with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1mzlAM-00HTB2-Eg; Wed, 22 Dec 2021 06:51:18 +1100 From: Gavan Schneider To: Holger Jakobs Cc: pgsql-admin@lists.postgresql.org, "Gogala, Mladen" Subject: Re: Reconfiguring active PostgreSQL instance Date: Wed, 22 Dec 2021 06:51:02 +1100 X-Mailer: MailMate (1.14r5853) Message-ID: <7FFC1417-E191-4BB3-94BA-4A83D954C750@pendari.org> In-Reply-To: References: <9b0a5879-1ad9-98db-e18b-5576542dad6b@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-AuthUser: list.pg.gavan@pendari.org List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 22 Dec 2021, at 2:33, Holger Jakobs wrote: > The path looks like it's a very unconventional installation. Usually, i= t should be something like /usr/local/... if it's on a unixoide system. > > Maybe it's a Mac. This should be mentioned in the question. > FWIW Mac is BSD Unix making /usr/local/=E2=80=A6 the place to put postgre= s etc. As mentioned by OP the installation is custom so they may not have follow= ed this convention on their *nix system, and, taking macOS as an example,= installations into non standard directories can come against security fe= atures. Regards Gavan Schneider =E2=80=94=E2=80=94 Gavan Schneider, Sodwalls, NSW, Australia Explanations exist; they have existed for all time; there is always a wel= l-known solution to every human problem =E2=80=94 neat, plausible, and wr= ong. =E2=80=94 H. L. Mencken, 1920