<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/vnd.ui.insecure+html;charset=utf-8">
</head>
<body style="overflow-wrap:break-word; word-break: break-word;"><div class="mail_android_message" style="line-height: 1; padding: 0.5em">Hello<br/><br/>I have made some deeper investigation:<br/><br/>Steps to reproduce:<br/><br/>```<br/>docker pull ubuntu:18.04 && docker run -it --rm ubuntu:18.04 bash<br/>## or<br/>docker pull ubuntu:20.04 && docker run -it --rm ubuntu:20.04 bash<br/>## or<br/>docker pull ubuntu:22.04 && docker run -it --rm ubuntu:22.04 bash<br/><br/><br/>apt-get update<br/>apt-get install -y vim strace less curl ca-certificates gnupg sudo lsb-release<br/><br/>curl <a href="https://www.postgresql.org/media/keys/ACCC4CF8.asc">https://www.postgresql.org/media/keys/ACCC4CF8.asc</a> | gpg --dearmor | sudo tee /etc/apt/<a href="http://trusted.gpg">trusted.gpg</a>.d/<a href="http://apt.postgresql.org.gpg">apt.postgresql.org.gpg</a> >/dev/null<br/><br/>sh -c 'echo "deb <a href="http://apt.postgresql.org/pub/repos/apt">http://apt.postgresql.org/pub/repos/apt</a> $(lsb_release -cs)-pgdg main" > /etc/apt/<a href="http://sources.list">sources.list</a>.d/<a href="http://pgdg.list">pgdg.list</a>'<br/>apt-get update<br/>apt-get install -y postgresql-12<br/><br/>pg_ctlcluster 12 main start<br/><br/>sudo -u postgres -i<br/>psql<br/>CREATE DATABASE database_name;<br/>CREATE USER my_username WITH PASSWORD 'my_password';<br/>GRANT ALL PRIVILEGES ON DATABASE "database_name" to my_username;<br/>exit<br/><br/>echo '*:*:*:my_username:my_password' > .pgpass<br/>chmod 0600 .pgpass<br/>exit<br/><br/>##<br/>## this does not work for ubuntu 18.04 but for ubuntu 20.04/22.04<br/>##<br/>/usr/bin/sudo -u postgres psql -U my_username -h <a href="http://127.0.0.1">127.0.0.1</a> database_name -c "CREATE TABLE foo (foo char);"<br/><br/>##<br/>## this works for all<br/>##<br/>sudo -u postgres -i<br/>psql -U my_username -h <a href="http://127.0.0.1">127.0.0.1</a> database_name -c "CREATE TABLE foo (foo char);"<br/>```<br/><br/>We have narrowed it down to three packages which have been upgraded on ubuntu 18.04 between working and broken state:<br/>- `libpq5` upgraded from `14.5-1.pgdg18.04+1` to `15.0-1.pgdg18.04+1`<br/>- `postgresql-client-common` and `postgresql-common` from `243.pgdg18.04+1` to `244.pgdg18.04+1`<br/><br/>None other packages have been upgraded (incl. ubuntu repo packages)!<br/><br/>For me it does look like a bug with in psql client package.<br/><br/>regards<br/>Mike<br/><br/>--<br/>Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.</div><div class="mail_android_quote" style="line-height: 1; padding: 0.3em"><html><body>Am 17.10.22, 16:19 schrieb PG Bug reporting form <noreply(at)postgresql(dot)org>:</body></html><blockquote class="gmail_quote" style="margin: 0.8ex 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
The following bug has been logged on the website:
<br>
<br> Bug reference: 17647
<br> Logged by: Mike Fröhner
<br> Email address: mikefroehner(at)gmx(dot)de
<br> PostgreSQL version: 12.12
<br> Operating system: Ubuntu 18.04
<br> Description:
<br>
<br> Hello,
<br>
<br> today our CI noticed the upgrade of PostgreSQL to 12.12. We have a CI/CD
<br> which tests our Puppet Module against Ubuntu 16./18./20./22.04. We run
<br> different tests (kitchen-ci) including the following:
<br> ```
<br> describe command('/usr/bin/sudo -u postgres psql -U myuser1 -h 127.0.0.1
<br> mydb1 -c "CREATE TABLE foo (foo char);"') do
<br> its('exit_status') { should eq 0 }
<br> its('stdout') { should eq "CREATE TABLE\n" }
<br> its('stderr') { should eq '' }
<br> end
<br> ```
<br> Therefore we rollout a DB and a user via:
<br> ```
<br> postgresql::databases:
<br> 'mydb1':
<br> user: myuser1
<br> password: mypassword1
<br> host: 127.0.0.1/32
<br> ```
<br> We also rollout a file:
<br> ```
<br> '/var/lib/postgresql/.pgpass':
<br> owner: postgres
<br> group: postgres
<br> mode: '0600'
<br> content: '*:*:*:myuser1:mypassword1'
<br> require_class: postgresql
<br> ```
<br> This test only fails/times out on Ubuntu 18.04 because it is waiting for a
<br> password input. With all other Ubuntu (16./20./22.04) this test succedds. Is
<br> there anything wrong with my test or is the package for Ubuntu 18.04 broken?
<br>
<br>
</blockquote></div></body>
</html>