Skip to content

PG 18: pg_wait_sampling.so: undefined symbol: pqsignal #107

@lysalexy

Description

@lysalexy

OS: RHEL7
DB: PostgreSQL 18(собрана из исходников c make install-world)

Успешно скомпилировались исходные файлы расширения
make USE_PGXS=1
make USE_PGXS=1 install

Появился .so файл.

Однако при попытке перезагрузки сервера БД с добавленнным postgresql.conf "shared_preload_libraries = 'pg_wait_sampling' " появляется ошибка.

2025-12-22 18:29:52.633 MSK [20973] FATAL: could not load library "/usr/local/pgsql/lib/pg_wait_sampling.so": /usr/local/pgsql/lib/pg_wait_sampling.so: undefined symbol: pqsignal
2025-12-22 18:29:52.634 MSK [20973] LOG: database system is shut down

Вывод pg_config

BINDIR = /usr/local/pgsql/bin
DOCDIR = /usr/local/pgsql/share/doc
HTMLDIR = /usr/local/pgsql/share/doc
INCLUDEDIR = /usr/local/pgsql/include
PKGINCLUDEDIR = /usr/local/pgsql/include
INCLUDEDIR-SERVER = /usr/local/pgsql/include/server
LIBDIR = /usr/local/pgsql/lib
PKGLIBDIR = /usr/local/pgsql/lib
LOCALEDIR = /usr/local/pgsql/share/locale
MANDIR = /usr/local/pgsql/share/man
SHAREDIR = /usr/local/pgsql/share
SYSCONFDIR = /usr/local/pgsql/etc
PGXS = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE =
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wshadow=compatible-local -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -O2
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,--as-needed -Wl,-rpath,'/usr/local/pgsql/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lz -ledit -lpthread -lrt -ldl -lm
VERSION = PostgreSQL 18.0

Содержимое libpq.pc

prefix=/usr/local/pgsql
exec_prefix=${prefix}
libdir=${exec_prefix}/lib
includedir=${prefix}/include
Name: libpq
Description: PostgreSQL libpq library
URL: https://www.postgresql.org/
Version: 18.0
Requires:
Requires.private:
Cflags: -I${includedir}
Libs: -L${libdir} -lpq
Libs.private: -lpgcommon -lpgport -ldl -lm

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions