Missing install system_stats--3.0.sql
lssno opened this issue · 1 comments
Scenario
make
make install # All OK
postgres# CREATE EXTENSION system_stats;
ERROR: extension "system_stats" has no installation script nor update path for version "3.0"Solution
Add system_stats--3.0.sql in Makefile to install
DATA = system_stats--1.0--2.0.sql system_stats--1.0.sql system_stats--2.0.sql system_stats--3.0.sql uninstall_system_stats.sql
I can confirm that this problem exists. Here's the output of "make install" showing that there's no 3.0 file getting copied.
[runner@2149afe1474a system_stats]$ DESTDIR=/tmp/install make USE_PGXS=1 install "Platform is: linux" /usr/bin/mkdir -p '/tmp/install/usr/pgsql-16/lib' /usr/bin/mkdir -p '/tmp/install/usr/pgsql-16/share/extension' /usr/bin/mkdir -p '/tmp/install/usr/pgsql-16/share/extension' /usr/bin/install -c -m 755 system_stats.so '/tmp/install/usr/pgsql-16/lib/system_stats.so' /usr/bin/install -c -m 644 .//system_stats.control '/tmp/install/usr/pgsql-16/share/extension/' /usr/bin/install -c -m 644 .//system_stats--1.0--2.0.sql .//system_stats--1.0.sql .//system_stats--2.0.sql .//uninstall_system_stats.sql '/tmp/install/usr/pgsql-16/share/extension/' /usr/bin/mkdir -p '/tmp/install/usr/pgsql-16/include/server/extension/system_stats/' /usr/bin/install -c -m 644 .//system_stats.h '/tmp/install/usr/pgsql-16/include/server/extension/system_stats/' /usr/bin/mkdir -p '/tmp/install/usr/pgsql-16/lib/bitcode/system_stats' /usr/bin/mkdir -p '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/ '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 system_stats.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/./ /usr/bin/install -c -m 644 linux/system_stats_utils.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 linux/disk_info.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 linux/io_analysis.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 linux/cpu_info.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 linux/cpu_usage_info.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 linux/os_info.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 linux/memory_info.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 linux/load_avg.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 linux/process_info.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 linux/network_info.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ /usr/bin/install -c -m 644 linux/cpu_memory_by_process.bc '/tmp/install/usr/pgsql-16/lib/bitcode'/system_stats/linux/ cd '/tmp/install/usr/pgsql-16/lib/bitcode' && /usr/bin/llvm-lto -thinlto -thinlto-action=thinlink -o system_stats.index.bc system_stats/system_stats.bc system_stats/linux/system_stats_utils.bc system_stats/linux/disk_info.bc system_stats/linux/io_analysis.bc system_stats/linux/cpu_info.bc system_stats/linux/cpu_usage_info.bc system_stats/linux/os_info.bc system_stats/linux/memory_info.bc system_stats/linux/load_avg.bc system_stats/linux/process_info.bc system_stats/linux/network_info.bc system_stats/linux/cpu_memory_by_process.bc [runner@2149afe1474a system_stats]$