%include	/usr/lib/rpm/macros.perl
Summary:	PostgreSQL Data Base Management System
Summary(de):	PostgreSQL Datenbankverwaltungssystem
Summary(fr):	Sysème de gestion de base de données PostgreSQL.
Summary(pl):	PostgreSQL system bazodanowy
Summary(tr):	Veri Tabaný Yönetim Sistemi
Name:		postgresql
Version:	6.5.3
Release:	5
Copyright:	BSD
Group:		Applications/Databases
Group(pl):	Aplikacje/Bazy Danych
Source0:	ftp://ftp.postgresql.org/pub/%{name}-%{version}.tar.gz
Source1:	%{name}.init
Source2:	pgsql-Database-HOWTO-html.tar.gz
Source3:	%{name}.sysconfig
Patch0:		postgresql-opt.patch
Patch1:		postgresql-DESTDIR.patch
Patch2:		postgresql-perl.patch
URL:		http://www.postgresql.org/
Prereq:		/sbin/chkconfig
Requires:	rc-scripts
BuildRequires:	tcl-devel
BuildRequires:	tk-devel
BuildRequires:	readline-devel
BuildRequires:	ncurses-devel >= 5.0
BuildRequires:	rpm-perlprov
BuildRequires:	XFree86-devel
BuildRoot:	%{tmpdir}/%{name}-%{version}-root-%(id -u -n)
Requires:	%{name}-libs = %{version}

%define		_sysconfdir	/etc

%description
PostgreSQL Data Base Management System (formerly known as Postgres, then as
Postgres95). 

PostgreSQL is an enhancement of the POSTGRES database management system, a
next-generation DBMS research prototype.  While PostgreSQL retains the
powerful data model and rich data types of POSTGRES, it replaces the
PostQuel query language with an extended subset of SQL. PostgreSQL is free
and the complete source is available.

PostgreSQL development is being performed by a team of Internet developers
who all subscribe to the PostgreSQL development mailing list. The current
coordinator is Marc G. Fournier (scrappy@postgreSQL.org). This team is now
responsible for all current and future development of PostgreSQL.

The authors of PostgreSQL 1.01 were Andrew Yu and Jolly Chen. Many others
have contributed to the porting, testing, debugging and enhancement of the
code. The original Postgres code, from which PostgreSQL is derived, was the
effort of many graduate students, undergraduate students, and staff
programmers working under the direction of Professor Michael Stonebraker at
the University of California, Berkeley.

The original name of the software at Berkeley was Postgres. When SQL
functionality was added in 1995, its name was changed to Postgres95. The
name was changed at the end of 1996 to PostgreSQL.

PostgreSQL runs on Solaris, SunOS, HPUX, AIX, Linux, Irix, FreeBSD, and most
flavours of Unix. 

%description -l de
PostgreSQL Datenbank-Managementsystem (früher als Postgres, dann als 
Postgres95 bekannt).

PostgreSQL ist eine Verbesserung des POSTGRES-DB-Managementsystems, ein
DBMS-Forschungsprototyp der nächsten Generation. Während es das
leistungsfähige Datenmodell und die reichhaltigen Datentypen von POSTGRES
beibehält, ersetzt es die PostQuel-Abfragesprache durch ein Subset von SQL.
PostgreSQL ist gratis, der gesamte Quellcode ist verfügbar.

Ein Team von Internet-Entwicklern befaßt sich mit PostgreSQL. Sie alle sind
auf der PostgreSQL-Entwickleradreßliste. Koordinator ist Marc G. Fournier
(scrappy@postgreSQL.org). Das Team ist verantwortlich für alle aktuellen und
künftigen Entwicklungen von PostgreSQL.

Die Autoren von PostgreSQL 1.01 waren Andrew Yu und Jolly Chen. Zahlreiche
andere haben zur Portierung, zum Testen, Debugging und zur Verbesserung des
Code beigetragen. Den Original-Postgres-Code, von dem sich PostgreSQL
ableitet, verdanken wir der Arbeit vieler Doktoranden, Studenten und
Programmierern unter der Leitung von Professor Michael Stonebraker an der
University of California, Berkeley.

Der ursprüngliche Name war Postgres. Als 1995 SQL-Funktionalität hinzukam,
wurde der Name in Postgres95 geändert. Ende 1996 schließlich entschied man
sich für PostgreSQL.

PostgreSQL läuft auf Solaris, SunOS, HPUX, AIX, Linux, Irix, FreeBSD und den
meisten Unix-Systemen.

%description -l fr
Système de gestion de bases de données PostgreSQL (D'abord nommé Postgres,
puis Postgres95).

PostgreSQL est une amélioration du système de gestion de bases de données
POSTGRES, un prototype de recherche de la génération suivant DBMS. Tout en
conservant le puissant modèle de donnée de et les types de donée riches de
Postgres, il remplace le langage de requêtes de Postgres par un sous
ensemble etendu de commandes SQL. PosrgreSQL est libre, et ses sources sont
disponibles.

Le développement de PostgreSQL est actuellement réalisé via internet parune
équipe de développeurs inscrits sur la mailing-list de développement de
PostgreSQL. Le coordinateur actuel est Marc G Fournier
(scrappy@postgreSQL.org). Cette équipe est responsable du développemen
actuel et à venir de PostgreSQL.

Les auteurs de PostgreSQL 1.01 étaient Andrew Yu et Jolly Chen. Beaucoup
d'autres ont contribué au portage, au test, au débogage et à l'amélioration
du code. Le code original de Postgres, duquel PostgreSQL est dérivé, a été
l'oeuvre d'étudiants de haut niveau, de moins haut niveau, et de
programmeurs travaillant sous la direction du professeur Michael Stonebraker
à l'université de Berkeley Californie.

Le nom original du logiciel était Postgres. Quand les fonctionnalitées
SQL furent ajoutées en 1995, son nom est devenu Postgres95. Il a été 
rebaptisé PostgreSQL en 1996.

PostgreSQL tourne sur Solaris, SunOS, HPUX, AIX, Linux, Irix, FreeBSD,
et la plupart des Unix.

%description -l pl
PostgreSQL System Zarz±dzania Baz± Danych (dawniej znany jako Postgres,
nastêpnie jako Postgres95).

PostgreSQL mo¿e byæ uruchominy pod nastêpuj±cymi systemami: Solaris, SunOS, 
HPUX, AIX, Linux, Irix, FreeBSD i innych systemach Unix.

%description -l tr
PostgreSQL, POSTGRES'den türemiþ bir veri tabaný yönetim sistemidir (DBMS).
Güçlü veri modeli ve zengin POSTGRES veri tiplerini desteklerken SQL'in
geniþletilmiþ bir altkümesi yerine PostQuel sorgulama dilini koyar.

%package devel
Summary:	PostgreSQL development header files and libraries
Summary(de):	PostgreSQL-Entwicklungs-Header-Dateien und Libraries 
Summary(fr):	En-têtes et bibliothèques de développement PostgreSQL
Summary(pl):	PostgreSQL - pliki nag³ówkowe i biblioteki
Summary(tr):	PostgreSQL baþlýk dosyalarý ve kitaplýklar
Group:		Development/Libraries
Group(pl):	Programowanie/Biblioteki
Requires:	%{name}-libs = %{version}

%description devel
This package contains header files and libraries required to compile
applications that are talking directly to the PostgreSQL backend server. 

%description -l de devel
Dieses Paket enthält die Header-Dateien und Libraries, die zum Kompilieren
von Applikationen notwendig sind, die direkt mit dem
PostgreSQL-Backend-Server kommunizieren.

%description -l fr devel
Ce package contient les fichiers d'en-tête et les bibliothéques nécessaires
pour compiler des applications ayant des échanges directs avec le serveur du
backend PostgreSQL.

%description -l pl devel
Pakiet zawiera nag³ówki oraz biblioteki wymagane do kompilacji aplikacji 
³±cz±cych siê bezpo¶rednio z serwerem PostgreSQL.

%description -l tr devel
Bu paket, PostgreSQL sunucusuyla konuþacak yazýlýmlar geliþtirmek için
gereken baþlýk dosyalarýný ve kitaplýklarý içerir.

%package clients
Summary:	clients needed to access a PostgreSQL server
Summary(pl):	klienci wymagani do dostêpu do serwera PostgreSQL
Group:		Applications/Databases
Group(pl):	Aplikacje/Bazy Danych

%description clients
This package includes only the clients and client libraries needed to access
an PostgreSQL server. The server is included in the main package. If all you
need is to connect to another PostgreSQL server, the  this is the only
package you need to install.

In this package there are client libraries available for C and C++, as well
as several command-line utilities you can use to manage your databases on a
remote PostgreSQL server.

%description -l pl clients
Pakiet zawiera klientów oraz biblioteki niezbêdne dla dostêpu do serwera 
PostgreSQL. Serwer znajduje siê w g³ównym pakiecie.

%package perl
Summary:	Perl interface to PostgreSQL database
Summary(pl):	Interface dla Perl'a umo¿liwiaj±cy dostêp do baz PostgreSQL
Group:		Applications/Databases
Group(pl):	Aplikacje/Bazy Danych
Requires:	postgresql, perl >= 5.004

%description perl
This package includes only perl modules needed to access an PostgreSQL server.

%description -l pl perl
Pakiet ten zawiera tylko modu³y Perl'a wymagane dla dostêpu do serwera 
PostgreSQL.

%package doc
Summary:	Documentation for PostgreSQL
Summary(pl):	Dodatkowa dokumantacja dla PostgreSQL
Group:		Applications/Databases
Group(pl):	Aplikacje/Bazy Danych
#Requires:	%{name} = %{version}

%description doc
This package includes documentation and HOWTO for programmer, admin etc., in
HTML format.

%description -l pl doc
Pakiet ten zawiera dokumentacjê oraz HOWTO m.in. dla programistów,
administratorów w formacie HTML.

%package odbc
Summary:	ODBC interface to PostgreSQL
Summary(pl):	Interface ODBC do PostgreSQL
Group:		Applications/Databases
Group(pl):	Aplikacje/Bazy Danych
#Requires:	%{name} = %{version}

%description odbc
This package includes library for interface ODBC.

%description -l pl odbc
Pakiet ten zawiera biblioteki dla interface'u ODBC.

%package odbc-devel
Summary:	ODBC interface to PostgreSQL - development part
Summary(pl):	Interface ODBC do PostgreSQL - cze¶æ programistyczna
Group:		Applications/Databases
Group(pl):	Aplikacje/Bazy Danych
Requires:	%{name}-odbc = %{version}

%description odbc-devel
This package includes library and header files for interface ODBC.

%description -l pl odbc-devel
Pakiet ten zawiera biblioteki i pliki nag³ówkowe dla interface'u ODBC.

%package odbc-static
Summary:	ODBC interface to PostgreSQL - static libraries
Summary(pl):	Interface ODBC do PostgreSQL - biblioteki statyczne
Group:		Applications/Databases
Group(pl):	Aplikacje/Bazy Danych
#Requires:	%{name}-odbc-devel = %{version}

%description odbc-static
This package includes static library for interface ODBC.

%description -l pl odbc-static
Pakiet ten zawiera biblioteki statyczne dla interface'u ODBC.

%package libs
Summary:	PostgreSQL libraries
Summary(pl):	Biblioteki dzielone programu PostgreSQL
Group:		Libraries
Group(pl):	Biblioteki

%description libs
PostgreSQL libraries.

%description libs -l pl
Biblioteki dzielone programu PostgreSQL.

%package static
Summary:	PostgreSQL static libraries
Summary(pl):	Biblioteki statyczne programu PostgreSQL
Group:		Development/Libraries
Group(pl):	Programowanie/Biblioteki
Requires:	%{name}-devel = %{version}

%description static
PostgreSQL static libraries.

%description libs -l pl
Biblioteki statyczne programu PostgreSQL.

%package tcl
Summary:	tcl interface for PostgreSQL
Summary(pl):	tcl interface dla PostgreSQL
Group:		Development/Languages/Tcl
Group(pl):	Programowanie/Jêzyki/Tcl
#Requires:	%{name}-libs = %{version}

%description tcl
tcl interface for PostgreSQL.

%description tcl -l pl
tcl interface dla PostgreSQL.

%package tcl-devel
Summary:	Development part of tcl interface for PostgreSQL
Summary(pl):	Czê¶æ dla programistów interafece tcl dla PostgreSQL
Group:		Development/Languages/Tcl
Group(pl):      Programowanie/Jêzyki/Tcl
Requires:	%{name}-tcl = %{version}

%description tcl-devel
Development part of tcl interface for PostgreSQL.

%description tcl-devel -l pl
Czê¶æ dla programistów interafece tcl dla PostgreSQL.

%package tcl-static
Summary:        Static libraries of tcl interface for PostgreSQL
Summary(pl):    Biblioteki statyczne interafece tcl dla PostgreSQL
Group:          Development/Languages/Tcl
Group(pl):      Programowanie/Jêzyki/Tcl
Requires:       %{name}-tcl-devel = %{version}

%description tcl-static
Static libraries of tcl interface for PostgreSQL

%description tcl-devel -l pl
Biblioteki statyczne interafece tcl dla PostgreSQL

%prep
%setup  -q
%patch0 -p1 -b .opt
%patch1 -p1 -b .destdir
%patch2 -p1 -b .perl

# Erase all CVS dir
rm -fR `find contrib/ -type d -name CVS`

%build
PATH=$PATH:. ; export PATH
cd src

aclocal
autoconf
LDFLAGS="-s"; export LDFLAGS
%configure \
	--enable-hba \
	--enable-locale \
	--with-odbc \
	--with-odbcinst=%{_sysconfdir} \
	--with-tcl \
	--with-x \
	--with-mb=UNICODE \
%ifarch %{ix86}
	--with-template=linux_i386 \
%else
	--with-template=linux_%{target_cpu} \
%endif
	--with-perl

make OPT="$RPM_OPT_FLAGS"

cd ..
make all PGDOCS=unpacked -C doc

%install
rm -rf $RPM_BUILD_ROOT
install -d $RPM_BUILD_ROOT/etc/{rc.d/init.d,sysconfig} \
        $RPM_BUILD_ROOT{%{_bindir},%{_libdir}/pgsql,%{_mandir},%{_includedir}/pgsql} \
        $RPM_BUILD_ROOT/var/lib/pgsql

# PREFIX (hack for perl)
( cd src
  make DESTDIR=$RPM_BUILD_ROOT install
  make DESTDIR=$RPM_BUILD_ROOT install-man
)

# For Perl interface

( cd $RPM_BUILD_ROOT%{perl_sitearch}/auto/Pg
  mv .packlist .packlist.old
  sed -e "s|$RPM_BUILD_ROOT/|/|g" -e "s|./||" < .packlist.old > .packlist
  rm -f .packlist.old
)

# Move all includes beneath %{_includedir}/pgsql.
( cd $RPM_BUILD_ROOT%{_includedir}
  rm -rf include
  for f in *.h access commands executor lib libpq libpq++ port utils
  do
	mv $f pgsql
  done
)

# Move all templates/examples beneath %{_libdir}/pgsql
( cd $RPM_BUILD_ROOT%{_libdir}
  mv  *description *source *sample pgsql
)

# Move odbc.ini file to etc
mv -f $RPM_BUILD_ROOT/usr/*.ini $RPM_BUILD_ROOT/etc

install %{SOURCE1} $RPM_BUILD_ROOT/etc/rc.d/init.d/postgresql
install %{SOURCE3} $RPM_BUILD_ROOT/etc/sysconfig/postgresql

install -d howto
( cd howto
  tar xzf $RPM_SOURCE_DIR/pgsql-Database-HOWTO-html.tar.gz
)

# Install all header files. They are required
# by executor/spi.h and commands/trigger.h

( cd src/include
  cp -rf * $RPM_BUILD_ROOT%{_includedir}/pgsql
)

strip --strip-unneeded $RPM_BUILD_ROOT%{_libdir}/lib*.so*

gzip -9nf $RPM_BUILD_ROOT%{_mandir}/man*/*

%pre
getgid postgres >/dev/null 2>&1 || /usr/sbin/groupadd -g 88 -r -f postgres
id postgres >/dev/null 2>&1 || /usr/sbin/useradd -M -o -r -u 88 \
	-d /var/lib/pgsql -s /bin/sh -g postgres \
	-c "PostgreSQL Server" postgres
)

%post
/sbin/chkconfig --add postgresql

if [ -r /var/lock/subsys/postmaster ]; then
	/etc/rc.d/init.d/postgresql restart >&2
else
	echo "Run \"/etc/rc.d/init.d/postgresql start\" to start postgresql server."
fi

%preun
if [ "$1" = "0" ]; then
	if [ -f /var/lock/subsys/postmaster ]; then
		/etc/rc.d/init.d/postgresql stop
	fi
	/sbin/chkconfig --del postgresql
fi

%post   libs -p /sbin/ldconfig
%postun libs -p /sbin/ldconfig

%post   tcl -p /sbin/ldconfig
%postun tcl -p /sbin/ldconfig

%post   clients -p /sbin/ldconfig
%postun clients -p /sbin/ldconfig

%post   odbc -p /sbin/ldconfig
%postun odbc -p /sbin/ldconfig

%clean
rm -rf $RPM_BUILD_ROOT
rm -f /tmp/tmp_perl_info

%files doc
%defattr(644,root,root,755)
%doc doc/unpacked/*
%doc howto

%files
%defattr(644,root,root,755)
%doc contrib 
%doc doc/FAQ doc/FAQ_Linux doc/README* 
%doc COPYRIGHT README HISTORY doc/bug.template
%doc doc/*.ps.gz

%attr(754,root,root) /etc/rc.d/init.d/*
%attr(644,root,root) /etc/sysconfig/*

%attr(755,root,root) %{_bindir}/cleardbdir
%attr(755,root,root) %{_bindir}/createdb
%attr(755,root,root) %{_bindir}/createuser
%attr(755,root,root) %{_bindir}/destroydb
%attr(755,root,root) %{_bindir}/destroyuser
%attr(755,root,root) %{_bindir}/initdb
%attr(755,root,root) %{_bindir}/initlocation
%attr(755,root,root) %{_bindir}/pg_passwd
%attr(755,root,root) %{_bindir}/pg_version
%attr(755,root,root) %{_bindir}/pg_encoding
%attr(755,root,root) %{_bindir}/postgres
%attr(755,root,root) %{_bindir}/postmaster
%attr(755,root,root) %{_bindir}/ipcclean
%attr(755,root,root) %{_bindir}/createlang
%attr(755,root,root) %{_bindir}/destroylang

%{_mandir}/man1/cleardbdir.1*
%{_mandir}/man1/createdb.1*
%{_mandir}/man1/createuser.1*
%{_mandir}/man1/destroydb.1*
%{_mandir}/man1/destroyuser.1*
%{_mandir}/man1/initdb.1*
%{_mandir}/man1/initlocation.1*
%{_mandir}/man1/pg_passwd.1*
%{_mandir}/man1/postgres.1*
%{_mandir}/man1/postmaster.1*
%{_mandir}/man1/ipcclean.1*
%{_mandir}/man5/*.5*

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

%files libs
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/libpq.so.*.*
%attr(755,root,root) %{_libdir}/libpq++.so.*.*
%attr(755,root,root) %{_libdir}/libecpg.so.*.*
# nie wiem do czego to
%attr(755,root,root) %{_libdir}/plpgsql.so 

%attr(755,root,root) %{_bindir}/pg_id

#%defattr(644,postgres,postgres,755)
%{_libdir}/pgsql

%files tcl
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/libpgtcl.so.*.*
%attr(755,root,root) %{_libdir}/pltcl.so
%attr(755,root,root) %{_bindir}/pgtclsh
%attr(755,root,root) %{_bindir}/pgtksh
%attr(755,root,root) %{_bindir}/pgaccess

%files tcl-devel
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/libpgtcl.so

%files tcl-static
%defattr(644,root,root,755)
%{_libdir}/libpgtcl.a

%files devel
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/libecpg.so
%attr(755,root,root) %{_libdir}/libpq.so
%attr(755,root,root) %{_libdir}/libpq++.so
%{_includedir}/pgsql
%{_mandir}/man3/*.3*
%attr(755,root,root) %{_bindir}/ecpg
%{_mandir}/man1/ecpg.1*

%files static
%defattr(644,root,root,755)
%{_libdir}/libecpg.a
%{_libdir}/libpq.a
%{_libdir}/libpq++.a

%files clients
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/libec*.so.*.*
%attr(755,root,root) %{_libdir}/libpq*.so.*.*
%attr(755,root,root) %{_bindir}/pg_dump
%attr(755,root,root) %{_bindir}/pg_dumpall
%attr(755,root,root) %{_bindir}/pg_upgrade
%attr(755,root,root) %{_bindir}/psql
%attr(755,root,root) %{_bindir}/vacuumdb

%{_mandir}/man1/pg_dump.1*
%{_mandir}/man1/pg_dumpall.1*
%{_mandir}/man1/pg_upgrade.1*
%{_mandir}/man1/psql.1*
%{_mandir}/manl/*.l*

%files perl
%defattr(644,root,root,755)
%dir %{perl_sitearch}/auto/Pg
%{perl_sitearch}/auto/Pg/Pg.so
%attr(755,root,root) %{perl_sitearch}/auto/Pg/Pg.bs
%{perl_sitearch}/auto/Pg/autosplit.ix
%{perl_sitearch}/auto/Pg/.packlist
%{perl_sitearch}/Pg.pm

%files odbc
%defattr(644,root,root,755)
%doc src/interfaces/odbc/readme.txt src/interfaces/odbc/notice.txt
%config(noreplace) %verify(not size mtime md5) %{_sysconfdir}/odbc*
%{_libdir}/libpsqlodbc.so.*.*

%files odbc-devel
%defattr(644,root,root,755)
%{_includedir}/iodbc
%attr(755,root,root) %{_libdir}/libpsqlodbc.so

%files odbc-static
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/libpsqlodbc.a