Am 25.02.2018 um 16:42 schrieb Adrian Klaver:
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.
That worked. Thank you!
Beste Regards Johannes
Am 24.02.2018 um 19:07 schrieb jotpe:
Am 24.02.2018 um 16:58 schrieb Tom Lane:
jotpe <jotpe@xxxxxxxxx> 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
