1 # SPEC file for pg_dbms_stats10
2 # Copyright(C) 2012-2017 NIPPON TELEGRAPH AND TELEPHONE CORPORATION
4 %define _pgdir /usr/pgsql-10
5 %define _bindir %{_pgdir}/bin
6 %define _libdir %{_pgdir}/lib
7 %define _datadir %{_pgdir}/share
8 %define _docdir /usr/share/doc/pgsql
9 %if "%(echo ${MAKE_ROOT})" != ""
10 %define _rpmdir %(echo ${MAKE_ROOT})/RPMS
11 %define _sourcedir %(echo ${MAKE_ROOT})
14 ## Set general information for pg_dbms_stats.
15 Summary: Plan Stabilizer for PostgreSQL 10
20 Group: Applications/Databases
21 Source: %{name}-%{version}.tar.gz
22 URL: http://sourceforge.jp/projects/pgdbmsstats/
23 BuildRoot: %{buildroot}
24 Vendor: NIPPON TELEGRAPH AND TELEPHONE CORPORATION
26 ## postgresql-devel package required
27 BuildRequires: postgresql10-devel
28 Requires: postgresql10-libs
30 ## Description for "pg_dbms_stats"
32 pg_dbms_stats disguises database statistics with a prevously taken
33 snapshot so that the planner won't change its behavior even after
34 ANALYZE updates the statistics.
36 pg_dbms_stats also provides following features:
37 - backup multiple generations of planner statistics to reuse plans afterwards
38 - import planner statistics from another system for tuning or testing.
40 Note that this package is available for only PostgreSQL 10.
42 ## pre work for build pg_dbms_stats
44 PATH=/usr/pgsql-10/bin:$PATH
45 if [ ! -d %{_rpmdir} ]; then mkdir -p %{_rpmdir}; fi
48 ## Set variables for build environment
50 PATH=/usr/pgsql-10/bin:$PATH
51 make USE_PGXS=1 %{?_smp_mflags}
53 ## Set variables for install
56 install -d %{buildroot}%{_libdir}
57 install -m 755 pg_dbms_stats.so %{buildroot}%{_libdir}/pg_dbms_stats.so
58 install -d %{buildroot}%{_datadir}/extension
59 install -m 644 pg_dbms_stats--1.3.9.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.9.sql
60 install -m 644 pg_dbms_stats--1.3.8--1.3.9.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.8--1.3.9.sql
61 install -m 644 pg_dbms_stats.control %{buildroot}%{_datadir}/extension/pg_dbms_stats.control
62 install -d %{buildroot}%{_docdir}/extension
63 install -m 644 doc/export_effective_stats-10.sql.sample %{buildroot}%{_docdir}/extension/export_effective_stats-10.sql.sample
64 install -m 644 doc/export_plain_stats-10.sql.sample %{buildroot}%{_docdir}/extension/export_plain_stats-10.sql.sample
70 %defattr(0755,root,root)
71 %{_libdir}/pg_dbms_stats.so
72 %defattr(0644,root,root)
73 %{_datadir}/extension/pg_dbms_stats--1.3.9.sql
74 %{_datadir}/extension/pg_dbms_stats--1.3.8--1.3.9.sql
75 %{_datadir}/extension/pg_dbms_stats.control
76 %{_docdir}/extension/export_effective_stats-10.sql.sample
77 %{_docdir}/extension/export_plain_stats-10.sql.sample
79 # History of pg_dbms_stats.
81 * Mon Nov 13 2017 Kyotaro Horiguchi
82 - Update to 1.3.9. Bug fixed.
83 * Tue Oct 10 2017 Kyotaro Horiguchi
84 - pg_dbms_stats10 v1.3.8 release