Feedback-ID: i76984098:Fastmail
Message-ID: <9559c049-aa2a-54eb-e581-2408829a4509@aklaver.com>
Date: Mon, 6 Feb 2023 13:46:47 -0800
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.6.1
Subject: Re: Wiki editor request
Content-Language: en-US
To: Jared Brogan <jaredbrogan@gmail.com>
Cc: pgsql-www@postgresql.org
References: 
 <CANk56d1xx6FAE6nr41TFFxBvb0CYDz+rxJj_Tp-J2yeUbNX2Tw@mail.gmail.com>
 <549996ea-8d15-0c53-f7ca-d60f63b10722@aklaver.com>
 <CANk56d3pRu-6m4v8SXQcufJOFuZwcWSVnx11vz0yFeuGD91=9g@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: 
 <CANk56d3pRu-6m4v8SXQcufJOFuZwcWSVnx11vz0yFeuGD91=9g@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/9559c049-aa2a-54eb-e581-2408829a4509%40aklaver.com>
Precedence: bulk

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