1 # SPEC file for pg_dbms_stats93
2 # Copyright(C) 2012-2018 NIPPON TELEGRAPH AND TELEPHONE CORPORATION
4 %define _pgdir /usr/pgsql-9.3
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 9.3
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: postgresql93-devel
28 Requires: postgresql93-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 9.3.
42 ## pre work for build pg_dbms_stats
44 PATH=/usr/pgsql-9.3/bin:$PATH
45 if [ ! -d %{_rpmdir} ]; then mkdir -p %{_rpmdir}; fi
48 ## Set variables for build environment
50 PATH=/usr/pgsql-9.3/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.11.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.11.sql
60 install -m 644 pg_dbms_stats--1.0--1.3.2.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.0--1.3.2.sql
61 install -m 644 pg_dbms_stats--1.3.2--1.3.3.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.2--1.3.3.sql
62 install -m 644 pg_dbms_stats--1.3.3--1.3.4.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.3--1.3.4.sql
63 install -m 644 pg_dbms_stats--1.3.4--1.3.5.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.4--1.3.5.sql
64 install -m 644 pg_dbms_stats--1.3.5--1.3.6.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.5--1.3.6.sql
65 install -m 644 pg_dbms_stats--1.3.6--1.3.7.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.6--1.3.7.sql
66 install -m 644 pg_dbms_stats--1.3.7--1.3.9.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.7--1.3.9.sql
67 install -m 644 pg_dbms_stats--1.3.9--1.3.10.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.9--1.3.10.sql
68 install -m 644 pg_dbms_stats--1.3.10--1.3.11.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.10--1.3.11.sql
69 install -m 644 pg_dbms_stats.control %{buildroot}%{_datadir}/extension/pg_dbms_stats.control
70 install -d %{buildroot}%{_docdir}/extension
71 install -m 644 doc/export_effective_stats-9.3.sql.sample %{buildroot}%{_docdir}/extension/export_effective_stats-9.3.sql.sample
72 install -m 644 doc/export_plain_stats-9.3.sql.sample %{buildroot}%{_docdir}/extension/export_plain_stats-9.3.sql.sample
78 %defattr(0755,root,root)
79 %{_libdir}/pg_dbms_stats.so
80 %defattr(0644,root,root)
81 %{_datadir}/extension/pg_dbms_stats--1.3.11.sql
82 %{_datadir}/extension/pg_dbms_stats--1.0--1.3.2.sql
83 %{_datadir}/extension/pg_dbms_stats--1.3.2--1.3.3.sql
84 %{_datadir}/extension/pg_dbms_stats--1.3.3--1.3.4.sql
85 %{_datadir}/extension/pg_dbms_stats--1.3.4--1.3.5.sql
86 %{_datadir}/extension/pg_dbms_stats--1.3.5--1.3.6.sql
87 %{_datadir}/extension/pg_dbms_stats--1.3.6--1.3.7.sql
88 %{_datadir}/extension/pg_dbms_stats--1.3.7--1.3.9.sql
89 %{_datadir}/extension/pg_dbms_stats--1.3.9--1.3.10.sql
90 %{_datadir}/extension/pg_dbms_stats--1.3.10--1.3.11.sql
91 %{_datadir}/extension/pg_dbms_stats.control
92 %{_docdir}/extension/export_effective_stats-9.3.sql.sample
93 %{_docdir}/extension/export_plain_stats-9.3.sql.sample
95 # History of pg_dbms_stats.
97 * Wed Sep 26 2018 Kyotaro Horiguchi
98 - Update to 1.3.11. Bug fix.
99 * Thu Apr 05 2018 Kyotaro Horiguchi
100 - Update to 1.3.10. Bug fix.
101 * Mon Nov 13 2017 Kyotaro Horiguchi
102 - Update to 1.3.9. Bug fix.
103 * Fri Mar 25 2016 Kyotaro Horiguchi
105 * Mon Dec 01 2014 Kyotaro Horiguchi
107 * Thu Nov 13 2014 Kyotaro Horiguchi
109 * Tue Sep 16 2014 Kyotaro Horiguchi
111 * Mon Aug 25 2014 Kyotaro Horiguchi
113 * Thu Jun 05 2014 Kyotaro Horiguchi
115 * Wed Nov 06 2013 Takashi Suzuki
117 * Wed Sep 05 2012 Shigeru Hanada
118 - Initial cut for 1.0.0