Installing PostgreSQL 9.4: "gpg: no valid OpenPGP data found"

Question

I'm trying to install PostgreSQL 9.4 on a clean, new Debian Jessie machine.

I'm following these instructions: https://wiki.postgresql.org/wiki/Apt#Quickstart

When I get to this point:

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -

I get this error:

gpg: no valid OpenPGP data found.

What am I doing wrong?

Split that command and verify what you're getting is the actual key and not some connection error. — Jakub Kania
– Jakub Kania, Commented Aug 13, 2015 at 17:33
Side note: Debian Jessie already ships PostgreSQL 9.4, do you really need to build on your own? Testing/unstable usually ship very bleeding edge versions, these might be a better way to go instead of building on your own (updates included). — Jens Erat
– Jens Erat, Commented Aug 13, 2015 at 19:55
@JensErat thanks. I ended up just using apt to install it, much easier! — Richard
– Richard, Commented Aug 14, 2015 at 8:22
yep but in Jessie you have 9.4 (and magnificiant JSONB type so you can apt-get remove mongodb !), but still miss 9.5 (and it's more than welcome UPSERT capabilities !) — comte
– comte, Commented Mar 11, 2016 at 13:35

Community · Accepted Answer · 2017-05-23 11:44:07Z

2

These instructions are fine, you must suffer from connection problems (or get other contents served than expected. Do following:

Run wget -o - https://www.postgresql.org/media/keys/ACCC4CF8.asc (without --quiet and without pipe to GnuPG) to inspect what's actually happening. Is wget indicating any connection problems?
You can also download the file from your browsers, simply store the textual contents using copy-paste to a text file and import it using apt-key add [path-to-file] (or, given somebody finding this question wants to import to the default GnuPG keyring, gpg --import < [path-to-file]).

Most likely wget does not find the root certificated referenced by the PostgreSQL website, you're behind some proxy which is not configured for wget or a gateway changing the website; at least the results returned are not key data in a format GnuPG expects.

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Aug 13, 2015 at 19:53

Jens Erat

39k16 gold badges86 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jessedc Over a year ago

This is a good answer. Running wget without --quiet and without the pipe to GnuPG will show more details on the issue, and wget will often suggest a solution (eg: --no-check-certificate)

Ektor · Accepted Answer · 2016-05-14 13:34:12Z

2

In my case the problem was caused by an incorrect https certificate from postgresql.

Just add the --no-check-certificate to the wget command.

answered May 14, 2016 at 13:34

Ektor

1631 silver badge7 bronze badges

1 Comment

Jens Erat Over a year ago

If you disable wget's certificate validation, a man in the middle attacker might not only send you with a manipulated PostgreSQL package (and other system packages!), but also provide a seemingly valid certificate. If fetching from HTTPs is your only trust anchor, do at least not disable certificate checks without understanding why they failed.

Collectives™ on Stack Overflow

Installing PostgreSQL 9.4: "gpg: no valid OpenPGP data found"

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related