OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/postgresql?expand=0&rev=7

postgresql-pl.spec

@@ -24,7 +24,7 @@ BuildRequires:  ncurses-devel
 BuildRequires:  python-devel tcl-devel
 Summary:        The PL/Tcl, PL/Perl, and PL/Python Procedural Languages for PostgreSQL
 Version:        8.3.1
-Release:        6
+Release:        7
 %define pg_minor_version %(echo %version | cut -f1-2 -d.)
 License:        BSD 3-Clause
 Group:          Productivity/Databases/Servers

postgresql.changes

@@ -1,3 +1,8 @@
+-------------------------------------------------------------------
+Thu Sep  4 14:11:53 CEST 2008 - yxu@suse.de
+
+- added pgbench subpackage for testing purpose
+
 -------------------------------------------------------------------
 Thu Aug 28 23:23:58 CEST 2008 - cthiel@suse.de
 

postgresql.spec

@@ -23,7 +23,7 @@ BuildRequires:  openldap2-devel openssl-devel pam-devel readline-devel zlib-deve
 BuildRequires:  ncurses-devel
 Summary:        Basic Clients and Utilities for PostgreSQL
 Version:        8.3.1
-Release:        35
+Release:        37
 %define pg_minor_version %(echo %version | cut -f1-2 -d.)
 License:        BSD 3-Clause
 Group:          Productivity/Databases/Tools
@@ -207,6 +207,27 @@ Authors:
     Bruce Momjian <pgman@candle.pha.pa.us>
     Jan Wieck <JanWieck@Yahoo.com>
 
+%package pgbench
+License:        BSD 3-Clause
+Summary:        A simple TPC-B like benchmark program for PostgreSQL
+Group:          Productivity/Databases/Tools
+Requires:       postgresql-libs = %pg_minor_version
+
+%description pgbench
+pgbench is a simple program for running benchmark tests on PostgreSQL.
+It runs the same sequence of SQL commands over and over, possibly in
+multiple concurrent database sessions, and then calculates the average
+transaction rate (transactions per second). By default, pgbench tests a
+scenario that is loosely based on TPC-B, involving five SELECT, UPDATE,
+and INSERT commands per transaction. However, it is easy to test other
+cases by writing your own transaction script files.
+
+
+
+Authors:
+--------
+    Tatsuo Ishii
+
 %prep
 %setup -q
 %patch
@@ -276,6 +297,7 @@ for f in /etc/init.d /var/adm/fillup-templates /usr/sbin \
 do
 	install -d %buildroot/$f
 done
+install -m 755 contrib/pgbench/pgbench %buildroot%_bindir
 install -m 755 %{SOURCE9} %buildroot/etc/init.d/postgresql
 install -m 644 %{SOURCE8} %buildroot/var/adm/fillup-templates/sysconfig.postgresql
 %if 0%suse_version > 1020
@@ -452,7 +474,13 @@ rm -f %my_provides
 %doc %_mandir/man1/ecpg.1*
 %doc %_mandir/man1/pg_config.1*
 
+%files pgbench
+%defattr(-,root,root)
+%_bindir/pgbench
+
 %changelog
+* Thu Sep 04 2008 yxu@suse.de
+- added pgbench subpackage for testing purpose
 * Fri Aug 29 2008 cthiel@suse.de
 - fix init script
 * Mon May 19 2008 schwab@suse.de