기본 postgresql 버전에서 pgaudit를 설치하지 못했습니다.

기본 postgresql 버전에서 pgaudit를 설치하지 못했습니다.

Discourse가 기본적으로 제공하는 postgresql에 설치하려고 하면 pgaudit아래와 같은 실패 메시지가 나타납니다.

<Error Messages>
root@07f8d9674261:/pgaudit#  make check USE_PGXS=1
Makefile:16: /usr/lib/postgresql/11/lib/pgxs/src/makefiles/pgxs.mk: No such file or directory
make: *** No rule to make target '/usr/lib/postgresql/11/lib/pgxs/src/makefiles/pgxs.mk'.  Stop.
root@07f8d9674261:/pgaudit# cd pgaudit/

이유를 아시나요? 이 문제를 어떻게 해결할 수 있나요?

답변1

이는 서버 개발 패키지를 설치하지 않았기 때문입니다. 예를 들어 Debian/Ubuntu에서 여기에 누락된 Makefile은 다음에서 제공됩니다.postgresql-서버-dev-11패키지.

apt install postgresql-server-dev-11설치하려면 루트로 실행하세요 .

$ dpkg -S pgxs.mk
postgresql-server-dev-11: /usr/lib/postgresql/11/lib/pgxs/src/makefiles/pgxs.mk

$ apt show postgresql-server-dev-11
Package: postgresql-server-dev-11
Version: 11.5-1.pgdg18.04+1
Priority: optional
Section: libdevel
Source: postgresql-11
Maintainer: Debian PostgreSQL Maintainers <[email protected]>
Installed-Size: 5 190 kB
Depends: clang-6.0, libpq-dev (>= 11~~), llvm-6.0-dev, postgresql-common (>= 142~), libc6 (>= 2.14)
Breaks: postgresql-server-dev-all (<< 181~)
Homepage: http://www.postgresql.org/
Download-Size: 933 kB
APT-Manual-Installed: yes
APT-Sources: http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64 Packages
Description: development files for PostgreSQL 11 server-side programming
 Header files for compiling SSI code to link into PostgreSQL's backend; for
 example, for C functions to be called from SQL.
 .
 This package also contains the Makefiles necessary for building add-on
 modules of PostgreSQL, which would otherwise have to be built in the
 PostgreSQL source-code tree.
 .
 PostgreSQL is an object-relational SQL database management system.

관련 정보