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: %{tmpdir}/%{name}-%{version}-root-%(id -u -n)
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
361 # PREFIX (hack for perl)
363 make DESTDIR=$RPM_BUILD_ROOT install
364 make DESTDIR=$RPM_BUILD_ROOT install-man
369 ( cd $RPM_BUILD_ROOT%{perl_sitearch}/auto/Pg
370 mv .packlist .packlist.old
371 sed -e "s|$RPM_BUILD_ROOT/|/|g" -e "s|./||" < .packlist.old > .packlist
375 # Move all includes beneath %{_includedir}/pgsql.
376 ( cd $RPM_BUILD_ROOT%{_includedir}
378 for f in *.h access commands executor lib libpq libpq++ port utils
384 # Move all templates/examples beneath %{_libdir}/pgsql
385 ( cd $RPM_BUILD_ROOT%{_libdir}
386 mv *description *source *sample pgsql
389 # Move odbc.ini file to etc
390 mv -f $RPM_BUILD_ROOT/usr/*.ini $RPM_BUILD_ROOT/etc
392 install %{SOURCE1} $RPM_BUILD_ROOT/etc/rc.d/init.d/postgresql
393 install %{SOURCE3} $RPM_BUILD_ROOT/etc/sysconfig/postgresql
397 tar xzf $RPM_SOURCE_DIR/pgsql-Database-HOWTO-html.tar.gz
400 # Install all header files. They are required
401 # by executor/spi.h and commands/trigger.h
404 cp -rf * $RPM_BUILD_ROOT%{_includedir}/pgsql
407 strip --strip-unneeded $RPM_BUILD_ROOT%{_libdir}/lib*.so*
409 gzip -9nf $RPM_BUILD_ROOT%{_mandir}/man*/*
412 grep -l postgres /etc/group >/dev/null 2>&1 || (
413 /usr/sbin/groupadd -g 88 -r -f postgres 1>&2 || :
415 grep -l postgres /etc/passwd >/dev/null 2>&1 || (
416 /usr/sbin/useradd -M -o -r -u 88 -d /var/state/pgsql -s /bin/sh \
417 -g postgres -c "PostgreSQL Server" postgres 1>&2 || :
421 /sbin/chkconfig --add postgresql
423 if [ -r /var/lock/subsys/postmaster ]; then
424 /etc/rc.d/init.d/postgresql restart >&2
426 echo "Run \"/etc/rc.d/init.d/postgresql start\" to start postgresql server."
430 if [ "$1" = "0" ]; then
431 if [ -f /var/lock/subsys/postmaster ]; then
432 /etc/rc.d/init.d/postgresql stop
434 /sbin/chkconfig --del postgresql
437 %post libs -p /sbin/ldconfig
438 %postun libs -p /sbin/ldconfig
440 %post tcl -p /sbin/ldconfig
441 %postun tcl -p /sbin/ldconfig
443 %post clients -p /sbin/ldconfig
444 %postun clients -p /sbin/ldconfig
446 %post odbc -p /sbin/ldconfig
447 %postun odbc -p /sbin/ldconfig
450 rm -rf $RPM_BUILD_ROOT
451 rm -f /tmp/tmp_perl_info
454 %defattr(644,root,root,755)
459 %defattr(644,root,root,755)
461 %doc doc/FAQ doc/FAQ_Linux doc/README*
462 %doc COPYRIGHT README HISTORY doc/bug.template
465 %attr(754,root,root) /etc/rc.d/init.d/*
466 %attr(644,root,root) /etc/sysconfig/*
468 %attr(755,root,root) %{_bindir}/cleardbdir
469 %attr(755,root,root) %{_bindir}/createdb
470 %attr(755,root,root) %{_bindir}/createuser
471 %attr(755,root,root) %{_bindir}/destroydb
472 %attr(755,root,root) %{_bindir}/destroyuser
473 %attr(755,root,root) %{_bindir}/initdb
474 %attr(755,root,root) %{_bindir}/initlocation
475 %attr(755,root,root) %{_bindir}/pg_passwd
476 %attr(755,root,root) %{_bindir}/pg_version
477 %attr(755,root,root) %{_bindir}/pg_encoding
478 %attr(755,root,root) %{_bindir}/postgres
479 %attr(755,root,root) %{_bindir}/postmaster
480 %attr(755,root,root) %{_bindir}/ipcclean
481 %attr(755,root,root) %{_bindir}/createlang
482 %attr(755,root,root) %{_bindir}/destroylang
484 %{_mandir}/man1/cleardbdir.1*
485 %{_mandir}/man1/createdb.1*
486 %{_mandir}/man1/createuser.1*
487 %{_mandir}/man1/destroydb.1*
488 %{_mandir}/man1/destroyuser.1*
489 %{_mandir}/man1/initdb.1*
490 %{_mandir}/man1/initlocation.1*
491 %{_mandir}/man1/pg_passwd.1*
492 %{_mandir}/man1/postgres.1*
493 %{_mandir}/man1/postmaster.1*
494 %{_mandir}/man1/ipcclean.1*
497 %attr(750,postgres,postgres) %dir /var/state/pgsql
500 %defattr(644,root,root,755)
501 %attr(755,root,root) %{_libdir}/libpq.so.*.*
502 %attr(755,root,root) %{_libdir}/libpq++.so.*.*
503 %attr(755,root,root) %{_libdir}/libecpg.so.*.*
504 # nie wiem do czego to
505 %attr(755,root,root) %{_libdir}/plpgsql.so
507 %attr(755,root,root) %{_bindir}/pg_id
509 #%defattr(644,postgres,postgres,755)
513 %defattr(644,root,root,755)
514 %attr(755,root,root) %{_libdir}/libpgtcl.so.*.*
515 %attr(755,root,root) %{_libdir}/pltcl.so
516 %attr(755,root,root) %{_bindir}/pgtclsh
517 %attr(755,root,root) %{_bindir}/pgtksh
518 %attr(755,root,root) %{_bindir}/pgaccess
521 %defattr(644,root,root,755)
522 %attr(755,root,root) %{_libdir}/libpgtcl.so
525 %defattr(644,root,root,755)
526 %{_libdir}/libpgtcl.a
529 %defattr(644,root,root,755)
530 %attr(755,root,root) %{_libdir}/libecpg.so
531 %attr(755,root,root) %{_libdir}/libpq.so
532 %attr(755,root,root) %{_libdir}/libpq++.so
535 %attr(755,root,root) %{_bindir}/ecpg
536 %{_mandir}/man1/ecpg.1*
539 %defattr(644,root,root,755)
545 %defattr(644,root,root,755)
546 %attr(755,root,root) %{_libdir}/libec*.so.*.*
547 %attr(755,root,root) %{_libdir}/libpq*.so.*.*
548 %attr(755,root,root) %{_bindir}/pg_dump
549 %attr(755,root,root) %{_bindir}/pg_dumpall
550 %attr(755,root,root) %{_bindir}/pg_upgrade
551 %attr(755,root,root) %{_bindir}/psql
552 %attr(755,root,root) %{_bindir}/vacuumdb
554 %{_mandir}/man1/pg_dump.1*
555 %{_mandir}/man1/pg_dumpall.1*
556 %{_mandir}/man1/pg_upgrade.1*
557 %{_mandir}/man1/psql.1*
561 %defattr(644,root,root,755)
562 %dir %{perl_sitearch}/auto/Pg
563 %{perl_sitearch}/auto/Pg/Pg.so
564 %attr(755,root,root) %{perl_sitearch}/auto/Pg/Pg.bs
565 %{perl_sitearch}/auto/Pg/autosplit.ix
566 %{perl_sitearch}/auto/Pg/.packlist
567 %{perl_sitearch}/Pg.pm
570 %defattr(644,root,root,755)
571 %doc src/interfaces/odbc/readme.txt src/interfaces/odbc/notice.txt
572 %config(noreplace) %verify(not size mtime md5) %{_sysconfdir}/odbc*
573 %{_libdir}/libpsqlodbc.so.*.*
576 %defattr(644,root,root,755)
578 %attr(755,root,root) %{_libdir}/libpsqlodbc.so
581 %defattr(644,root,root,755)
582 %attr(755,root,root) %{_libdir}/libpsqlodbc.a