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 1oklxJ-0004mN-7t for pgsql-bugs@arkaria.postgresql.org; Tue, 18 Oct 2022 12:44:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oklxI-0002B0-1h for pgsql-bugs@arkaria.postgresql.org; Tue, 18 Oct 2022 12:44:24 +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 1oklxH-0002Ap-Ng for pgsql-bugs@lists.postgresql.org; Tue, 18 Oct 2022 12:44:23 +0000 Received: from mail-pf1-x431.google.com ([2607:f8b0:4864:20::431]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oklxF-0002v1-8O for pgsql-bugs@lists.postgresql.org; Tue, 18 Oct 2022 12:44:22 +0000 Received: by mail-pf1-x431.google.com with SMTP id h13so13959370pfr.7 for ; Tue, 18 Oct 2022 05:44:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=8ejMcsGrM/UnPwE960yM8vg0yP7u1BbDLzmQ/AP7t0s=; b=LG+RKT3UvZ1fD0XnBrb/O2E/5CHFOik+iCUCJYvvEc1F5veYFr44qbKMcKm458k6Qt P/1gEBa9LE0Wtc91dmOTtF7gXgDOwJ5EbY1P5hl4tum0amZQaT0qDV850cLm0FecUiC+ XmbPEjklC+ByqtngYcSAaI7vTv9wgOZXIP7wJtMXeJOknhrh6w6O57SmlY6xNav8FtgQ HRWpW7Iw8U3Qx7z/1R3VdB2Be4NUMBRkQfXbAAhB37L6Bjrt07jWE8us/V3dzZvBWwHg SnqVe7GDeUkYCPGWRu2UbVmbukJxoeTbSEjQIbuXpsCW7rXxsqE05pYA2HrE1yzv44+Y UXEA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=8ejMcsGrM/UnPwE960yM8vg0yP7u1BbDLzmQ/AP7t0s=; b=mon2mrkiBfK5CIb3656LjgYaD8ZldRB8FxJVeFSqxaE8aq9LjovVCrUu5SoNsz4x6P DWjuUGt6tBMSLQxitjCHErCTNOh9GC9KWn3Up6F0PJO///ar3UMDzXgStKrODQbRd+bO Hksh9ap+lTQHYldjyjVJU+/jr+9lgQziNRAOnYN+20M00oOZOKnfjVEVVniqbsSdI4xH MjF5LGUD4+kO8kxCJ6qZCUBxOcJXEcqZoUhXutqNAr29exRTrmFiTu2lEAum9aIJS8b0 wG6NMqLQ2hat83Meksf/CGuIg+iestxzTvHL2EWe3tN6u8M8nkRIYhxp0nGVDPXIMWs4 PgTA== X-Gm-Message-State: ACrzQf0QzbmaIP9d+q3GRPkVh9xI9Ls2WpLv9F+tqQg8d7ajg5AuktYk KG82LUHcVn8+8C3GH6qq3xE= X-Google-Smtp-Source: AMsMyM6+IcASCFDwCLR8Tf9JcfWjjPuH1nbrZ7iKCrjqV5La2bAoUi0Lzg0Nm2Q3FUeTabBFj5VFLA== X-Received: by 2002:a63:82c6:0:b0:460:a691:356 with SMTP id w189-20020a6382c6000000b00460a6910356mr2452898pgd.621.1666097059676; Tue, 18 Oct 2022 05:44:19 -0700 (PDT) Received: from jrouhaud (2001-b011-1006-1ebe-d832-ef37-671f-0ce2.dynamic-ip6.hinet.net. [2001:b011:1006:1ebe:d832:ef37:671f:ce2]) by smtp.gmail.com with ESMTPSA id y34-20020a17090a53a500b00210039560c0sm86593pjh.49.2022.10.18.05.44.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 18 Oct 2022 05:44:19 -0700 (PDT) Date: Tue, 18 Oct 2022 20:44:15 +0800 From: Julien Rouhaud To: Mike =?iso-8859-1?Q?Fr=F6hner?= Cc: pgsql-bugs@lists.postgresql.org Subject: Re: =?iso-8859-1?B?QXc6oEJV?= =?iso-8859-1?Q?G?= #17647: 12.12 package has difference on ubuntu 18.04 Message-ID: References: <17647-355ab16b3ab3c775@postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Tue, Oct 18, 2022 at 10:19:20AM +0200, Mike Fr=F6hner wrote: >=20 > > > > > >
Hell= o

I have made some deeper investigation:

Steps to reprodu= ce:

```
docker pull ubuntu:18.04 && docker run -it --r= m ubuntu:18.04 bash
## or
docker pull ubuntu:20.04 && docke= r run -it --rm ubuntu:20.04 bash
## or
docker pull ubuntu:22.04 &am= p;& docker run -it --rm ubuntu:22.04 bash


apt-get update<= br/>apt-get install -y vim strace less curl ca-certificates gnupg sudo lsb-= release

curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --de= armor | sudo tee /etc/apt/trusted.gpg.d/= apt.postgresql.org.gpg >/d= ev/null

sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_rel= ease -cs)-pgdg main" > /etc/apt/sou= rces.list.d/pgdg.list'
apt-get= update
apt-get install -y postgresql-12

pg_ctlcluster 12 main= start

sudo -u postgres -i
psql
CREATE DATABASE database_n= ame;
CREATE USER my_username WITH PASSWORD 'my_password';
G= RANT ALL PRIVILEGES ON DATABASE "database_name" to my_username;exit

echo '*:*:*:my_username:my_password' > .pgpass<= br/>chmod 0600 .pgpass
exit

##
## this does not work for u= buntu 18.04 but for ubuntu 20.04/22.04
##
/usr/bin/sudo -u postgres= psql -U my_username -h 127.0.0.1 database= _name -c "CREATE TABLE foo (foo char);"

##
## this w= orks for all
##
sudo -u postgres -i
psql -U my_username -h 127.0.0.1 database_name -c "CREATE TABLE = foo (foo char);"
```

We have narrowed it down to three pa= ckages which have been upgraded on ubuntu 18.04 between working and broken = state:
- `libpq5` upgraded from `14.5-1.pgdg18.04+1` to `15.0-1.pgdg18.= 04+1`
- `postgresql-client-common` and `postgresql-common` from `243.pg= dg18.04+1` to `244.pgdg18.04+1`

None other packages have been upgr= aded (incl. ubuntu repo packages)!

For me it does look like a bug = with in psql client package.

regards
Mike

--
Dies= e Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.
Am 17.10.22, 16:19 schrieb PG Bug reporting form <noreply= @postgresql.org>:
You should configure your MUA to send plaintext too and not only html, as s= ome people can't (and don't want to) read html-only emails. After reading it on the html archives, I'm surprised to see that this would work at all on other ubuntu versions, and it doesn't look like a bug in our code. sudo without = -i will look for the .pgpass in the wrong place: # sudo -u postgres bash -c "echo \$HOME" /root # sudo -iu postgres bash -c "echo \$HOME" /var/lib/postgresql Do you get a different behavior for those commands on other ubuntu versions?