Re: Aw: BUG #17647: 12.12 package has difference on ubuntu 18.04 - Mailing list pgsql-bugs
| From | Julien Rouhaud |
|---|---|
| Subject | Re: Aw: BUG #17647: 12.12 package has difference on ubuntu 18.04 |
| Date | |
| Msg-id | Y06fn/2t3y6cp5VQ@jrouhaud Whole thread Raw |
| In response to | BUG #17647: 12.12 package has difference on ubuntu 18.04 (PG Bug reporting form <noreply@postgresql.org>) |
| Responses |
Re: BUG #17647: 12.12 package has difference on ubuntu 18.04
|
| List | pgsql-bugs |
Hi, On Tue, Oct 18, 2022 at 10:19:20AM +0200, Mike Fröhner wrote: > > <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/>dockerpull ubuntu:18.04 && docker run -it --rm ubuntu:18.04 bash<br/>## or<br/>dockerpull 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 curlca-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-getupdate<br/>apt-get install -y postgresql-12<br/><br/>pg_ctlcluster12 main start<br/><br/>sudo -u postgres -i<br/>psql<br/>CREATE DATABASE database_name;<br/>CREATEUSER 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/>chmod0600 .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 (foochar);"<br/>```<br/><br/>We have narrowed it down to three packages which have been upgraded on ubuntu 18.04 betweenworking 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 packageshave 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/>DieseNachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.</div><divclass="mail_android_quote" style="line-height: 1; padding: 0.3em"><html><body>Am 17.10.22, 16:19 schriebPG Bug reporting form <noreply@postgresql.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;"> You should configure your MUA to send plaintext too and not only html, as some 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?
pgsql-bugs by date: