Re: extract properties from certificates

I could compile the pg-cert extension package, but postgresql 9.6
refused to install it.

create extension cert;
FEHLER: geschachteltes CREATE EXTENSION wird nicht unterstützt
means "ERROR: nested CREATE EXTENSION is not supported"

At line 12 in /usr/share/postgresql/9.6/extension/cert--0.1.1.sql
another extension called bignum is created.
As a short try, I tryed to install in seperatly. I commentent that out,
git cloned the https://github.com/beargiles/pg-bignum project, make and
make install leads to an error, but the extension files are available in
the extensions directory:

sudo make install
/bin/mkdir -p '/usr/share/postgresql/9.6/extension'
/bin/mkdir -p '/usr/share/postgresql/9.6/extension'
/bin/mkdir -p '/usr/lib/postgresql/9.6/lib'
/bin/mkdir -p '/usr/share/doc/postgresql-doc-9.6/extension'
/usr/bin/install -c -m 644 .//bignum.control
'/usr/share/postgresql/9.6/extension/'
/usr/bin/install -c -m 644 .//sql/bignum--0.8.0.sql
.//sql/bignum--0.8.0.sql '/usr/share/postgresql/9.6/extension/'
/usr/bin/install: Neu erstelltes
'/usr/share/postgresql/9.6/extension/bignum--0.8.0.sql' wird nicht mit
'.//sql/bignum--0.8.0.sql' überschrieben.
/usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk:114: die Regel
für Ziel „install“ scheiterte
make: *** [install] Fehler 1

I could not create the bignum extension in my database:

create extension bignum;
FEHLER: konnte nicht auf Datei »bignum« zugreifen: Datei oder
Verzeichnis nicht gefunden
means "ERROR: could not access file "bignum": File or directory not found"

Has anybody anybody an idea, how to fix this,
or maybe another aproach to extract properties from X.509 certificates?

Beste Regards Johannes

Am 24.02.2018 um 19:07 schrieb jotpe:
>
>
> Am 24.02.2018 um 16:58 schrieb Tom Lane:
>> jotpe <jotpe(at)posteo(dot)de> writes:
>>> I found the pg-cert extension at https://github.com/beargiles/pg-cert
>>> I have trouble to compile it. When I enter "make" following error
>>> message appears:
>>> Makefile:29: /usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk:
>>> Datei oder Verzeichnis nicht gefunden
>>> make: *** Keine Regel, um
>>> „/usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk“ zu erstellen.
>>> Schluss.
>>
>>> What am I missing?
>>
>> I'd expect pgxs.mk to be packaged in a postgresql-devel (or
>> postgresql-dev, depending on local culture) subpackage.  Maybe you didn't
>> install that?
>
> Guessed right. postgresql-server-dev-all for debian 9 did it. Thanks.
>
>>             regards, tom lane
>>
>