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

# or a derivative thereof.

# Copyright 2003-2009 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.

# In 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.

%global beta 0

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

%{!?tcldevel:%global tcldevel 1}

%{!?test:%global test 1}

%{!?plpython:%global plpython 1}

%{!?pltcl:%global pltcl 1}

%{!?plperl:%global plperl 1}

%{!?python:%global python 1}

%{!?tcl:%global tcl 1}

%{!?ssl:%global ssl 1}

%{!?kerberos:%global kerberos 1}

%{!?ldap:%global ldap 1}

%{!?nls:%global nls 1}

%{!?uuid:%global uuid 1}

%{!?xml:%global xml 1}

%{!?pam:%global pam 1}

%{!?sdt:%global sdt 1}

%{!?pgfts:%global pgfts 1}

%{!?runselftest:%global runselftest 1}

# Python major version.

%{!?python_sitearch: %global python_sitearch %(%{__python} -c "from distutils.sysconfig import get_python_lib; print get_python_lib(1)")}

Summary: PostgreSQL client programs

Name: postgresql

%global majorversion 8.4

Version: 8.4.5

Release: 1%{?dist}

# The PostgreSQL license is very similar to other MIT licenses, but the OSI

# recognizes it as an independent license, so we do as well.

License: PostgreSQL

Group: Applications/Databases

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

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

Source3: postgresql.init

Source4: Makefile.regress

Source5: pg_config.h

Source6: README.rpm-dist

Source7: ecpg_config.h

Source14: postgresql.pam

Source15: postgresql-bashprofile

Source16: filter-requires-perl-Pg.sh

Source17: http://www.postgresql.org/docs/manuals/postgresql-%{version}-US.pdf

Source18: ftp://ftp.pygresql.org/pub/distrib/PyGreSQL-3.8.1.tgz

Source19: http://pgfoundry.org/projects/pgtclng/pgtcl1.6.2.tar.gz

Source20: http://pgfoundry.org/projects/pgtclng/pgtcldocs-20070115.zip

# Comments for these patches are in the patch files.

Patch1: rpm-pgsql.patch

Patch2: postgresql-ac-version.patch

Patch3: postgresql-logging.patch

Patch4: postgresql-oom-adj.patch

Patch5: pgtcl-no-rpath.patch

Patch6: postgresql-perl-rpath.patch

BuildRequires: perl(ExtUtils::MakeMaker) glibc-devel bison flex autoconf gawk

BuildRequires: perl(ExtUtils::Embed), perl-devel

# for /sbin/ldconfig

Requires(post): glibc initscripts

Requires(postun): glibc initscripts

%if %python || %plpython

BuildRequires: python-devel

%endif

%if %tcl || %pltcl

BuildRequires: tcl

%if %tcldevel

BuildRequires: tcl-devel

%endif

%endif

BuildRequires: readline-devel

BuildRequires: zlib-devel >= 1.0.4

%if %ssl

BuildRequires: openssl-devel

%endif

%if %kerberos

BuildRequires: krb5-devel

%endif

%if %ldap

BuildRequires: openldap-devel

%endif

%if %nls

BuildRequires: gettext >= 0.10.35

%endif

%if %uuid

BuildRequires: uuid-devel

%endif

%if %xml

BuildRequires: libxml2-devel libxslt-devel

%endif

%if %pam

BuildRequires: pam-devel

%endif

%if %sdt

BuildRequires: systemtap-sdt-devel

%endif

# main package requires -libs subpackage

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

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

%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 local or 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 = %{version}-%{release}

%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

Requires: %{name} = %{version}-%{release}

Requires(pre): /usr/sbin/useradd

Requires(post): chkconfig

Requires(preun): chkconfig

# This is for /sbin/service

Requires(preun): initscripts

Requires(postun): initscripts

%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

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

%description docs

The postgresql-docs package includes some additional documentation for

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

and source files for the PostgreSQL tutorial.

%package contrib

Summary: Contributed modules distributed with PostgreSQL

Group: Applications/Databases

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

%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

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

%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 %plperl

%package plperl

Summary: The Perl procedural language for PostgreSQL

Group: Applications/Databases

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

Requires: perl(:MODULE_COMPAT_%(eval "`%{__perl} -V:version`"; echo $version))

%description plperl

PostgreSQL is an advanced Object-Relational database management

system.  The postgresql-plperl package contains the PL/Perl

procedural language for the backend.

%endif

%if %plpython

%package plpython

Summary: The Python procedural language for PostgreSQL

Group: Applications/Databases

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

%description plpython

PostgreSQL is an advanced Object-Relational database management

system.  The postgresql-plpython package contains the PL/Python

procedural language for the backend.

%endif

%if %pltcl

%package pltcl

Summary: The Tcl procedural language for PostgreSQL

Group: Applications/Databases

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

%description pltcl

PostgreSQL is an advanced Object-Relational database management

system.  The postgresql-pltcl package contains the PL/Tcl

procedural language for the backend.

%endif

%if %tcl

%package tcl

Summary: A Tcl client library for PostgreSQL

Group: Applications/Databases

# this is intentionally not a version-specific Requires:

Requires: libpq.so

Requires: tcl >= 8.5

%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

# this is intentionally not a version-specific Requires:

Requires: libpq.so

Requires: python mx

%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 %test

%package test

Summary: The test suite distributed with PostgreSQL

Group: Applications/Databases

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

%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

%global __perl_requires %{SOURCE16}

%prep

%setup -q 

%patch1 -p1

%patch2 -p1

%patch3 -p1

%patch4 -p1

# patch5 is applied later

%patch6 -p1

autoconf

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 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

   pushd Pgtcl

%patch5 -p1

   autoconf

   popd

%endif

%build

# fail quickly and obviously if user tries to build as root

%if %runselftest

	if [ x"`id -u`" = x0 ]; then

		echo "postgresql's regression tests fail if run as root."

		echo "If you really need to build the RPM as root, use"

		echo "--define='runselftest 0' to skip the regression tests."

		exit 1

	fi

%endif

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

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

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

# Add LINUX_OOM_ADJ=0 to ensure child processes reset postmaster's oom_adj

CFLAGS="$CFLAGS -DLINUX_OOM_ADJ=0"

# let's try removing this kluge, it may just be a workaround for bz#520916

# # use -O1 on sparc64 and alpha

# %ifarch sparc64 alpha

# CFLAGS=`echo $CFLAGS| sed -e "s|-O2|-O1|g" `

# %endif

%configure --disable-rpath \

%if %beta

	--enable-debug \

	--enable-cassert \

%endif

%if %plperl

	--with-perl \

%endif

%if %pltcl

	--with-tcl \

	--with-tclconfig=%{_libdir} \

%endif

%if %plpython

	--with-python \

%endif

%if %ldap

	--with-ldap \

%endif

%if %ssl

	--with-openssl \

%endif

%if %pam

	--with-pam \

%endif

%if %kerberos

	--with-krb5 \

	--with-gssapi \

%endif

%if %uuid

	--with-ossp-uuid \

%endif

%if %xml

	--with-libxml \

	--with-libxslt \

%endif

%if %nls

	--enable-nls \

%endif

%if %sdt

	--enable-dtrace \

%endif

%if %pgfts

	--enable-thread-safety \

%endif

	--with-system-tzdata=/usr/share/zoneinfo \

	--sysconfdir=/etc/sysconfig/pgsql \

	--datadir=/usr/share/pgsql \

	--with-docdir=%{_docdir}

make %{?_smp_mflags} all

make %{?_smp_mflags} -C contrib all

# 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 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

# multilib header hack; note pg_config.h is installed in two places!

# we only apply this to known Red Hat multilib arches, per bug #177564

case `uname -i` in

  i386 | x86_64 | ppc | ppc64 | s390 | s390x | sparc | sparc64 )

    mv $RPM_BUILD_ROOT/usr/include/pg_config.h $RPM_BUILD_ROOT/usr/include/pg_config_`uname -i`.h

    install -m 644 %{SOURCE5} $RPM_BUILD_ROOT/usr/include/

    mv $RPM_BUILD_ROOT/usr/include/pgsql/server/pg_config.h $RPM_BUILD_ROOT/usr/include/pgsql/server/pg_config_`uname -i`.h

    install -m 644 %{SOURCE5} $RPM_BUILD_ROOT/usr/include/pgsql/server/

    mv $RPM_BUILD_ROOT/usr/include/ecpg_config.h $RPM_BUILD_ROOT/usr/include/ecpg_config_`uname -i`.h

    install -m 644 %{SOURCE7} $RPM_BUILD_ROOT/usr/include/

    ;;

  *)

    ;;

esac

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

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

%if %tcl

	TCL_VERSION=`echo 'puts $tcl_version' | tclsh`

	TCLLIBDIR="%{_libdir}/tcl$TCL_VERSION"

	# check the target directory is a dir, not a symlink

	if [ -h "$TCLLIBDIR" ] ; then

		echo "$TCLLIBDIR must not be a symlink"

		exit 1

	fi

	PGTCL_DIR="${RPM_BUILD_ROOT}${TCLLIBDIR}/Pgtcl"

	install -d -m 755 "$PGTCL_DIR"

	cp Pgtcl/pkgIndex.tcl "$PGTCL_DIR"

	cp Pgtcl/libpgtcl*.so "$PGTCL_DIR"

%endif

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

%if %pam

install -d $RPM_BUILD_ROOT/etc/pam.d

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

%endif

# 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

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

	strip *.so

	rm -f GNUmakefile Makefile *.o

	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%{python_sitearch}

   install -m 0755 _pgmodule.so $RPM_BUILD_ROOT%{python_sitearch}

   install -m 0644 pg.py $RPM_BUILD_ROOT%{python_sitearch}

   install -m 0644 pgdb.py $RPM_BUILD_ROOT%{python_sitearch}

   popd

%endif

%find_lang ecpg-%{majorversion}

cat ecpg-%{majorversion}.lang >devel.lst

%find_lang ecpglib6-%{majorversion}

cat ecpglib6-%{majorversion}.lang >libs.lst

%find_lang initdb-%{majorversion}

cat initdb-%{majorversion}.lang >server.lst

%find_lang libpq5-%{majorversion}

cat libpq5-%{majorversion}.lang >>libs.lst

%find_lang pg_config-%{majorversion}

cat pg_config-%{majorversion}.lang >>devel.lst

%find_lang pg_controldata-%{majorversion}

cat pg_controldata-%{majorversion}.lang >>server.lst

%find_lang pg_ctl-%{majorversion}

cat pg_ctl-%{majorversion}.lang >>server.lst

%find_lang pg_dump-%{majorversion}

cat pg_dump-%{majorversion}.lang >main.lst

%find_lang pg_resetxlog-%{majorversion}

cat pg_resetxlog-%{majorversion}.lang >>server.lst

%find_lang pgscripts-%{majorversion}

cat pgscripts-%{majorversion}.lang >>main.lst

%if %plperl

%find_lang plperl-%{majorversion}

cat plperl-%{majorversion}.lang >plperl.lst

%endif

%find_lang plpgsql-%{majorversion}

cat plpgsql-%{majorversion}.lang >>server.lst

%if %plpython

%find_lang plpython-%{majorversion}

cat plpython-%{majorversion}.lang >plpython.lst

%endif

%if %pltcl

%find_lang pltcl-%{majorversion}

cat pltcl-%{majorversion}.lang >pltcl.lst

%endif

%find_lang postgres-%{majorversion}

cat postgres-%{majorversion}.lang >>server.lst

%find_lang psql-%{majorversion}

cat psql-%{majorversion}.lang >>main.lst

%post libs -p /sbin/ldconfig 

%postun libs -p /sbin/ldconfig 

%pre server

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

/usr/sbin/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

/sbin/chkconfig --add postgresql

/sbin/ldconfig

%preun server

if [ $1 = 0 ] ; then

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

	/sbin/chkconfig --del postgresql

fi

%postun server

/sbin/ldconfig 

if [ $1 -ge 1 ] ; then

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

fi

%if %plperl

%post -p /sbin/ldconfig plperl

%postun -p /sbin/ldconfig plperl

%endif

%if %plpython

%post -p /sbin/ldconfig plpython

%postun -p /sbin/ldconfig plpython

%endif

%if %pltcl

%post -p /sbin/ldconfig pltcl

%postun -p /sbin/ldconfig pltcl

%endif

%clean

rm -rf $RPM_BUILD_ROOT

# FILES section.

%files -f main.lst

%defattr(-,root,root)

%doc 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}/reindexdb

%{_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/reindexdb.*

%{_mandir}/man1/vacuumdb.*

%{_mandir}/man7/*

%dir %{_libdir}/pgsql

%files docs

%defattr(-,root,root)

%doc *-US.pdf

%{_libdir}/pgsql/tutorial/

%files contrib

%defattr(-,root,root)

%{_libdir}/pgsql/_int.so

%{_libdir}/pgsql/adminpack.so

%{_libdir}/pgsql/autoinc.so

%{_libdir}/pgsql/auto_explain.so

%{_libdir}/pgsql/btree_gin.so

%{_libdir}/pgsql/btree_gist.so

%{_libdir}/pgsql/chkpass.so

%{_libdir}/pgsql/citext.so

%{_libdir}/pgsql/cube.so

%{_libdir}/pgsql/dblink.so

%{_libdir}/pgsql/dict_int.so

%{_libdir}/pgsql/dict_xsyn.so

%{_libdir}/pgsql/earthdistance.so

%{_libdir}/pgsql/fuzzystrmatch.so

%{_libdir}/pgsql/hstore.so

%{_libdir}/pgsql/insert_username.so

%{_libdir}/pgsql/isn.so

%{_libdir}/pgsql/lo.so

%{_libdir}/pgsql/ltree.so

%{_libdir}/pgsql/moddatetime.so

%{_libdir}/pgsql/pageinspect.so

%{_libdir}/pgsql/pg_buffercache.so

%{_libdir}/pgsql/pg_freespacemap.so

%{_libdir}/pgsql/pg_trgm.so

%{_libdir}/pgsql/pgcrypto.so

%{_libdir}/pgsql/pgrowlocks.so

%{_libdir}/pgsql/pgstattuple.so

%{_libdir}/pgsql/pg_stat_statements.so

%{_libdir}/pgsql/refint.so

%{_libdir}/pgsql/seg.so

%{_libdir}/pgsql/sslinfo.so

%{_libdir}/pgsql/tablefunc.so

%{_libdir}/pgsql/test_parser.so

%{_libdir}/pgsql/timetravel.so

%{_libdir}/pgsql/tsearch2.so

%if %uuid

%{_libdir}/pgsql/uuid-ossp.so

%endif

%if %xml

%{_libdir}/pgsql/pgxml.so

%endif

%{_datadir}/pgsql/contrib/

%{_bindir}/oid2name

%{_bindir}/pg_standby

%{_bindir}/pgbench

%{_bindir}/vacuumlo

%doc contrib/spi/*.example

%files libs -f libs.lst

%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

%config(noreplace) /etc/pam.d/postgresql

%endif

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

%{_bindir}/initdb

%{_bindir}/pg_controldata

%{_bindir}/pg_ctl

%{_bindir}/pg_resetxlog

%{_bindir}/postgres

%{_bindir}/postmaster

%{_mandir}/man1/initdb.*

%{_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/postgres.shdescription

%{_datadir}/pgsql/system_views.sql

%{_datadir}/pgsql/*.sample

%{_datadir}/pgsql/timezonesets/

%{_datadir}/pgsql/tsearch_data/

%{_libdir}/pgsql/dict_snowball.so

%{_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/snowball_create.sql

%{_datadir}/pgsql/sql_features.txt

%files devel -f devel.lst