Erreur postgresql jsquery dans les logs postgres
Publié : 03 oct. 2025 - 08:11
Bonjour,
Dans les logs de la bdd, je suis tombé sur ça
Vous ne faites pas mention de la nécessité d'installer le paquet postgresql-15-jsquery sous bookworm dans le wiki. Ou alors sur une autre page que https://www.wapt.fr/en/doc/wapt-server- ... er-install
Cordialement,
Dans les logs de la bdd, je suis tombé sur ça
Code : Tout sélectionner
2025-10-02 23:59:27.817 CEST [1202] LOG: starting PostgreSQL 15.14 (Debian 15.14-0+deb12u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
2025-10-02 23:59:27.822 CEST [1202] LOG: listening on IPv6 address "::1", port 5432
2025-10-02 23:59:27.822 CEST [1202] LOG: listening on IPv4 address "127.0.0.1", port 5432
2025-10-02 23:59:27.824 CEST [1202] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-10-02 23:59:27.856 CEST [1224] LOG: database system was shut down at 2025-10-02 23:59:02 CEST
2025-10-02 23:59:27.888 CEST [1202] LOG: database system is ready to accept connections
2025-10-02 23:59:30.866 CEST [1794] wapt@wapt ERROR: extension "jsquery" is not available
2025-10-02 23:59:30.866 CEST [1794] wapt@wapt DETAIL: Could not open extension control file "/usr/share/postgresql/15/extension/jsquery.control": No such file or directory.
2025-10-02 23:59:30.866 CEST [1794] wapt@wapt HINT: The extension must first be installed on the system where PostgreSQL is running.
2025-10-02 23:59:30.866 CEST [1794] wapt@wapt STATEMENT: CREATE EXTENSION if not exists jsquery;
2025-10-02 23:59:30.867 CEST [1794] wapt@wapt WARNING: there is no transaction in progress
2025-10-03 00:02:58.370 CEST [2675] postgres@wapt LOG: could not send data to client: Broken pipe
2025-10-03 00:02:58.370 CEST [2675] postgres@wapt STATEMENT: COPY public.hostauditdata (id, host_id, value_id, value_date, value_section, value_key, value, expiration_date, created_on, created_by) TO stdout;
2025-10-03 00:02:58.370 CEST [2675] postgres@wapt ERROR: canceling statement due to user request
2025-10-03 00:02:58.370 CEST [2675] postgres@wapt STATEMENT: COPY public.hostauditdata (id, host_id, value_id, value_date, value_section, value_key, value, expiration_date, created_on, created_by) TO stdout;
2025-10-03 00:02:58.370 CEST [2675] postgres@wapt FATAL: connection to client lostCordialement,