File postgres.spec of Package postgresql

%define        groupid 65009
%define        userid  65009
%define        majver %(echo %version | cut -d. -f 1-2)

Name:          postgresql
Version:       10.2
Release:       1
Summary:       An object-relational database management system (ORDBMS)
Group:         Applications/Databases
URL:           http://www.postgresql.org
Source0:       ftp://ftp2.it.postgresql.org/pub/mirrors/postgres/source/%{version}/%{name}-%{version}.tar.gz
Source1:       postgresql.service
License:       BSD
BuildRoot:     %{_tmppath}/%{name}-%{version}-root
BuildRequires: openssl-devel
Requires:      lib%{name} == %{version}

%description
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department.
The POSTGRES project, led by Professor Michael Stonebraker, was sponsored by the Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc.

PostgreSQL is an open-source descendant of this original Berkeley code.
It provides SQL92/SQL99 language support and other modern features.

%package -n lib%{name}
Summary:       Devel files for PostgreSQL
Group:         System/Libraries

%description -n lib%{name}
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department.
The POSTGRES project, led by Professor Michael Stonebraker, was sponsored by the Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc.

This package contains the libraries used by postgresql.

%package -n lib%{name}-devel
Summary:       Devel files for PostgreSQL
Group:         Development/Libraries
Requires:      lib%{name} = %{version}
Provides:      %{name}-devel == %{version}

%description -n lib%{name}-devel
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department.
The POSTGRES project, led by Professor Michael Stonebraker, was sponsored by the Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc.

This package contains static libraries and header files need for development.

%package server
Summary:       PostgreSQL DBMS server
Group:         Applications/Databases
Requires:      %{name} = %{version}

%description server
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department.
The POSTGRES project, led by Professor Michael Stonebraker, was sponsored by the Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc.
PostgreSQL is an open-source descendant of this original Berkeley code.
It provides SQL92/SQL99 language support and other modern features.

This is the DBMS server.

%package       contrib
Summary:       Contributed source and binaries distributed with PostgreSQL
Group:         Applications/Databases
Requires:      %{name} = %{version}-%{release}

%description   contrib
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department.
The POSTGRES project, led by Professor Michael Stonebraker, was sponsored by the Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc.

The postgresql-contrib package contains contributed packages that are
included in the PostgreSQL distribution.

%package        test
Summary:        The test suite distributed with PostgreSQL
Group:          Applications/Databases
Requires:       %{name}-server = %{version}-%{release}

%description   test
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department.
The POSTGRES project, led by Professor Michael Stonebraker, was sponsored by the Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc.

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.

%package         docs
Summary:         Extra documentation for PostgreSQL
Group:           Documentation
Requires:        %{name} = %{version}-%{release}

%description     docs
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department.
The POSTGRES project, led by Professor Michael Stonebraker, was sponsored by the Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc.

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.

%prep
%setup -q

%build

./configure \
   --prefix=%{_prefix} \
   --mandir=%{_mandir} \
   --disable-rpath \
   --without-readline \
   --without-zlib \
   --with-openssl

make
make -C contrib all

sed "s|C=\`pwd\`;|C=%{_libdir}/postgresql/tutorial;|" < src/tutorial/Makefile > src/tutorial/GNUmakefile
make -C src/tutorial NO_PGXS=1 all

rm -f src/tutorial/GNUmakefile

(cd src/test/regress
make all
)

%install
[ "%{buildroot}" != / ] && rm -rf "%{buildroot}"
make install DESTDIR=%{buildroot} install
make -C contrib DESTDIR=%{buildroot} install

mkdir -p %{buildroot}%{_libdir}/postgresql/test

cp -a src/test/regress %{buildroot}%{_libdir}/postgresql/test

install -m 0755 contrib/spi/refint.so %{buildroot}%{_libdir}/postgresql/test/regress
install -m 0755 contrib/spi/autoinc.so %{buildroot}%{_libdir}/postgresql/test/regress
install -D -m 0755 %{S:1} %{buildroot}/etc/systemd/system/postgresql.service
(cd  %{buildroot}%{_libdir}/postgresql/test/regress
strip *.so
)

install -d -m 755 %{buildroot}%{_libdir}/postgresql/tutorial
cp src/tutorial/* %{buildroot}%{_libdir}/postgresql/tutorial

install -d %{buildroot}/var/spool/pgsql

%clean
[ "%{buildroot}" != / ] && rm -rf "%{buildroot}"

%post -n lib%{name}
/sbin/ldconfig

%postun -n lib%{name}
/sbin/ldconfig

%files 
%defattr(-,root,root)
%{_bindir}/clusterdb
%{_bindir}/create*
%{_bindir}/drop*
%{_bindir}/init*
%{_bindir}/pg_*
%exclude %{_bindir}/pg_config 
%{_bindir}/psql
%{_bindir}/reindexdb
%{_bindir}/vacuumdb
%dir %{_datadir}/doc/postgresql
%{_datadir}/doc/postgresql/*
%doc COPYRIGHT HISTORY README

%files server
%defattr(-,root,root)
%{_bindir}/postmaster
%{_bindir}/postgres
/etc/systemd/system/postgresql.service
%attr(700,postgres,root) %dir %{_localstatedir}/spool/pgsql

%files -n lib%{name}
%defattr(-,root,root)
%{_libdir}/*.so.*
%dir %{_libdir}/postgresql
%{_libdir}/postgresql/*.so
%exclude %{_libdir}/postgresql/_int.so
%exclude %{_libdir}/postgresql/adminpack.so
%exclude %{_libdir}/postgresql/autoinc.so
%exclude %{_libdir}/postgresql/btree_gist.so
%exclude %{_libdir}/postgresql/chkpass.so
%exclude %{_libdir}/postgresql/cube.so
%exclude %{_libdir}/postgresql/dblink.so
%exclude %{_libdir}/postgresql/dict_int.so
%exclude %{_libdir}/postgresql/dict_xsyn.so
%exclude %{_libdir}/postgresql/earthdistance.so
%exclude %{_libdir}/postgresql/fuzzystrmatch.so
%exclude %{_libdir}/postgresql/hstore.so
%exclude %{_libdir}/postgresql/insert_username.so
%exclude %{_libdir}/postgresql/isn.so
%exclude %{_libdir}/postgresql/lo.so
%exclude %{_libdir}/postgresql/ltree.so
%exclude %{_libdir}/postgresql/moddatetime.so
%exclude %{_libdir}/postgresql/pageinspect.so
%exclude %{_libdir}/postgresql/pg_buffercache.so
%exclude %{_libdir}/postgresql/pg_freespacemap.so
%exclude %{_libdir}/postgresql/pg_trgm.so
%exclude %{_libdir}/postgresql/pgcrypto.so
%exclude %{_libdir}/postgresql/pgrowlocks.so
%exclude %{_libdir}/postgresql/pgstattuple.so
%exclude %{_libdir}/postgresql/refint.so
%exclude %{_libdir}/postgresql/seg.so
%exclude %{_libdir}/postgresql/sslinfo.so
%exclude %{_libdir}/postgresql/tablefunc.so
%exclude %{_libdir}/postgresql/timetravel.so
%{_datadir}/postgresql/*

%files -n lib%{name}-devel
%defattr(-,root,root)
%{_bindir}/ecpg
%{_bindir}/pg_config
%dir %{_includedir}/postgresql
%{_includedir}/postgresql/*
%dir %{_includedir}/libpq
%{_includedir}/libpq/*
%{_includedir}/*.h
%{_libdir}/*.a
%{_libdir}/*.so
%{_libdir}/postgresql/pgxs/config/*
%{_libdir}/postgresql/pgxs/src/*
%{_libdir}/pkgconfig/libecpg.pc
%{_libdir}/pkgconfig/libecpg_compat.pc
%{_libdir}/pkgconfig/libpgtypes.pc
%{_libdir}/pkgconfig/libpq.pc

%files contrib
%defattr(-,root,root)
%dir %{_libdir}/postgresql
%{_libdir}/postgresql/_int.so
%{_libdir}/postgresql/adminpack.so
%{_libdir}/postgresql/autoinc.so
%{_libdir}/postgresql/btree_gist.so
%{_libdir}/postgresql/chkpass.so
%{_libdir}/postgresql/cube.so
%{_libdir}/postgresql/dblink.so
%{_libdir}/postgresql/dict_int.so
%{_libdir}/postgresql/dict_xsyn.so
%{_libdir}/postgresql/earthdistance.so
%{_libdir}/postgresql/fuzzystrmatch.so
%{_libdir}/postgresql/hstore.so
%{_libdir}/postgresql/insert_username.so
%{_libdir}/postgresql/isn.so
%{_libdir}/postgresql/lo.so
%{_libdir}/postgresql/ltree.so
%{_libdir}/postgresql/moddatetime.so
%{_libdir}/postgresql/pageinspect.so
%{_libdir}/postgresql/pg_buffercache.so
%{_libdir}/postgresql/pg_freespacemap.so
%{_libdir}/postgresql/pg_trgm.so
%{_libdir}/postgresql/pgcrypto.so
%{_libdir}/postgresql/pgrowlocks.so
%{_libdir}/postgresql/pgstattuple.so
%{_libdir}/postgresql/refint.so
%{_libdir}/postgresql/seg.so
%{_libdir}/postgresql/sslinfo.so
%{_libdir}/postgresql/tablefunc.so
%{_libdir}/postgresql/timetravel.so
%{_bindir}/oid2name
%{_bindir}/pgbench
%{_bindir}/vacuumlo

%files test
%defattr(-,postgres,postgres)
%attr(-,postgres,postgres) %{_libdir}/postgresql/test/*
%attr(-,postgres,postgres) %dir %{_libdir}/postgresql/test
%exclude %{_libdir}/postgresql/test/*/*/.gitignore

%files docs
%defattr(-,root,root)
%doc doc/src/sgml
%dir %{_libdir}/postgresql/tutorial
%{_libdir}/postgresql/tutorial/*

%changelog