1 %include /usr/lib/rpm/macros.perl
2 Summary: PostgreSQL Data Base Management System
3 Summary(de): PostgreSQL Datenbankverwaltungssystem
4 Summary(fr): Sysème de gestion de base de données PostgreSQL.
5 Summary(pl): PostgreSQL system bazodanowy
6 Summary(tr): Veri Tabaný Yönetim Sistemi
11 Group: Applications/Databases
12 Group(pl): Aplikacje/Bazy Danych
13 Source0: ftp://ftp.postgresql.org/pub/%{name}-%{version}.tar.gz
15 Source2: pgsql-Database-HOWTO-html.tar.gz
16 Source3: %{name}.sysconfig
17 Patch0: postgresql-opt.patch
18 Patch1: postgresql-DESTDIR.patch
19 Patch2: postgresql-perl.patch
20 URL: http://www.postgresql.org/
21 Prereq: /sbin/chkconfig
23 BuildRequires: tcl-devel
24 BuildRequires: tk-devel
25 BuildRequires: readline-devel
26 BuildRequires: ncurses-devel >= 5.0
27 BuildRequires: rpm-perlprov
28 BuildRequires: XFree86-devel
29 Buildroot: /tmp/%{name}-%{version}-root
30 Requires: %{name}-libs = %{version}
32 %define _sysconfdir /etc
35 PostgreSQL Data Base Management System (formerly known as Postgres, then as
38 PostgreSQL is an enhancement of the POSTGRES database management system, a
39 next-generation DBMS research prototype. While PostgreSQL retains the
40 powerful data model and rich data types of POSTGRES, it replaces the
41 PostQuel query language with an extended subset of SQL. PostgreSQL is free
42 and the complete source is available.
44 PostgreSQL development is being performed by a team of Internet developers
45 who all subscribe to the PostgreSQL development mailing list. The current
46 coordinator is Marc G. Fournier (scrappy@postgreSQL.org). This team is now
47 responsible for all current and future development of PostgreSQL.
49 The authors of PostgreSQL 1.01 were Andrew Yu and Jolly Chen. Many others
50 have contributed to the porting, testing, debugging and enhancement of the
51 code. The original Postgres code, from which PostgreSQL is derived, was the
52 effort of many graduate students, undergraduate students, and staff
53 programmers working under the direction of Professor Michael Stonebraker at
54 the University of California, Berkeley.
56 The original name of the software at Berkeley was Postgres. When SQL
57 functionality was added in 1995, its name was changed to Postgres95. The
58 name was changed at the end of 1996 to PostgreSQL.
60 PostgreSQL runs on Solaris, SunOS, HPUX, AIX, Linux, Irix, FreeBSD, and most
64 PostgreSQL Datenbank-Managementsystem (früher als Postgres, dann als
67 PostgreSQL ist eine Verbesserung des POSTGRES-DB-Managementsystems, ein
68 DBMS-Forschungsprototyp der nächsten Generation. Während es das
69 leistungsfähige Datenmodell und die reichhaltigen Datentypen von POSTGRES
70 beibehält, ersetzt es die PostQuel-Abfragesprache durch ein Subset von SQL.
71 PostgreSQL ist gratis, der gesamte Quellcode ist verfügbar.
73 Ein Team von Internet-Entwicklern befaßt sich mit PostgreSQL. Sie alle sind
74 auf der PostgreSQL-Entwickleradreßliste. Koordinator ist Marc G. Fournier
75 (scrappy@postgreSQL.org). Das Team ist verantwortlich für alle aktuellen und
76 künftigen Entwicklungen von PostgreSQL.
78 Die Autoren von PostgreSQL 1.01 waren Andrew Yu und Jolly Chen. Zahlreiche
79 andere haben zur Portierung, zum Testen, Debugging und zur Verbesserung des
80 Code beigetragen. Den Original-Postgres-Code, von dem sich PostgreSQL
81 ableitet, verdanken wir der Arbeit vieler Doktoranden, Studenten und
82 Programmierern unter der Leitung von Professor Michael Stonebraker an der
83 University of California, Berkeley.
85 Der ursprüngliche Name war Postgres. Als 1995 SQL-Funktionalität hinzukam,
86 wurde der Name in Postgres95 geändert. Ende 1996 schließlich entschied man
89 PostgreSQL läuft auf Solaris, SunOS, HPUX, AIX, Linux, Irix, FreeBSD und den
90 meisten Unix-Systemen.
93 Système de gestion de bases de données PostgreSQL (D'abord nommé Postgres,
96 PostgreSQL est une amélioration du système de gestion de bases de données
97 POSTGRES, un prototype de recherche de la génération suivant DBMS. Tout en
98 conservant le puissant modèle de donnée de et les types de donée riches de
99 Postgres, il remplace le langage de requêtes de Postgres par un sous
100 ensemble etendu de commandes SQL. PosrgreSQL est libre, et ses sources sont
103 Le développement de PostgreSQL est actuellement réalisé via internet parune
104 équipe de développeurs inscrits sur la mailing-list de développement de
105 PostgreSQL. Le coordinateur actuel est Marc G Fournier
106 (scrappy@postgreSQL.org). Cette équipe est responsable du développemen
107 actuel et à venir de PostgreSQL.
109 Les auteurs de PostgreSQL 1.01 étaient Andrew Yu et Jolly Chen. Beaucoup
110 d'autres ont contribué au portage, au test, au débogage et à l'amélioration
111 du code. Le code original de Postgres, duquel PostgreSQL est dérivé, a été
112 l'oeuvre d'étudiants de haut niveau, de moins haut niveau, et de
113 programmeurs travaillant sous la direction du professeur Michael Stonebraker
114 à l'université de Berkeley Californie.
116 Le nom original du logiciel était Postgres. Quand les fonctionnalitées
117 SQL furent ajoutées en 1995, son nom est devenu Postgres95. Il a été
118 rebaptisé PostgreSQL en 1996.
120 PostgreSQL tourne sur Solaris, SunOS, HPUX, AIX, Linux, Irix, FreeBSD,
121 et la plupart des Unix.
124 PostgreSQL System Zarz±dzania Baz± Danych (dawniej znany jako Postgres,
125 nastêpnie jako Postgres95).
127 PostgreSQL mo¿e byæ uruchominy pod nastêpuj±cymi systemami: Solaris, SunOS,
128 HPUX, AIX, Linux, Irix, FreeBSD i innych systemach Unix.
131 PostgreSQL, POSTGRES'den türemiþ bir veri tabaný yönetim sistemidir (DBMS).
132 Güçlü veri modeli ve zengin POSTGRES veri tiplerini desteklerken SQL'in
133 geniþletilmiþ bir altkümesi yerine PostQuel sorgulama dilini koyar.
136 Summary: PostgreSQL development header files and libraries
137 Summary(de): PostgreSQL-Entwicklungs-Header-Dateien und Libraries
138 Summary(fr): En-têtes et bibliothèques de développement PostgreSQL
139 Summary(pl): PostgreSQL - pliki nag³ówkowe i biblioteki
140 Summary(tr): PostgreSQL baþlýk dosyalarý ve kitaplýklar
141 Group: Development/Libraries
142 Group(pl): Programowanie/Biblioteki
143 Requires: %{name}-libs = %{version}
146 This package contains header files and libraries required to compile
147 applications that are talking directly to the PostgreSQL backend server.
149 %description -l de devel
150 Dieses Paket enthält die Header-Dateien und Libraries, die zum Kompilieren
151 von Applikationen notwendig sind, die direkt mit dem
152 PostgreSQL-Backend-Server kommunizieren.
154 %description -l fr devel
155 Ce package contient les fichiers d'en-tête et les bibliothéques nécessaires
156 pour compiler des applications ayant des échanges directs avec le serveur du
159 %description -l pl devel
160 Pakiet zawiera nag³ówki oraz biblioteki wymagane do kompilacji aplikacji
161 ³±cz±cych siê bezpo¶rednio z serwerem PostgreSQL.
163 %description -l tr devel
164 Bu paket, PostgreSQL sunucusuyla konuþacak yazýlýmlar geliþtirmek için
165 gereken baþlýk dosyalarýný ve kitaplýklarý içerir.
168 Summary: clients needed to access a PostgreSQL server
169 Summary(pl): klienci wymagani do dostêpu do serwera PostgreSQL
170 Group: Applications/Databases
171 Group(pl): Aplikacje/Bazy Danych
174 This package includes only the clients and client libraries needed to access
175 an PostgreSQL server. The server is included in the main package. If all you
176 need is to connect to another PostgreSQL server, the this is the only
177 package you need to install.
179 In this package there are client libraries available for C and C++, as well
180 as several command-line utilities you can use to manage your databases on a
181 remote PostgreSQL server.
183 %description -l pl clients
184 Pakiet zawiera klientów oraz biblioteki niezbêdne dla dostêpu do serwera
185 PostgreSQL. Serwer znajduje siê w g³ównym pakiecie.
188 Summary: Perl interface to PostgreSQL database
189 Summary(pl): Interface dla Perl'a umo¿liwiaj±cy dostêp do baz PostgreSQL
190 Group: Applications/Databases
191 Group(pl): Aplikacje/Bazy Danych
192 Requires: postgresql, perl >= 5.004
195 This package includes only perl modules needed to access an PostgreSQL server.
197 %description -l pl perl
198 Pakiet ten zawiera tylko modu³y Perl'a wymagane dla dostêpu do serwera
202 Summary: Documentation for PostgreSQL
203 Summary(pl): Dodatkowa dokumantacja dla PostgreSQL
204 Group: Applications/Databases
205 Group(pl): Aplikacje/Bazy Danych
206 #Requires: %{name} = %{version}
209 This package includes documentation and HOWTO for programmer, admin etc., in
212 %description -l pl doc
213 Pakiet ten zawiera dokumentacjê oraz HOWTO m.in. dla programistów,
214 administratorów w formacie HTML.
217 Summary: ODBC interface to PostgreSQL
218 Summary(pl): Interface ODBC do PostgreSQL
219 Group: Applications/Databases
220 Group(pl): Aplikacje/Bazy Danych
221 #Requires: %{name} = %{version}
224 This package includes library for interface ODBC.
226 %description -l pl odbc
227 Pakiet ten zawiera biblioteki dla interface'u ODBC.
230 Summary: ODBC interface to PostgreSQL - development part
231 Summary(pl): Interface ODBC do PostgreSQL - cze¶æ programistyczna
232 Group: Applications/Databases
233 Group(pl): Aplikacje/Bazy Danych
234 Requires: %{name}-odbc = %{version}
236 %description odbc-devel
237 This package includes library and header files for interface ODBC.
239 %description -l pl odbc-devel
240 Pakiet ten zawiera biblioteki i pliki nag³ówkowe dla interface'u ODBC.
243 Summary: ODBC interface to PostgreSQL - static libraries
244 Summary(pl): Interface ODBC do PostgreSQL - biblioteki statyczne
245 Group: Applications/Databases
246 Group(pl): Aplikacje/Bazy Danych
247 #Requires: %{name}-odbc-devel = %{version}
249 %description odbc-static
250 This package includes static library for interface ODBC.
252 %description -l pl odbc-static
253 Pakiet ten zawiera biblioteki statyczne dla interface'u ODBC.
256 Summary: PostgreSQL libraries
257 Summary(pl): Biblioteki dzielone programu PostgreSQL
259 Group(pl): Biblioteki
262 PostgreSQL libraries.
264 %description libs -l pl
265 Biblioteki dzielone programu PostgreSQL.
268 Summary: PostgreSQL static libraries
269 Summary(pl): Biblioteki statyczne programu PostgreSQL
270 Group: Development/Libraries
271 Group(pl): Programowanie/Biblioteki
272 Requires: %{name}-devel = %{version}
275 PostgreSQL static libraries.
277 %description libs -l pl
278 Biblioteki statyczne programu PostgreSQL.
281 Summary: tcl interface for PostgreSQL
282 Summary(pl): tcl interface dla PostgreSQL
283 Group: Development/Languages/Tcl
284 Group(pl): Programowanie/Jêzyki/Tcl
285 #Requires: %{name}-libs = %{version}
288 tcl interface for PostgreSQL.
290 %description tcl -l pl
291 tcl interface dla PostgreSQL.
294 Summary: Development part of tcl interface for PostgreSQL
295 Summary(pl): Czê¶æ dla programistów interafece tcl dla PostgreSQL
296 Group: Development/Languages/Tcl
297 Group(pl): Programowanie/Jêzyki/Tcl
298 Requires: %{name}-tcl = %{version}
300 %description tcl-devel
301 Development part of tcl interface for PostgreSQL.
303 %description tcl-devel -l pl
304 Czê¶æ dla programistów interafece tcl dla PostgreSQL.
307 Summary: Static libraries of tcl interface for PostgreSQL
308 Summary(pl): Biblioteki statyczne interafece tcl dla PostgreSQL
309 Group: Development/Languages/Tcl
310 Group(pl): Programowanie/Jêzyki/Tcl
311 Requires: %{name}-tcl-devel = %{version}
313 %description tcl-static
314 Static libraries of tcl interface for PostgreSQL
316 %description tcl-devel -l pl
317 Biblioteki statyczne interafece tcl dla PostgreSQL
322 %patch1 -p1 -b .destdir
326 rm -fR `find contrib/ -type d -name CVS`
329 PATH=$PATH:. ; export PATH
334 LDFLAGS="-s"; export LDFLAGS
339 --with-odbcinst=%{_sysconfdir} \
344 --with-template=linux_i386 \
346 --with-template=linux_%{target_cpu} \
350 make OPT="$RPM_OPT_FLAGS"
353 make all PGDOCS=unpacked -C doc
356 rm -rf $RPM_BUILD_ROOT
357 install -d $RPM_BUILD_ROOT/etc/{rc.d/init.d,sysconfig} \
358 $RPM_BUILD_ROOT{%{_bindir},%{_libdir}/pgsql,%{_mandir},%{_includedir}/pgsql} \
359 $RPM_BUILD_ROOT/var/state/pgsql
362 make DESTDIR=$RPM_BUILD_ROOT install
363 make DESTDIR=$RPM_BUILD_ROOT install-man
367 #( cd src/interfaces/perl5
369 # install -d $RPM_BUILD_ROOT/%{perl_sitearch}
371 # make PREFIX=$RPM_BUILD_ROOT/usr install
373 ( cd $RPM_BUILD_ROOT%{perl_sitearch}/auto/Pg
374 mv .packlist .packlist.old
375 sed -e "s|$RPM_BUILD_ROOT/|/|g" -e "s|./||" < .packlist.old > .packlist
378 # LOCAL="$RPM_BUILD_ROOT/$PERLVER/perllocal.pod"
379 # mv $LOCAL $LOCAL.old
380 # sed -e "s|$RPM_BUILD_ROOT/|/|g" < $LOCAL.old > $LOCAL.pg
383 #find $RPM_BUILD_ROOT%{_libdir}/perl5 -type f -print | \
384 # sed -e "s|$RPM_BUILD_ROOT/|/|g" | grep -v "perllocal.pod$" > perlfiles.list
385 #find $RPM_BUILD_ROOT%{_libdir}/perl5 -type d -name Pg -print | \
386 # sed -e "s|$RPM_BUILD_ROOT/|%dir /|g" >> perlfiles.list
388 # Move all includes beneath %{_includedir}/pgsql.
389 ( cd $RPM_BUILD_ROOT%{_includedir}
391 for f in *.h access commands executor lib libpq libpq++ port utils
397 # Move all templates/examples beneath %{_libdir}/pgsql
398 ( cd $RPM_BUILD_ROOT%{_libdir}
399 mv *description *source *sample pgsql
402 # Move odbc.ini file to etc
403 mv -f $RPM_BUILD_ROOT/usr/*.ini $RPM_BUILD_ROOT/etc
405 install %{SOURCE1} $RPM_BUILD_ROOT/etc/rc.d/init.d/postgresql
406 install %{SOURCE3} $RPM_BUILD_ROOT/etc/sysconfig/postgresql
410 tar xzf $RPM_SOURCE_DIR/pgsql-Database-HOWTO-html.tar.gz
413 strip --strip-unneeded $RPM_BUILD_ROOT%{_libdir}/lib*.so*
415 gzip -9nf $RPM_BUILD_ROOT%{_mandir}/man*/*
418 /usr/sbin/groupadd -g 88 -r -f postgres 1>&2 || :
419 /usr/sbin/useradd -M -o -r -u 88 -d /var/state/pgsql -s /bin/bash \
420 -g postgres -c "PostgreSQL Server" postgres 1>&2 || :
423 /sbin/chkconfig --add postgresql
425 # Create sample database
426 if [ ! -f /var/state/pgsql/PG_VERSION ]; then
427 su postgres -c "LD_LIBRARY_PATH=%{_libdir} \
428 %{_bindir}/initdb --pgdata=/var/state/pgsql \
429 --pglib=%{_libdir}/pgsql"
431 if [ -r /var/lock/subsys/postmaster ]; then
432 /etc/rc.d/init.d/postgresql restart >&2
434 echo "Run \"/etc/rc.d/init.d/postgresql start\" to start postgresql server."
438 if [ "$1" = "0" ]; then
439 if [ -f /var/lock/subsys/postmaster ]; then
440 /etc/rc.d/init.d/postgresql stop
442 /sbin/chkconfig --del postgresql
445 %post libs -p /sbin/ldconfig
446 %postun libs -p /sbin/ldconfig
448 %post tcl -p /sbin/ldconfig
449 %postun tcl -p /sbin/ldconfig
451 %post clients -p /sbin/ldconfig
452 %postun clients -p /sbin/ldconfig
454 %post odbc -p /sbin/ldconfig
455 %postun odbc -p /sbin/ldconfig
458 #POD=`find %{_libdir} -name perllocal.pod.pg`
460 #if [ -f $DIR/perllocal.pod ]; then
461 # mv $DIR/perllocal.pod $DIR/perllocal.pod.prepg
462 # cat $DIR/perllocal.pod.pg $DIR/perllocal.pod.prepg > $DIR/perllocal.pod
464 # cp $DIR/perllocal.pod.pg $DIR/perllocal.pod
466 #rm -f $DIR/perllocal.pod.pg
469 rm -rf $RPM_BUILD_ROOT
470 rm -f /tmp/tmp_perl_info
473 %defattr(644,root,root,755)
478 %defattr(644,root,root,755)
480 %doc doc/FAQ doc/FAQ_Linux doc/README*
481 %doc COPYRIGHT README HISTORY doc/bug.template
484 %attr(754,root,root) /etc/rc.d/init.d/*
485 %attr(644,root,root) /etc/sysconfig/*
487 %attr(755,root,root) %{_bindir}/cleardbdir
488 %attr(755,root,root) %{_bindir}/createdb
489 %attr(755,root,root) %{_bindir}/createuser
490 %attr(755,root,root) %{_bindir}/destroydb
491 %attr(755,root,root) %{_bindir}/destroyuser
492 %attr(755,root,root) %{_bindir}/initdb
493 %attr(755,root,root) %{_bindir}/initlocation
494 %attr(755,root,root) %{_bindir}/pg_passwd
495 %attr(755,root,root) %{_bindir}/pg_version
496 %attr(755,root,root) %{_bindir}/pg_encoding
497 %attr(755,root,root) %{_bindir}/postgres
498 %attr(755,root,root) %{_bindir}/postmaster
499 %attr(755,root,root) %{_bindir}/ipcclean
500 %attr(755,root,root) %{_bindir}/createlang
501 %attr(755,root,root) %{_bindir}/destroylang
503 %{_mandir}/man1/cleardbdir.1*
504 %{_mandir}/man1/createdb.1*
505 %{_mandir}/man1/createuser.1*
506 %{_mandir}/man1/destroydb.1*
507 %{_mandir}/man1/destroyuser.1*
508 %{_mandir}/man1/initdb.1*
509 %{_mandir}/man1/initlocation.1*
510 %{_mandir}/man1/pg_passwd.1*
511 %{_mandir}/man1/postgres.1*
512 %{_mandir}/man1/postmaster.1*
513 %{_mandir}/man1/ipcclean.1*
516 %attr(750,postgres,postgres) %dir /var/state/pgsql
519 %defattr(644,root,root,755)
520 %attr(755,root,root) %{_libdir}/libpq.so.*.*
521 %attr(755,root,root) %{_libdir}/libpq++.so.*.*
522 %attr(755,root,root) %{_libdir}/libecpg.so.*.*
523 # nie wiem do czego to
524 %attr(755,root,root) %{_libdir}/plpgsql.so
526 %attr(755,root,root) %{_bindir}/pg_id
528 #%defattr(644,postgres,postgres,755)
532 %defattr(644,root,root,755)
533 %attr(755,root,root) %{_libdir}/libpgtcl.so.*.*
534 %attr(755,root,root) %{_libdir}/pltcl.so
535 %attr(755,root,root) %{_bindir}/pgtclsh
536 %attr(755,root,root) %{_bindir}/pgtksh
537 %attr(755,root,root) %{_bindir}/pgaccess
540 %defattr(644,root,root,755)
541 %attr(755,root,root) %{_libdir}/libpgtcl.so
544 %defattr(644,root,root,755)
545 %{_libdir}/libpgtcl.a
548 %defattr(644,root,root,755)
549 %attr(755,root,root) %{_libdir}/libecpg.so
550 %attr(755,root,root) %{_libdir}/libpq.so
551 %attr(755,root,root) %{_libdir}/libpq++.so
554 %attr(755,root,root) %{_bindir}/ecpg
555 %{_mandir}/man1/ecpg.1*
558 %defattr(644,root,root,755)
564 %defattr(644,root,root,755)
565 %attr(755,root,root) %{_libdir}/libec*.so.*.*
566 %attr(755,root,root) %{_libdir}/libpq*.so.*.*
567 %attr(755,root,root) %{_bindir}/pg_dump
568 %attr(755,root,root) %{_bindir}/pg_dumpall
569 %attr(755,root,root) %{_bindir}/pg_upgrade
570 %attr(755,root,root) %{_bindir}/psql
571 %attr(755,root,root) %{_bindir}/vacuumdb
573 %{_mandir}/man1/pg_dump.1*
574 %{_mandir}/man1/pg_dumpall.1*
575 %{_mandir}/man1/pg_upgrade.1*
576 %{_mandir}/man1/psql.1*
580 %defattr(644,root,root,755)
581 %dir %{perl_sitearch}/auto/Pg
582 %{perl_sitearch}/auto/Pg/Pg.so
583 %attr(755,root,root) %{perl_sitearch}/auto/Pg/Pg.bs
584 %{perl_sitearch}/auto/Pg/autosplit.ix
585 %{perl_sitearch}/auto/Pg/.packlist
586 %{perl_sitearch}/Pg.pm
589 %defattr(644,root,root,755)
590 %doc src/interfaces/odbc/readme.txt src/interfaces/odbc/notice.txt
591 %config(noreplace) %verify(not size mtime md5) %{_sysconfdir}/odbc*
592 %{_libdir}/libpsqlodbc.so.*.*
595 %defattr(644,root,root,755)
597 %attr(755,root,root) %{_libdir}/libpsqlodbc.so
600 %defattr(644,root,root,755)
601 %attr(755,root,root) %{_libdir}/libpsqlodbc.a