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 1q1Tdo-0001Cn-6O for pgsql-hackers@arkaria.postgresql.org; Tue, 23 May 2023 15:09:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q1Tdm-000370-0P for pgsql-hackers@arkaria.postgresql.org; Tue, 23 May 2023 15:09:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q1Tdl-00036q-Mj for pgsql-hackers@lists.postgresql.org; Tue, 23 May 2023 15:09:33 +0000 Received: from ma04-relay.lansolnet.com ([176.95.46.38]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q1Tde-001TSM-BS for pgsql-hackers@postgresql.org; Tue, 23 May 2023 15:09:32 +0000 Received: from unknown ([192.168.8.231]) by ma04-relay.lansolnet.com; Tue, 23 May 2023 17:09:20 +0200 Received: from MBX200E.cloud4partner.com (192.168.8.234) by MBX200B.cloud4partner.com (192.168.8.231) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.669.32; Tue, 23 May 2023 17:09:17 +0200 Received: from MBX200E.cloud4partner.com ([fe80::881b:2a52:f04f:d634]) by MBX200E.cloud4partner.com ([fe80::881b:2a52:f04f:d634%13]) with mapi id 15.01.0669.032; Tue, 23 May 2023 17:09:17 +0200 From: Hans Buschmann To: Peter Eisentraut CC: "devrim@gunduz.org" , "mail@joeconway.com" , "robertmhaas@gmail.com" , "andres@anarazel.de" , Tom Lane , "pgsql-hackers@postgresql.org" Subject: Re: drop postmaster symlink Thread-Topic: drop postmaster symlink Thread-Index: AQHZjYadmWfciOjYJU6f8oK+TsbTuQ== Date: Tue, 23 May 2023 15:09:17 +0000 Message-ID: <1c76d7a236f345cfb4ef314e5df5a377@nidsa.net> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.8.240] Content-Type: multipart/alternative; boundary="_000_1c76d7a236f345cfb4ef314e5df5a377nidsanet_" MIME-Version: 1.0 X-cloud-security-sender: buschmann@nidsa.net X-cloud-security-recipient: pgsql-hackers@postgresql.org X-cloud-security-Virusscan: CLEAN X-cloud-security-disclaimer: This E-Mail was scanned by E-Mailservice on ma04-relay.lansolnet.com with E5BEDB80E9F X-cloud-security-connect: unknown[192.168.8.231], TLS=1, IP=192.168.8.231 X-cloud-security: scantime:.3746 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_1c76d7a236f345cfb4ef314e5df5a377nidsanet_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable When creating a private service for another instance of PostgreSQL I used t= he template of postgresql-15.service file installed into /usr/lib/systemd/s= ystem on Fedora 38 provided through the installation for postgres 15.3 from= PGDG repositories. There I noticed that the line ExecStart still uses the postmaster link. I would propose to change it to ExecStart=3D/usr/pgsql-15/bin/postgres -D $(PGDATA) This change should apply also to back branches to avoid using deprecated li= nks in PGDG software. This seems to be necessesary on upcoming PG16. (BTW: where is this all documented?) Hans Buschmann --_000_1c76d7a236f345cfb4ef314e5df5a377nidsanet_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

When creating a private service for another instance of PostgreSQL = I used the template of postgresql-15.service file installed into /usr/= lib/systemd/system on Fedora 38 provided through the installation for postg= res 15.3 from PGDG repositories.


There I noticed that the line ExecStart still uses the postmaster l= ink.


I would propose to change it to

ExecStart=3D/usr/pgsql-15/bin/postgres -D $(PGDATA)


This change should apply also to back branches to avoid using depr= ecated links in PGDG software.

This seems to be necessesary on upcoming PG16.


(BTW: where is this all documented?)


Hans Buschmann

--_000_1c76d7a236f345cfb4ef314e5df5a377nidsanet_--