1 # SPEC file for pg_dbms_stats93
2 # Copyright(C) 2012-2014 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 [ "${MAKE_ROOT}" != "" ]; then
47 make USE_PGXS=1 clean %{name}-%{version}.tar.gz
50 if [ ! -d %{_rpmdir} ]; then mkdir -p %{_rpmdir}; fi
53 ## Set variables for build environment
55 PATH=/usr/pgsql-9.3/bin:$PATH
56 make USE_PGXS=1 %{?_smp_mflags}
58 ## Set variables for install
61 install -d %{buildroot}%{_libdir}
62 install -m 755 pg_dbms_stats.so %{buildroot}%{_libdir}/pg_dbms_stats.so
63 install -d %{buildroot}%{_datadir}/extension
64 install -m 644 pg_dbms_stats--1.3.5.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.3.5.sql
65 install -m 644 pg_dbms_stats--1.0--1.3.2.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.0--1.3.2.sql
66 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
67 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
68 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
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.5.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.control
87 %{_docdir}/extension/export_effective_stats-9.3.sql.sample
88 %{_docdir}/extension/export_plain_stats-9.3.sql.sample
90 # History of pg_dbms_stats.
92 * Thu Sep 16 2014 Kyotaro Horiguchi
94 * Thu Aug 25 2014 Kyotaro Horiguchi
96 * Thu Jun 05 2014 Kyotaro Horiguchi
98 * Wed Nov 06 2013 Takashi Suzuki
100 * Wed Sep 05 2012 Shigeru Hanada
101 - Initial cut for 1.0.0