1 # SPEC file for pg_store_plans
2 # Copyright(c) 2021, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
4 %define _pgdir /usr/pgsql-14
5 %define _bindir %{_pgdir}/bin
6 %define _libdir %{_pgdir}/lib
7 %define _datadir %{_pgdir}/share
8 %define _bcdir %{_libdir}/bitcode
9 %define _mybcdir %{_bcdir}/pg_store_plans
11 %if "%(echo ${MAKE_ROOT})" != ""
12 %define _rpmdir %(echo ${MAKE_ROOT})/RPMS
13 %define _sourcedir %(echo ${MAKE_ROOT})
16 ## Set general information for pg_store_plans.
17 Summary: Record executed plans on PostgreSQL 14
18 Name: pg_store_plans14
22 Group: Applications/Databases
23 Source0: %{name}-%{version}.tar.gz
24 #URL: http://example.com/pg_store_plans/
25 BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-%(%{__id_u} -n)
26 Vendor: NIPPON TELEGRAPH AND TELEPHONE CORPORATION
28 ## We use postgresql-devel package
29 BuildRequires: postgresql14-devel
30 Requires: postgresql14-libs
32 ## Description for "pg_store_plans"
35 pg_store_plans provides capability to record statistics for every plan
36 executed on PostgreSQL.
38 Note that this package is available for only PostgreSQL 14.
41 Requires: postgresql14-server, postgresql14-llvmjit
42 Requires: pg_store_plans14 = 1.6.1
43 Summary: Just-in-time compilation support for pg_store_plans14
46 Just-in-time compilation support for pg_store_plans14
48 ## pre work for build pg_store_plans
50 PATH=/usr/pgsql-14/bin:$PATH
51 if [ "${MAKE_ROOT}" != "" ]; then
53 make clean %{name}-%{version}.tar.gz
56 if [ ! -d %{_rpmdir} ]; then mkdir -p %{_rpmdir}; fi
59 ## Set variables for build environment
61 PATH=/usr/pgsql-14/bin:$PATH
63 make USE_PGXS=1 %{?_smp_mflags}
65 ## Set variables for install
68 PATH=/usr/pgsql-14/bin:$PATH
69 make install DESTDIR=%{buildroot}
75 %defattr(0755,root,root)
76 %{_libdir}/pg_store_plans.so
77 %defattr(0644,root,root)
78 %{_datadir}/extension/pg_store_plans--1.6.sql
79 %{_datadir}/extension/pg_store_plans--1.6--1.6.1.sql
80 %{_datadir}/extension/pg_store_plans.control
83 %defattr(0644,root,root)
84 %{_bcdir}/pg_store_plans.index.bc
87 # History of pg_store_plans.
89 * Mon Feb 03 2022 Kyotaro Horiguchi
91 * Mon Jan 17 2022 Tatsuro Yamada, Julien Rouhaud, Kyotaro Horiguchi
92 - Version 1.6. Supports PostgreSQL 14
93 * Wed Jan 27 2021 Kyotaro Horiguchi
94 - Version 1.5. Supports PostgreSQL 13
95 * Thu Jan 30 2020 Kyotaro Horiguchi
96 - Version 1.4. Supports PostgreSQL 12
97 * Tue Jan 22 2019 Kyotaro Horiguchi
98 - Supports PostgreSQL 11
99 * Tue Oct 10 2017 Kyotaro Horiguchi
100 - Supports PostgreSQL 10
101 * Fri Aug 26 2016 Kyotaro Horiguchi
102 - Some fix in plan representation functions.
103 * Wed Apr 13 2016 Kyotaro Horiguchi
104 - Support PostgreSQL 9.5
105 * Fri Jun 12 2015 Kyotaro Horiguchi