BUG #16995: Need repository key to access old distributions from https://apt-archive.postgresql.org/

Started by PG Bug reporting formalmost 5 years ago3 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 16995
Logged by: Marc Moy
Email address: moymarc453@gmail.com
PostgreSQL version: 9.6.21
Operating system: Ubuntu
Description:

We are running into errors when installing Postgres 9.6 on Ubuntu. We
noticed the distributions hosted on `http://apt.postgresql.org` was
returning 404 so we changed our installation scripts to refer to
`https://apt-archive.postgresql.org/` instead as described here:
/messages/by-id/YBMtd6nRuXyU2zS4@msg.df7cb.de

However, we are now running into the following error now:
```
16:40:34 WARNING: The following packages cannot be authenticated!
16:40:34 libpq5 libpq-dev pgdg-keyring postgresql-client-common
postgresql-client-9.6
16:40:34 postgresql-common postgresql-9.6 postgresql-contrib-9.6
```

We believe its because the repository key we are using does not apply
anymore for the new `apt-archive` host. For reference, here is the
repository key we are using:
http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc

Could someone please advise what the new repository key is for
https://apt-archive.postgresql.org/?

Thanks

#2Christoph Berg
myon@debian.org
In reply to: PG Bug reporting form (#1)
Re: BUG #16995: Need repository key to access old distributions from https://apt-archive.postgresql.org/

Re: PG Bug reporting form

We are running into errors when installing Postgres 9.6 on Ubuntu. We
noticed the distributions hosted on `http://apt.postgresql.org` was
returning 404 so we changed our installation scripts to refer to
`https://apt-archive.postgresql.org/` instead as described here:
/messages/by-id/YBMtd6nRuXyU2zS4@msg.df7cb.de

However, we are now running into the following error now:
```
16:40:34 WARNING: The following packages cannot be authenticated!
16:40:34 libpq5 libpq-dev pgdg-keyring postgresql-client-common
postgresql-client-9.6
16:40:34 postgresql-common postgresql-9.6 postgresql-contrib-9.6
```

Which Ubuntu version is that?

Christoph

#3Christoph Berg
myon@debian.org
In reply to: PG Bug reporting form (#1)
Re: BUG #16995: Need repository key to access old distributions from https://apt-archive.postgresql.org/

Re: M M

Codename: precise

However, I believe we solved the issue on our end. Looks like we messed up
on our `deb` command. Apologies for the false alarm,

Ack, thanks for the feedback.

Christoph