1 # SPEC file for pg_store_plans
2 # Copyright(C) 2016 NIPPON TELEGRAPH AND TELEPHONE CORPORATION
4 %define _pgdir /usr/pgsql-9.6
5 %define _bindir %{_pgdir}/bin
6 %define _libdir %{_pgdir}/lib
7 %define _datadir %{_pgdir}/share
8 %if "%(echo ${MAKE_ROOT})" != ""
9 %define _rpmdir %(echo ${MAKE_ROOT})/RPMS
10 %define _sourcedir %(echo ${MAKE_ROOT})
13 ## Set general information for pg_store_plans.
14 Summary: Optimizer hint on PostgreSQL 9.6
19 Group: Applications/Databases
20 Source0: %{name}-%{version}.tar.gz
21 #URL: http://example.com/pg_hint_plan/
22 BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-%(%{__id_u} -n)
23 Vendor: NIPPON TELEGRAPH AND TELEPHONE CORPORATION
25 ## We use postgresql-devel package
26 BuildRequires: postgresql96-devel
27 Requires: postgresql96-libs
29 ## Description for "pg_hint_plan"
32 pg_hint_plan provides capability to tweak execution plans to be
33 executed on PostgreSQL.
35 Note that this package is available for only PostgreSQL 9.6.
37 ## pre work for build pg_hint_plan
39 PATH=/usr/pgsql-9.6/bin:$PATH
40 if [ "${MAKE_ROOT}" != "" ]; then
42 make clean %{name}-%{version}.tar.gz
45 if [ ! -d %{_rpmdir} ]; then mkdir -p %{_rpmdir}; fi
48 ## Set variables for build environment
50 PATH=/usr/pgsql-9.6/bin:$PATH
51 make USE_PGXS=1 %{?_smp_mflags}
53 ## Set variables for install
56 install -d %{buildroot}%{_libdir}
57 install pg_hint_plan.so %{buildroot}%{_libdir}/pg_hint_plan.so
58 install -d %{buildroot}%{_datadir}/extension
59 install -m 644 pg_hint_plan--1.1.3.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.3.sql
60 install -m 644 pg_hint_plan.control %{buildroot}%{_datadir}/extension/pg_hint_plan.control
66 %defattr(0755,root,root)
67 %{_libdir}/pg_hint_plan.so
68 %defattr(0644,root,root)
69 %{_datadir}/extension/pg_hint_plan--1.1.3.sql
70 %{_datadir}/extension/pg_hint_plan.control
72 # History of pg_hint_plan.
74 * Thu Jul 21 2016 Kyotaro Horiguchi
75 - Support PostgreSQL 9.6