# build6x usage: define to 1 to build for RHL6.x.  Don't define at all for others.

%{?build6x:%define kerberos 0}

%{?build6x:%define nls 0}

%{?build6x:%define ssl 0}

%{?build6x:%define tcldevel 0}

%{?build6x:%define aconfver /bin/true}

#work around the undefined or defined to 1 build 6x interaction with the pam stuff

%{!?build6x:%define non6xpamdeps 1}

%{?build6x:%define non6xpamdeps 0}

#build7x, build8, and build9 similar

%{?build8:%define build89 1}

%{?build9:%define build89 1}

%{?build7x:%define tcldevel 0}

%{?build8:%define tcldevel 0}

%{?build7x:%define aconfver autoconf-2.53}

%{!?tcldevel:%define tcldevel 1}

%{!?aconfver:%define aconfver autoconf}

%define beta 0

%{?beta:%define __os_install_post /usr/lib/rpm/brp-compress}

%{!?tcl:%define tcl 1}

%{!?jdbc:%define jdbc 1}

%{!?test:%define test 1}

%{!?python:%define python 1}

%{!?pltcl:%define pltcl 1}

%{!?plperl:%define plperl 1}

%{!?pls:%define pls 1}

%{!?ssl:%define ssl 1}

%{!?kerberos:%define kerberos 1}

%{!?nls:%define nls 1}

%{!?pam:%define pam 1}

%{!?xml:%define xml 1}

%{!?pgfts:%define pgfts 1}

%{!?runselftest:%define runselftest 1}

# Python major version.

%{expand: %%define pyver %(python -c 'import sys;print(sys.version[0:3])')}

Summary: PostgreSQL client programs and libraries.

Name: postgresql

Version: 8.0.4

# Conventions for PostgreSQL Global Development Group RPM releases:

# Official PostgreSQL Development Group RPMS have a PGDG after the release number.

# Integer releases are stable -- 0.1.x releases are Pre-releases, and x.y are

# test releases.

# Pre-releases are those that are built from CVS snapshots or pre-release

# tarballs from postgresql.org.  Official beta releases are not 

# considered pre-releases, nor are release candidates, as their beta or

# release candidate status is reflected in the version of the tarball. Pre-

# releases' versions do not change -- the pre-release tarball of 7.0.3, for

# example, has the same tarball version as the final official release of 7.0.3:

# but the tarball is different.

# Test releases are where PostgreSQL itself is not in beta, but certain parts of

# the RPM packaging (such as the spec file, the initscript, etc) are in beta.

# Pre-release RPM's should not be put up on the public ftp.postgresql.org server

# -- only test releases or full releases should be.

Release: 2

License: BSD

Group: Applications/Databases

Source0: ftp://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2

Source3: postgresql.init

Source4: Makefile.regress

Source6: README.rpm-dist

Source8: http://jdbc.postgresql.org/download/postgresql-8.0-312.jdbc2.jar

Source9: http://jdbc.postgresql.org/download/postgresql-8.0-312.jdbc2ee.jar

Source10: http://jdbc.postgresql.org/download/postgresql-8.0-312.jdbc3.jar

Source14: postgresql.pam

Source15: postgresql-bashprofile

Source16: filter-requires-perl-Pg.sh

Source17: postgresql-8.0-US.pdf

Source18: ftp://ftp.druid.net/pub/distrib/PyGreSQL-3.6.2.tgz

Source19: ftp://gborg.postgresql.org/pub/pgtclng/stable/pgtcl1.5.2.tar.gz

Source20: ftp://gborg.postgresql.org/pub/pgtclng/stable/pgtcldocs-20041108.zip

Patch1: rpm-pgsql.patch

Patch2: postgresql-src-tutorial.patch

Patch3: postgresql-logging.patch

Patch4: postgresql-test.patch

Patch5: pgtcl-no-rpath.patch

Patch6: postgresql-perl-rpath.patch

Buildrequires: perl glibc-devel bison flex

Prereq: /sbin/ldconfig initscripts

%if %python

BuildPrereq: python-devel

%endif

%if %tcl || %pltcl

BuildPrereq: tcl

%if %tcldevel

Buildrequires: tcl-devel

%endif

%endif

BuildPrereq: readline-devel

BuildPrereq: zlib-devel >= 1.0.4

%if %ssl

BuildPrereq: openssl-devel

%endif

%if %kerberos

BuildPrereq: krb5-devel

BuildPrereq: e2fsprogs-devel

%endif

%if %nls

BuildPrereq: gettext >= 0.10.35

%endif

%if %pam

%if %non6xpamdeps

BuildPrereq: pam-devel

%endif

%endif

%if %xml

BuildPrereq: libxml2-devel

%endif

Url: http://www.postgresql.org/ 

Obsoletes: postgresql-clients

Obsoletes: postgresql-perl

Obsoletes: postgresql-tk

Obsoletes: rh-postgresql

Buildroot: %{_tmppath}/%{name}-%{version}-root

# This is the PostgreSQL Global Development Group Official RPMset spec file,

# or a derivative thereof.

# Copyright 2003 Lamar Owen <lowen@pari.edu> <lamar.owen@wgcr.org>

# and others listed.

# Major Contributors:

# ---------------

# Lamar Owen

# Trond Eivind Glomsrd <teg@redhat.com>

# Thomas Lockhart

# Reinhard Max

# Karl DeBisschop

# Peter Eisentraut

# Joe Conway

# Andrew Overholt

# David Jee

# Kaj J. Niemi

# Sander Steffann

# Tom Lane

# and others in the Changelog....

# This spec file and ancilliary files are licensed in accordance with 

# The PostgreSQL license.

# On top of this file you can find the default build package list macros.  These can be overridden by defining

# on the rpm command line:

# rpm --define 'packagename 1' .... to force the package to build.

# rpm --define 'packagename 0' .... to force the package NOT to build.

# The base package, the lib package, the devel package, and the server package always get built.

%description

PostgreSQL is an advanced Object-Relational database management system

(DBMS) that supports almost all SQL constructs (including

transactions, subselects and user-defined types and functions). The

postgresql package includes the client programs and libraries that

you'll need to access a PostgreSQL DBMS server.  These PostgreSQL

client programs are programs that directly manipulate the internal

structure of PostgreSQL databases on a PostgreSQL server. These client

programs can be located on the same machine with the PostgreSQL

server, or may be on a remote machine which accesses a PostgreSQL

server over a network connection. This package contains the docs

in HTML for the whole package, as well as command-line utilities for

managing PostgreSQL databases on a PostgreSQL server. 

If you want to manipulate a PostgreSQL database on a remote PostgreSQL

server, you need this package. You also need to install this package

if you're installing the postgresql-server package.

%package libs

Summary: The shared libraries required for any PostgreSQL clients.

Group: Applications/Databases

Provides: libpq.so

Obsoletes: rh-postgresql-libs

%description libs

The postgresql-libs package provides the essential shared libraries for any 

PostgreSQL client program or interface. You will need to install this package

to use any other PostgreSQL package or any clients that need to connect to a

PostgreSQL server.

%package server

Summary: The programs needed to create and run a PostgreSQL server.

Group: Applications/Databases

Prereq: /usr/sbin/useradd /sbin/chkconfig 

Prereq: postgresql = %{version}-%{release} libpq.so

Obsoletes: rh-postgresql-server

%description server

The postgresql-server package includes the programs needed to create

and run a PostgreSQL server, which will in turn allow you to create

and maintain PostgreSQL databases.  PostgreSQL is an advanced

Object-Relational database management system (DBMS) that supports

almost all SQL constructs (including transactions, subselects and

user-defined types and functions). You should install

postgresql-server if you want to create and maintain your own

PostgreSQL databases and/or your own PostgreSQL server. You also need

to install the postgresql package.

%package docs

Summary: Extra documentation for PostgreSQL

Group: Applications/Databases

Prereq: postgresql = %{version}-%{release}

Obsoletes: rh-postgresql-docs

%description docs

The postgresql-docs package includes some additional documentation for

PostgreSQL.  Currently, this includes the main documentation in PDF format,

the FAQ, and source files for the PostgreSQL tutorial.

%package contrib

Summary: Contributed source and binaries distributed with PostgreSQL

Group: Applications/Databases

Prereq: postgresql = %{version}-%{release}

Obsoletes: rh-postgresql-contrib

%description contrib

The postgresql-contrib package contains contributed packages that are

included in the PostgreSQL distribution.

%package devel

Summary: PostgreSQL development header files and libraries.

Group: Development/Libraries

Prereq: postgresql = %{version}-%{release}

Requires: postgresql-libs = %{version}-%{release}

Obsoletes: rh-postgresql-devel

%description devel

The postgresql-devel package contains the header files and libraries

needed to compile C or C++ applications which will directly interact

with a PostgreSQL database management server and the ecpg Embedded C

Postgres preprocessor. You need to install this package if you want to

develop applications which will interact with a PostgreSQL server. If

you're installing postgresql-server, you need to install this

package.

#------------

%if %pls

%package pl

Summary: The PL procedural languages for PostgreSQL.

Group: Applications/Databases

PreReq: postgresql = %{version}-%{release}

PreReq: postgresql-server = %{version}-%{release}

Obsoletes: rh-postgresql-pl

%description pl

PostgreSQL is an advanced Object-Relational database management

system.  The postgresql-pl package contains the the PL/Perl, PL/Tcl, and PL/Python

procedural languages for the backend.  PL/Pgsql is part of the core server package.

%endif

#------------

%if %tcl

%package tcl

Summary: A Tcl client library for PostgreSQL.

Group: Applications/Databases

Requires: libpq.so

Requires: tcl >= 8.3

Obsoletes: rh-postgresql-tcl

%description tcl

PostgreSQL is an advanced Object-Relational database management

system.  The postgresql-tcl package contains the Pgtcl client library

and its documentation.

%endif

#------------

%if %python

%package python

Summary: Development module for Python code to access a PostgreSQL DB.

Group: Applications/Databases

Requires: libpq.so

Requires: python mx

Obsoletes: rh-postgresql-python

%description python

PostgreSQL is an advanced Object-Relational database management

system.  The postgresql-python package includes a module for

developers to use when writing Python code for accessing a PostgreSQL

database.

%endif

#----------

%if %jdbc

%package jdbc

Summary: Files needed for Java programs to access a PostgreSQL database.

Group: Applications/Databases

Obsoletes: rh-postgresql-jdbc

%description jdbc

PostgreSQL is an advanced Object-Relational database management

system. The postgresql-jdbc package includes the .jar files needed for

Java programs to access a PostgreSQL database.

%endif

#------------

%if %test

%package test

Summary: The test suite distributed with PostgreSQL.

Group: Applications/Databases

PreReq: postgresql = %{version}-%{release}

PreReq: postgresql-server = %{version}-%{release}

Obsoletes: rh-postgresql-test

%description test

PostgreSQL is an advanced Object-Relational database management

system. The postgresql-test package includes the sources and pre-built

binaries of various tests for the PostgreSQL database management

system, including regression tests and benchmarks.

%endif

%define __perl_requires %{SOURCE16}

%prep

%setup -q 

pushd doc

tar zxf postgres.tar.gz

popd

%patch1 -p1

%patch2 -p1

%patch3 -p1

%patch4 -p1

# patch5 is applied later

%patch6 -p1

#call autoconf 2.53 or greater

%aconfver

pushd doc

tar -zcf postgres.tar.gz *.html stylesheet.css

rm -f *.html stylesheet.css

popd

cp -p %{SOURCE17} .

%if %python

   tar xzf %{SOURCE18}

   PYGRESQLDIR=`basename %{SOURCE18} .tgz`

   mv $PYGRESQLDIR PyGreSQL

   # Some versions of PyGreSQL.tgz contain wrong file permissions

   chmod 644 PyGreSQL/Announce PyGreSQL/ChangeLog PyGreSQL/README

   chmod 755 PyGreSQL/tutorial

   chmod 644 PyGreSQL/tutorial/*.py

   chmod 755 PyGreSQL/tutorial/advanced.py PyGreSQL/tutorial/basics.py

%endif

%if %tcl

   tar xzf %{SOURCE19}

   PGTCLDIR=`basename %{SOURCE19} .tar.gz`

   mv $PGTCLDIR Pgtcl

   unzip %{SOURCE20}

   PGTCLDOCDIR=`basename %{SOURCE20} .zip`

   mv $PGTCLDOCDIR Pgtcl-docs

%patch5 -p0

   pushd Pgtcl

%aconfver

   popd

%endif

%build

CFLAGS="${CFLAGS:-%optflags}" ; export CFLAGS

CXXFLAGS="${CXXFLAGS:-%optflags}" ; export CXXFLAGS

# Strip out -ffast-math from CFLAGS....

CFLAGS=`echo $CFLAGS|xargs -n 1|grep -v ffast-math|xargs -n 100`

%configure --disable-rpath \

%if %beta

	--enable-debug \

	--enable-cassert \

%endif

%if %plperl

	--with-perl \

%endif

%if %pltcl

	--with-tcl \

	--with-tclconfig=%{_libdir} \

%endif

%if %python

	--with-python \

%endif

%if %ssl

	--with-openssl \

%endif

%if %pam

	--with-pam \

%endif

%if %kerberos

	--with-krb5 \

%endif

%if %nls

	--enable-nls \

%endif

%if %pgfts

	--enable-thread-safety \

%endif

	--sysconfdir=/etc/sysconfig/pgsql \

	--datadir=/usr/share/pgsql \

	--with-docdir=%{_docdir}

make %{?_smp_mflags} all

make %{?_smp_mflags} -C contrib all

%if %xml

make %{?_smp_mflags} -C contrib/xml2 all

%endif

# Have to hack makefile to put correct path into tutorial scripts

sed "s|C=\`pwd\`;|C=%{_libdir}/pgsql/tutorial;|" < src/tutorial/Makefile > src/tutorial/GNUmakefile

make %{?_smp_mflags} -C src/tutorial NO_PGXS=1 all

rm -f src/tutorial/GNUmakefile

%if %runselftest

	pushd src/test/regress

	make all

	make MAX_CONNECTIONS=5 check

	make clean

	popd

%endif

%if %test

	pushd src/test/regress

	make RPMTESTING=1 all

	popd

%endif

%if %python

   PYTHON=/usr/bin/python

   python_version=`${PYTHON} -c "import sys; print sys.version[:3]"`

   python_prefix=`${PYTHON} -c "import sys; print sys.prefix"`

   python_includespec="-I${python_prefix}/include/python${python_version}"

   pushd PyGreSQL

   gcc $CFLAGS -fpic -shared -o _pgmodule.so ${python_includespec} -I../src/interfaces/libpq -I../src/include -L../src/interfaces/libpq -lpq pgmodule.c

   popd

%endif

%if %tcl

   pushd Pgtcl

   # pgtcl's configure only handles one include directory :-(

   ./configure --prefix=/usr \

     --libdir=%{_libdir} \

     --with-tcl=%{_libdir} \

     --with-postgres-include="../src/interfaces/libpq -I../src/include" \

     --with-postgres-lib=../src/interfaces/libpq

   # note: as of pgtcl 1.5.2, its makefile is not parallel-safe

   make all

   popd

%endif

%install

rm -rf $RPM_BUILD_ROOT

make DESTDIR=$RPM_BUILD_ROOT install

make -C contrib DESTDIR=$RPM_BUILD_ROOT install

%if %xml

make -C contrib/xml2 DESTDIR=$RPM_BUILD_ROOT install

%endif

install -d -m 755 $RPM_BUILD_ROOT%{_libdir}/pgsql/tutorial

cp src/tutorial/* $RPM_BUILD_ROOT%{_libdir}/pgsql/tutorial

%if %jdbc

	# Java/JDBC

	# Red Hat's standard place to put jarfiles is /usr/share/java

	# JDBC jars 

	install -d $RPM_BUILD_ROOT/usr/share/java

	install -m 644 %{SOURCE8} $RPM_BUILD_ROOT/usr/share/java

	install -m 644 %{SOURCE9} $RPM_BUILD_ROOT/usr/share/java

	install -m 644 %{SOURCE10} $RPM_BUILD_ROOT/usr/share/java

	# Versionless symlinks to the versioned jars

	pushd $RPM_BUILD_ROOT/usr/share/java

	ln -s `basename %{SOURCE8}` postgresql-jdbc2.jar

	ln -s `basename %{SOURCE9}` postgresql-jdbc2ee.jar

	ln -s `basename %{SOURCE10}` postgresql-jdbc3.jar

	popd

%endif

%if %tcl

	install -d -m 755 $RPM_BUILD_ROOT%{_libdir}/Pgtcl

	cp Pgtcl/pkgIndex.tcl $RPM_BUILD_ROOT%{_libdir}/Pgtcl

	cp Pgtcl/libpgtcl*.so $RPM_BUILD_ROOT%{_libdir}/Pgtcl

%endif

if [ -d /etc/rc.d/init.d ]

then

	install -d $RPM_BUILD_ROOT/etc/rc.d/init.d

	sed 's/^PGVERSION=.*$/PGVERSION=%{version}/' <%{SOURCE3} >postgresql.init

	install -m 755 postgresql.init $RPM_BUILD_ROOT/etc/rc.d/init.d/postgresql

fi

%if %pam

if [ -d /etc/pam.d ]

then

	install -d $RPM_BUILD_ROOT/etc/pam.d

	install -m 644 %{SOURCE14} $RPM_BUILD_ROOT/etc/pam.d/postgresql

fi

%endif

# Remove stuff we don't want to ship.

rm -f $RPM_BUILD_ROOT%{_bindir}/findoidjoins

rm -f $RPM_BUILD_ROOT%{_bindir}/make_oidjoins_check

rm -f $RPM_BUILD_ROOT%{_docdir}/pgsql/contrib/README.findoidjoins

rm -f contrib/findoidjoins/README.findoidjoins

# PGDATA needs removal of group and world permissions due to pg_pwd hole.

install -d -m 700 $RPM_BUILD_ROOT/var/lib/pgsql/data

# backups of data go here...

install -d -m 700 $RPM_BUILD_ROOT/var/lib/pgsql/backups

# postgres' .bash_profile

install -m 644 %{SOURCE15} $RPM_BUILD_ROOT/var/lib/pgsql/.bash_profile

# Create the multiple postmaster startup directory

install -d -m 700 $RPM_BUILD_ROOT/etc/sysconfig/pgsql

%if %test

	# tests. There are many files included here that are unnecessary,

	# but include them anyway for completeness.  We replace the original

	# Makefiles, however.

	mkdir -p $RPM_BUILD_ROOT%{_libdir}/pgsql/test

	cp -a src/test/regress $RPM_BUILD_ROOT%{_libdir}/pgsql/test

	install -m 0755 contrib/spi/refint.so $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress

	install -m 0755 contrib/spi/autoinc.so $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress

	pushd  $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress

	strip *.so

	rm -f GNUmakefile Makefile

	popd

	cp %{SOURCE4} $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress/Makefile

	chmod 0644 $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress/Makefile

%endif

# Fix some more documentation

# gzip doc/internals.ps

cp %{SOURCE6} README.rpm-dist

mv $RPM_BUILD_ROOT%{_docdir}/pgsql/html doc

rm -rf $RPM_BUILD_ROOT%{_docdir}/pgsql

%if %python

   pushd PyGreSQL

   install -m 0755 -d $RPM_BUILD_ROOT%{_libdir}/python%{pyver}/site-packages

   install -m 0755 _pgmodule.so $RPM_BUILD_ROOT%{_libdir}/python%{pyver}/site-packages

   install -m 0644 pg.py $RPM_BUILD_ROOT%{_libdir}/python%{pyver}/site-packages

   install -m 0644 pgdb.py $RPM_BUILD_ROOT%{_libdir}/python%{pyver}/site-packages

   popd

%endif

%find_lang libpq

%find_lang initdb

%find_lang pg_config

%find_lang pg_ctl

%find_lang pg_dump

%find_lang postgres

%find_lang psql

%find_lang pg_resetxlog

%find_lang pg_controldata

%find_lang pgscripts

cat libpq.lang > libpq.lst

cat pg_config.lang > pg_config.lst

cat initdb.lang pg_ctl.lang psql.lang pg_dump.lang pgscripts.lang > main.lst

cat postgres.lang pg_resetxlog.lang pg_controldata.lang > server.lst

%post libs -p /sbin/ldconfig 

%postun libs -p /sbin/ldconfig 

%pre server

groupadd -g 26 -o -r postgres >/dev/null 2>&1 || :

useradd -M -n -g postgres -o -r -d /var/lib/pgsql -s /bin/bash \

	-c "PostgreSQL Server" -u 26 postgres >/dev/null 2>&1 || :

# If we're upgrading from rh-postgresql, we have to repeat the above actions

# after rh-postgresql-server is uninstalled, because its postun script runs

# after our pre script ...

%triggerpostun -n postgresql-server -- rh-postgresql-server

groupadd -g 26 -o -r postgres >/dev/null 2>&1 || :

useradd -M -n -g postgres -o -r -d /var/lib/pgsql -s /bin/bash \

	-c "PostgreSQL Server" -u 26 postgres >/dev/null 2>&1 || :

%post server

chkconfig --add postgresql

/sbin/ldconfig

%preun server

if [ $1 = 0 ] ; then

	/sbin/service postgresql condstop >/dev/null 2>&1

	chkconfig --del postgresql

fi

%postun server

/sbin/ldconfig 

if [ $1 -ge 1 ] ; then

	/sbin/service postgresql condrestart >/dev/null 2>&1 || :

fi

if [ $1 = 0 ] ; then

	userdel postgres >/dev/null 2>&1 || :

	groupdel postgres >/dev/null 2>&1 || : 

fi

%if %pls

%post -p /sbin/ldconfig   pl

%postun -p /sbin/ldconfig   pl

%endif

%if %test

%post test

chown -R postgres:postgres /usr/share/pgsql/test >/dev/null 2>&1 || :

%endif

%clean

rm -rf $RPM_BUILD_ROOT

# FILES section.

%files -f main.lst

%defattr(-,root,root)

%doc doc/FAQ doc/KNOWN_BUGS doc/MISSING_FEATURES doc/README* 

%doc COPYRIGHT README HISTORY doc/bug.template

%doc README.rpm-dist

%doc doc/html

%{_bindir}/clusterdb

%{_bindir}/createdb

%{_bindir}/createlang

%{_bindir}/createuser

%{_bindir}/dropdb

%{_bindir}/droplang

%{_bindir}/dropuser

%{_bindir}/pg_dump

%{_bindir}/pg_dumpall

%{_bindir}/pg_restore

%{_bindir}/psql

%{_bindir}/vacuumdb

%{_mandir}/man1/clusterdb.*

%{_mandir}/man1/createdb.*

%{_mandir}/man1/createlang.*

%{_mandir}/man1/createuser.*

%{_mandir}/man1/dropdb.*

%{_mandir}/man1/droplang.*

%{_mandir}/man1/dropuser.*

%{_mandir}/man1/pg_dump.*

%{_mandir}/man1/pg_dumpall.*

%{_mandir}/man1/pg_restore.*

%{_mandir}/man1/psql.*

%{_mandir}/man1/vacuumdb.*

%{_mandir}/man7/*

%dir %{_libdir}/pgsql

%files docs

%defattr(-,root,root)

%doc doc/src/FAQ

%doc *-US.pdf

%{_libdir}/pgsql/tutorial/

%files contrib

%defattr(-,root,root)

%{_libdir}/pgsql/_int.so

%{_libdir}/pgsql/autoinc.so

%{_libdir}/pgsql/btree_gist.so

%{_libdir}/pgsql/chkpass.so

%{_libdir}/pgsql/cube.so

%{_libdir}/pgsql/dblink.so

%{_libdir}/pgsql/dbsize.so

%{_libdir}/pgsql/earthdistance.so

%{_libdir}/pgsql/fti.so

%{_libdir}/pgsql/fuzzystrmatch.so

%{_libdir}/pgsql/insert_username.so

%{_libdir}/pgsql/int_aggregate.so

%{_libdir}/pgsql/isbn_issn.so

%{_libdir}/pgsql/lo.so

%{_libdir}/pgsql/ltree.so

%{_libdir}/pgsql/misc_utils.so

%{_libdir}/pgsql/moddatetime.so

%{_libdir}/pgsql/noup.so

%{_libdir}/pgsql/pending.so

%{_libdir}/pgsql/pgcrypto.so

%{_libdir}/pgsql/pgstattuple.so

%{_libdir}/pgsql/pg_trgm.so

%{_libdir}/pgsql/refint.so

%{_libdir}/pgsql/rtree_gist.so

%{_libdir}/pgsql/seg.so

%{_libdir}/pgsql/string_io.so

%{_libdir}/pgsql/tablefunc.so

%{_libdir}/pgsql/timetravel.so

%{_libdir}/pgsql/tsearch.so

%{_libdir}/pgsql/tsearch2.so

%{_libdir}/pgsql/user_locks.so

%if %xml

%{_libdir}/pgsql/pgxml.so

%endif

%{_datadir}/pgsql/contrib/

%{_bindir}/DBMirror.pl

%{_bindir}/clean_pending.pl

%{_bindir}/my2pg.pl

%{_bindir}/mysql2pgsql

%{_bindir}/dbf2pg

%{_bindir}/fti.pl

%{_bindir}/oid2name

%{_bindir}/pg_dumplo

%{_bindir}/pgbench

%{_bindir}/vacuumlo

%{_bindir}/pg_autovacuum

%doc contrib/*/README.* contrib/spi/*.example

%files libs -f libpq.lang

%defattr(-,root,root)

%{_libdir}/libpq.so.*

%{_libdir}/libecpg.so.*

%{_libdir}/libpgtypes.so.*

%{_libdir}/libecpg_compat.so.*

%files server -f server.lst

%defattr(-,root,root)

/etc/rc.d/init.d/postgresql

%if %pam

/etc/pam.d/postgresql

%endif

%attr (755,root,root) %dir /etc/sysconfig/pgsql

%{_bindir}/initdb

%{_bindir}/ipcclean

%{_bindir}/pg_controldata

%{_bindir}/pg_ctl

%{_bindir}/pg_resetxlog

%{_bindir}/postgres

%{_bindir}/postmaster

%{_mandir}/man1/initdb.*

%{_mandir}/man1/ipcclean.*

%{_mandir}/man1/pg_controldata.*

%{_mandir}/man1/pg_ctl.*

%{_mandir}/man1/pg_resetxlog.*

%{_mandir}/man1/postgres.*

%{_mandir}/man1/postmaster.*

%{_datadir}/pgsql/postgres.bki

%{_datadir}/pgsql/postgres.description

%{_datadir}/pgsql/system_views.sql

%{_datadir}/pgsql/*.sample

%{_datadir}/pgsql/timezone/

%{_libdir}/pgsql/plpgsql.so

%dir %{_datadir}/pgsql

%attr(700,postgres,postgres) %dir /var/lib/pgsql

%attr(700,postgres,postgres) %dir /var/lib/pgsql/data

%attr(700,postgres,postgres) %dir /var/lib/pgsql/backups

%attr(644,postgres,postgres) %config(noreplace) /var/lib/pgsql/.bash_profile

%{_libdir}/pgsql/*_and_*.so

%{_datadir}/pgsql/conversion_create.sql

%{_datadir}/pgsql/information_schema.sql

%{_datadir}/pgsql/sql_features.txt

%files devel -f pg_config.lst

%defattr(-,root,root)

/usr/include/*

%{_bindir}/ecpg

%{_bindir}/pg_config

%{_libdir}/libpq.so

%{_libdir}/libecpg.so

%{_libdir}/libpq.a

%{_libdir}/libecpg.a

%{_libdir}/libecpg_compat.so

%{_libdir}/libecpg_compat.a

%{_libdir}/libpgport.a

%{_libdir}/libpgtypes.so

%{_libdir}/libpgtypes.a

%{_libdir}/pgsql/pgxs/

%{_mandir}/man1/ecpg.*

%{_mandir}/man1/pg_config.*

%if %tcl

%files tcl

%defattr(-,root,root)

%{_libdir}/Pgtcl/

%doc Pgtcl-docs/*

%endif

%if %pls

%files pl

%defattr(-,root,root)

%if %plperl

%{_libdir}/pgsql/plperl.so

%endif

%if %pltcl

%{_libdir}/pgsql/pltcl.so

%{_bindir}/pltcl_delmod

%{_bindir}/pltcl_listmod

%{_bindir}/pltcl_loadmod

%{_datadir}/pgsql/unknown.pltcl

%endif

%if %python

%{_libdir}/pgsql/plpython.so

%endif

%endif

%if %python

%files python

%defattr(-,root,root)

%doc PyGreSQL/tutorial PyGreSQL/Announce PyGreSQL/ChangeLog PyGreSQL/README

%{_libdir}/python%{pyver}/site-packages/_pgmodule.so

%{_libdir}/python%{pyver}/site-packages/*.py

%endif

%if %jdbc

%files jdbc

%defattr(-,root,root)

%{_datadir}/java/*

%endif

%if %test

%files test

%defattr(-,postgres,postgres)

%attr(-,postgres,postgres) %{_libdir}/pgsql/test/*

%attr(-,postgres,postgres) %dir %{_libdir}/pgsql/test

%endif