MIME-Version: 1.0
From: John Zajac <jzajac2@gmail.com>
Date: Mon, 23 Aug 2021 11:07:27 -0500
Message-ID: 
 <CAD_7TLJH0HL1-QELiB6NX8qjwHCA_kjzYVpfqvZT__CTz60S6A@mail.gmail.com>
Subject: How to Install postgresql-client-11 on Ubuntu 18.04?
To: pgsql-pkg-debian@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000052a3d805ca3c3721"
Archived-At: 
 <https://www.postgresql.org/message-id/CAD_7TLJH0HL1-QELiB6NX8qjwHCA_kjzYVpfqvZT__CTz60S6A%40mail.gmail.com>
Precedence: bulk

--00000000000052a3d805ca3c3721
Content-Type: text/plain; charset="UTF-8"

on ubuntu 18.04, I'm trying to upgrade pg client, to v11 (although open to
greater versions assuming backward compatibility) to get around this issue:
pg_dump: server version: 11.10; pg_dump version: 9.3.24
pg_dump: aborting because of server version mismatch

my steps so far have been to follow the quickstart from here:
https://wiki.postgresql.org/wiki/Apt , which is..:

Import the repository key from
*https://www.postgresql.org/media/keys/ACCC4CF8.asc
<https://www.postgresql.org/media/keys/ACCC4CF8.asc>*:

sudo apt install curl ca-certificates gnupg
curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg
--dearmor | sudo tee /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg
>/dev/null

Create */etc/apt/sources.list.d/pgdg.list*. The distributions are called
*codename**-pgdg*. In the example, replace *buster* with the actual
distribution you are using. File contents:

deb http://apt.postgresql.org/pub/repos/apt *buster*-pgdg main

(You may determine the codename of your distribution by running *lsb_release
-c*). For a script version of the above file creation, presuming you are
using a supported release:

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt
$(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

Finally, update the package lists, and start installing packages:

sudo apt update

 and from here:

sudo apt install postgresql-client-11


However I get:
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package postgresql-11


is client v11 supported on ubuntu 18.04? If yes, does anyone have steps?

-- 
-John

--00000000000052a3d805ca3c3721
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">on ubuntu 18.04, I&#39;m trying to upgrade pg client, to v=
11 (although open to greater versions assuming backward compatibility) to g=
et around this issue:<br>
pg_dump: server version: 11.10; pg_dump version: 9.3.24<br><div> pg_dump: a=
borting because of server version mismatch <br></div><div><br></div><div>my=
 steps so far have been to follow the quickstart from here: <a href=3D"http=
s://wiki.postgresql.org/wiki/Apt">https://wiki.postgresql.org/wiki/Apt</a> =
, which is..:<br>
<p>Import the repository key from <b><a rel=3D"nofollow" class=3D"external =
gmail-free" href=3D"https://www.postgresql.org/media/keys/ACCC4CF8.asc">htt=
ps://www.postgresql.org/media/keys/ACCC4CF8.asc</a></b>:
</p>
<pre>sudo apt install curl ca-certificates gnupg
curl <a href=3D"https://www.postgresql.org/media/keys/ACCC4CF8.asc">https:/=
/www.postgresql.org/media/keys/ACCC4CF8.asc</a> | gpg --dearmor | sudo tee =
/etc/apt/trusted.gpg.d/apt.postgresql.org.gpg &gt;/dev/null
</pre>
<p>Create <b>/etc/apt/sources.list.d/pgdg.list</b>. The distributions are c=
alled <i>codename</i><b>-pgdg</b>. In the example, replace <i>buster</i> wi=
th the actual distribution you are using.  File contents:
</p>
<pre>deb <a href=3D"http://apt.postgresql.org/pub/repos/apt">http://apt.pos=
tgresql.org/pub/repos/apt</a> <b>buster</b>-pgdg main
</pre>
<p>(You may determine the codename of your distribution by running <b>lsb_r=
elease -c</b>). For a script version of the above file creation, presuming =
you are using a supported release:
</p>
<pre>sudo sh -c &#39;echo &quot;deb <a href=3D"http://apt.postgresql.org/pu=
b/repos/apt">http://apt.postgresql.org/pub/repos/apt</a> $(lsb_release -cs)=
-pgdg main&quot; &gt; /etc/apt/sources.list.d/pgdg.list&#39;
</pre>
<p>Finally, update the package lists, and start installing packages:
</p>
<pre>sudo apt update<br><br>
</pre>

</div><div>and from here:
<pre><span class=3D"gmail-js-about-item-abstr"><pre class=3D"gmail-prettypr=
int gmail-prettyprinted"><code><span class=3D"gmail-pln">sudo apt install p=
ostgresql</span><span class=3D"gmail-pun">-</span><span class=3D"gmail-pln"=
>client</span><span class=3D"gmail-pun">-</span><span class=3D"gmail-lit">1=
1</span></code></pre></span><br><br></pre>However I get:<br>Reading package=
 lists... Done<br>Building dependency tree =C2=A0 =C2=A0 =C2=A0 <br>Reading=
 state information... Done<br>E: Unable to locate package postgresql-11</di=
v><div><br></div><div><br></div><div>is client v11 supported on ubuntu 18.0=
4? If yes, does anyone have steps?</div><div><br></div><div>-- <br><div dir=
=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div =
dir=3D"ltr"><div>-John</div></div></div></div></div>

--00000000000052a3d805ca3c3721--