Re: Wiki editor request - Mailing list pgsql-www

On 2/6/23 13:40, Jared Brogan wrote:
> Adrian,
>
> I did follow those instructions, it didn't work, otherwise I wouldn't
> have taken the effort of sending the original email.

Hmm, a working example of pgdg.list:

cat /etc/apt/sources.list.d/pgdg.list

deb http://apt.postgresql.org/pub/repos/apt focal-pgdg main
deb https://apt-archive.postgresql.org/pub/repos/apt focal-pgdg-archive main

sudo apt update
[sudo] password for aklaver:

Hit:1 http://mirrors.linode.com/ubuntu focal InRelease
Hit:2 http://mirrors.linode.com/ubuntu focal-updates InRelease

Hit:3 http://mirrors.linode.com/ubuntu focal-backports InRelease

Hit:4 http://apt-longview.linode.com focal InRelease

Hit:5 https://apt-archive.postgresql.org/pub/repos/apt
focal-pgdg-archive InRelease
Get:6 http://security.ubuntu.com/ubuntu focal-security InRelease [114
kB]
Hit:7 http://apt.postgresql.org/pub/repos/apt focal-pgdg InRelease
Get:8 http://security.ubuntu.com/ubuntu focal-security/main amd64 c-n-f
Metadata [12.0 kB]

So what was the exact problem you got?


>
> Regards,
> Jared
>
> On Mon, Feb 6, 2023 at 3:34 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 2/6/23 11:05, Jared Brogan wrote:
>      > To whom it may concern,
>      >
>      > I would like to request the ability to edit and/or have someone
>     edit on
>      > my behalf in order to update the Quickstart section of the Apt
>     wiki page.
>      >
>      >   * https://wiki.postgresql.org/wiki/Apt
>     <https://wiki.postgresql.org/wiki/Apt>
>      >     <https://wiki.postgresql.org/wiki/Apt
>     <https://wiki.postgresql.org/wiki/Apt>>
>      >
>      >
>      > During some very tedious troubleshooting while trying to install
>      > postgresql using the provided repository link, I ran into http 400
>      > errors (`apt update` would produce these, for example). After
>     scouring
>      > various forums, I was able to resolve the issue to my problem by
>     simply
>      > changing http to https within the /etc/apt/sources.list.d/pgdg.list
>      > file. I'd recommend either changing that suggested command to create
>      > said file to include https. An alternative to that, since it
>     apparently
>      > doesn't impact all machines the same way, would be to include a note
>      > below the command stating that users may need to utilize https
>     instead
>      > if connection errors arise.
>      >
>
>     Or follow the instructions from the actual download site:
>
>     https://www.postgresql.org/download/linux/ubuntu/
>     <https://www.postgresql.org/download/linux/ubuntu/>
>
>     or
>
>     https://www.postgresql.org/download/linux/debian/
>     <https://www.postgresql.org/download/linux/debian/>
>
>      > Please let me know if you have any questions or concerns.
>      >
>      > Thanks,
>      > Jared Brogan
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>

--
Adrian Klaver
adrian.klaver@aklaver.com