From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | jotpe <jotpe(at)posteo(dot)de>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: extract properties from certificates |
Date: | 2018-02-25 15:42:03 |
Message-ID: | 539ae824-fe5d-0942-e438-133b67b105fe@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/25/2018 12:26 AM, jotpe wrote:
> 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?
See here:
https://github.com/beargiles/pg-bignum/pull/3
in particular:
https://github.com/beargiles/pg-bignum/pull/3/commits/d496a091929b15dbc0cc6ece40b0ba7bf091c8ec
which changes line 21 in Makefile from
DATA = $(wildcard sql/*--*.sql) sql/$(EXTENSION)--$(EXTVERSION).sql
to
DATA = $(wildcard sql/*--*.sql)
This should eliminate this:
/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
and allow the install to complete.
>
> 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
>>>
>>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2018-02-25 17:28:27 | Re: == PostgreSQL Weekly News - January 28 2018 == |
Previous Message | jotpe | 2018-02-25 08:26:22 | Re: extract properties from certificates |