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 1sOxP1-002AUk-NU for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 03 Jul 2024 10:39: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 1sOxOz-007g4A-Nz for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 03 Jul 2024 10:39:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOxOz-007g41-Hv for pgsql-pkg-debian@lists.postgresql.org; Wed, 03 Jul 2024 10:39:54 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOxOx-000BbW-72 for pgsql-pkg-debian@postgresql.org; Wed, 03 Jul 2024 10:39:52 +0000 Received: from msg.df7cb.de (unknown [IPv6:2a02:908:1480:91e0:e5dd:5ff4:a196:e226]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature ECDSA (P-384) server-digest SHA384) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 4WDbrP48kvz3F6d; Wed, 3 Jul 2024 12:39:49 +0200 (CEST) Date: Wed, 3 Jul 2024 12:39:51 +0200 From: Christoph Berg To: Greg Smith Cc: pgsql-pkg-debian@postgresql.org Subject: Re: PostGIS files for PG17-b2 Message-ID: Mail-Followup-To: Christoph Berg , Greg Smith , pgsql-pkg-debian@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Re: Greg Smith > I was able to do all the other upgrade steps as the postgres user. If the > temporary binaries were installed in the postgres user's home directory > instead, the whole thing might be possible to do as postgres. The fix I applied is similar: just chown the /var/tmp/postgresql-* directory to postgres. https://salsa.debian.org/postgresql/postgresql-common/-/commit/f8061293088292fb5a08d49cd364a298bf15e1a9 Thanks, Christoph