1 # SPEC file for pg_dbms_stats
2 # Copyright(C) 2012 NIPPON TELEGRAPH AND TELEPHONE CORPORATION
4 %define _pgdir /usr/pgsql-9.2
5 %define _bindir %{_pgdir}/bin
6 %define _libdir %{_pgdir}/lib
7 %define _datadir %{_pgdir}/share
8 %define _docdir /usr/share/doc/pgsql
10 ## Set general information for pg_dbms_stats.
11 Summary: Plan Stabilizer for PostgreSQL 9.2
16 Group: Applications/Databases
17 Source0: %{name}-%{version}.tar.gz
18 #URL: http://example.com/pg_dbms_stats/
19 BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-%(%{__id_u} -n)
20 Vendor: NIPPON TELEGRAPH AND TELEPHONE CORPORATION
22 ## We use postgresql-devel package
23 BuildRequires: postgresql92-devel
24 Requires: postgresql92-libs
26 ## Description for "pg_dbms_stats"
28 pg_dbms_stats provides capability to replace planner's statistics with snapshot
29 taken at arbitrary timing, so that planner generates stable plans even if
30 ANALYZE is invoked after changes of data.
32 pg_dbms_stats also provides following features:
33 - backup multiple generations of planner statistics to reuse plans after
34 - import planner statistics from another system for tuning an testing
36 Note that this package is available for only PostgreSQL 9.2.
38 ## pre work for build pg_dbms_stats
42 ## Set variables for build environment
46 ## Set variables for install
49 install -d %{buildroot}%{_libdir}
50 install -m 755 pg_dbms_stats.so %{buildroot}%{_libdir}/pg_dbms_stats.so
51 install -d %{buildroot}%{_datadir}/extension
52 install -m 644 pg_dbms_stats--1.0.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.0.sql
53 install -m 644 pg_dbms_stats.control %{buildroot}%{_datadir}/extension/pg_dbms_stats.control
54 install -d %{buildroot}%{_docdir}/extension
55 install -m 644 export_effective_stats-9.2.sql.sample %{buildroot}%{_docdir}/extension/export_effective_stats-9.2.sql.sample
56 install -m 644 export_plain_stats-9.2.sql.sample %{buildroot}%{_docdir}/extension/export_plain_stats-9.2.sql.sample
62 %defattr(0755,root,root)
63 %{_libdir}/pg_dbms_stats.so
64 %defattr(0644,root,root)
65 %{_datadir}/extension/pg_dbms_stats--1.0.sql
66 %{_datadir}/extension/pg_dbms_stats.control
67 %{_docdir}/extension/export_effective_stats-9.2.sql.sample
68 %{_docdir}/extension/export_plain_stats-9.2.sql.sample
70 # History of pg_dbms_stats.
72 * Wed Sep 05 2012 Shigeru Hanada <shigeru.hanada@gmail.com>
73 - Initial cut for 1.0.0