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/source/v%{version}/%{name}-%{version}.tar.gz
15 Source2: pgsql-Database-HOWTO-html.tar.gz
16 Source3: %{name}.sysconfig
17 Source4: pgaccess.desktop
19 Patch0: %{name}-opt.patch
20 Patch1: %{name}-DESTDIR.patch
21 Patch2: %{name}-perl.patch
22 Patch3: %{name}-python.patch
23 Patch4: %{name}-no_libnsl.patch
24 Patch5: %{name}-pgaccess-typo.patch
26 URL: http://www.postgresql.org/
27 Prereq: /sbin/chkconfig
29 BuildRequires: autoconf
30 BuildRequires: tcl-devel >= 8.3.2
31 BuildRequires: tk-devel >= 8.3.2
32 BuildRequires: readline-devel
33 BuildRequires: ncurses-devel >= 5.0
34 BuildRequires: rpm-perlprov
35 BuildRequires: XFree86-devel
36 BuildRoot: %{tmpdir}/%{name}-%{version}-root-%(id -u -n)
37 Requires: %{name}-libs = %{version}
38 Obsoletes: postgresql-server
39 Obsoletes: postgresql-test
41 %define pgsqldir %{_libdir}/pgsql/sql
42 %define pgmoduledir %{_libdir}/pgsql/modules
46 PostgreSQL Data Base Management System (formerly known as Postgres,
49 PostgreSQL is an enhancement of the POSTGRES database management
50 system, a next-generation DBMS research prototype. While PostgreSQL
51 retains the powerful data model and rich data types of POSTGRES, it
52 replaces the PostQuel query language with an extended subset of SQL.
53 PostgreSQL is free and the complete source is available.
55 PostgreSQL development is being performed by a team of Internet
56 developers who all subscribe to the PostgreSQL development mailing
57 list. The current coordinator is Marc G. Fournier
58 (scrappy@postgreSQL.org). This team is now responsible for all current
59 and future development of PostgreSQL.
61 The authors of PostgreSQL 1.01 were Andrew Yu and Jolly Chen. Many
62 others have contributed to the porting, testing, debugging and
63 enhancement of the code. The original Postgres code, from which
64 PostgreSQL is derived, was the effort of many graduate students,
65 undergraduate students, and staff programmers working under the
66 direction of Professor Michael Stonebraker at the University of
69 The original name of the software at Berkeley was Postgres. When SQL
70 functionality was added in 1995, its name was changed to Postgres95.
71 The name was changed at the end of 1996 to PostgreSQL.
73 PostgreSQL runs on Solaris, SunOS, HPUX, AIX, Linux, Irix, FreeBSD,
74 and most flavours of Unix.
77 PostgreSQL Datenbank-Managementsystem (früher als Postgres, dann als
80 PostgreSQL ist eine Verbesserung des POSTGRES-DB-Managementsystems,
81 ein DBMS-Forschungsprototyp der nächsten Generation. Während es das
82 leistungsfähige Datenmodell und die reichhaltigen Datentypen von
83 POSTGRES beibehält, ersetzt es die PostQuel-Abfragesprache durch ein
84 Subset von SQL. PostgreSQL ist gratis, der gesamte Quellcode ist
87 Ein Team von Internet-Entwicklern befaßt sich mit PostgreSQL. Sie alle
88 sind auf der PostgreSQL-Entwickleradreßliste. Koordinator ist Marc G.
89 Fournier (scrappy@postgreSQL.org). Das Team ist verantwortlich für
90 alle aktuellen und künftigen Entwicklungen von PostgreSQL.
92 Die Autoren von PostgreSQL 1.01 waren Andrew Yu und Jolly Chen.
93 Zahlreiche andere haben zur Portierung, zum Testen, Debugging und zur
94 Verbesserung des Code beigetragen. Den Original-Postgres-Code, von dem
95 sich PostgreSQL ableitet, verdanken wir der Arbeit vieler Doktoranden,
96 Studenten und Programmierern unter der Leitung von Professor Michael
97 Stonebraker an der University of California, Berkeley.
99 Der ursprüngliche Name war Postgres. Als 1995 SQL-Funktionalität
100 hinzukam, wurde der Name in Postgres95 geändert. Ende 1996 schließlich
101 entschied man sich für PostgreSQL.
103 PostgreSQL läuft auf Solaris, SunOS, HPUX, AIX, Linux, Irix, FreeBSD
104 und den meisten Unix-Systemen.
107 Système de gestion de bases de données PostgreSQL (D'abord nommé
108 Postgres, puis Postgres95).
110 PostgreSQL est une amélioration du système de gestion de bases de
111 données POSTGRES, un prototype de recherche de la génération suivant
112 DBMS. Tout en conservant le puissant modèle de donnée de et les types
113 de donée riches de Postgres, il remplace le langage de requêtes de
114 Postgres par un sous ensemble etendu de commandes SQL. PosrgreSQL est
115 libre, et ses sources sont disponibles.
117 Le développement de PostgreSQL est actuellement réalisé via internet
118 parune équipe de développeurs inscrits sur la mailing-list de
119 développement de PostgreSQL. Le coordinateur actuel est Marc G
120 Fournier (scrappy@postgreSQL.org). Cette équipe est responsable du
121 développemen actuel et à venir de PostgreSQL.
123 Les auteurs de PostgreSQL 1.01 étaient Andrew Yu et Jolly Chen.
124 Beaucoup d'autres ont contribué au portage, au test, au débogage et à
125 l'amélioration du code. Le code original de Postgres, duquel
126 PostgreSQL est dérivé, a été l'oeuvre d'étudiants de haut niveau, de
127 moins haut niveau, et de programmeurs travaillant sous la direction du
128 professeur Michael Stonebraker à l'université de Berkeley Californie.
130 Le nom original du logiciel était Postgres. Quand les fonctionnalitées
131 SQL furent ajoutées en 1995, son nom est devenu Postgres95. Il a été
132 rebaptisé PostgreSQL en 1996.
134 PostgreSQL tourne sur Solaris, SunOS, HPUX, AIX, Linux, Irix, FreeBSD,
135 et la plupart des Unix.
138 PostgreSQL System Zarz±dzania Baz± Danych (dawniej znany jako
139 Postgres, nastêpnie jako Postgres95).
141 PostgreSQL mo¿e byæ uruchominy pod nastêpuj±cymi systemami: Solaris,
142 SunOS, HPUX, AIX, Linux, Irix, FreeBSD i innych systemach Unix.
145 PostgreSQL, POSTGRES'den türemiþ bir veri tabaný yönetim sistemidir
146 (DBMS). Güçlü veri modeli ve zengin POSTGRES veri tiplerini
147 desteklerken SQL'in geniþletilmiþ bir altkümesi yerine PostQuel
148 sorgulama dilini koyar.
151 Summary: PostgreSQL development header files and libraries
152 Summary(de): PostgreSQL-Entwicklungs-Header-Dateien und Libraries
153 Summary(fr): En-têtes et bibliothèques de développement PostgreSQL
154 Summary(pl): PostgreSQL - pliki nag³ówkowe i biblioteki
155 Summary(tr): PostgreSQL baþlýk dosyalarý ve kitaplýklar
156 Group: Development/Libraries
157 Group(de): Entwicklung/Libraries
158 Group(fr): Development/Librairies
159 Group(pl): Programowanie/Biblioteki
160 Requires: %{name}-libs = %{version}
163 This package contains header files and libraries required to compile
164 applications that are talking directly to the PostgreSQL backend
167 %description -l de devel
168 Dieses Paket enthält die Header-Dateien und Libraries, die zum
169 Kompilieren von Applikationen notwendig sind, die direkt mit dem
170 PostgreSQL-Backend-Server kommunizieren.
172 %description -l fr devel
173 Ce package contient les fichiers d'en-tête et les bibliothéques
174 nécessaires pour compiler des applications ayant des échanges directs
175 avec le serveur du backend PostgreSQL.
177 %description -l pl devel
178 Pakiet zawiera nag³ówki oraz biblioteki wymagane do kompilacji
179 aplikacji ³±cz±cych siê bezpo¶rednio z serwerem PostgreSQL.
181 %description -l tr devel
182 Bu paket, PostgreSQL sunucusuyla konuþacak yazýlýmlar geliþtirmek için
183 gereken baþlýk dosyalarýný ve kitaplýklarý içerir.
186 Summary: clients needed to access a PostgreSQL server
187 Summary(pl): klienci wymagani do dostêpu do serwera PostgreSQL
188 Group: Applications/Databases
189 Group(pl): Aplikacje/Bazy danych
190 Requires: %{name}-libs = %{version}
193 This package includes only the clients and client libraries needed to
194 access an PostgreSQL server. The server is included in the main
195 package. If all you need is to connect to another PostgreSQL server,
196 the this is the only package you need to install.
198 In this package there are client libraries available for C and C++, as
199 well as several command-line utilities you can use to manage your
200 databases on a remote PostgreSQL server.
202 %description -l pl clients
203 Pakiet zawiera klientów oraz biblioteki niezbêdne dla dostêpu do
204 serwera PostgreSQL. Serwer znajduje siê w g³ównym pakiecie.
207 Summary: Perl interface to PostgreSQL database
208 Summary(pl): Interface dla Perl'a umo¿liwiaj±cy dostêp do baz PostgreSQL
209 Group: Applications/Databases
210 Group(pl): Aplikacje/Bazy danych
211 Requires: perl >= 5.004
212 Requires: %{name}-libs = %{version}
215 This package includes only perl modules needed to access an PostgreSQL
218 %description -l pl perl
219 Pakiet ten zawiera tylko modu³y Perl'a wymagane dla dostêpu do serwera
223 Summary: The python-based client programs needed for accessing a PostgreSQL server
224 Group: Development/Languages/Python
225 Group(de): Entwicklung/Sprachen/Python
226 Group(pl): Programowanie/Jêzyki/Python
227 Requires: python >= 1.5
228 Requires: %{name}-libs = %{version}
231 postgresql-python includes the python-based client programs and client
232 libraries that you'll need to access a PostgreSQL database management
236 Summary: Documentation for PostgreSQL
237 Summary(pl): Dodatkowa dokumantacja dla PostgreSQL
238 Group: Applications/Databases
239 Group(pl): Aplikacje/Bazy danych
242 This package includes documentation and HOWTO for programmer, admin
243 etc., in HTML format.
245 %description -l pl doc
246 Pakiet ten zawiera dokumentacjê oraz HOWTO m.in. dla programistów,
247 administratorów w formacie HTML.
250 Summary: PostgreSQL libraries
251 Summary(pl): Biblioteki dzielone programu PostgreSQL
254 Group(fr): Librairies
255 Group(pl): Biblioteki
258 PostgreSQL libraries.
260 %description libs -l pl
261 Biblioteki dzielone programu PostgreSQL.
264 Summary: PostgreSQL static libraries
265 Summary(pl): Biblioteki statyczne programu PostgreSQL
266 Group: Development/Libraries
267 Group(de): Entwicklung/Libraries
268 Group(fr): Development/Librairies
269 Group(pl): Programowanie/Biblioteki
270 Requires: %{name}-devel = %{version}
273 PostgreSQL static libraries.
275 %description -l pl static
276 Biblioteki statyczne programu PostgreSQL.
279 Summary: C++ interface to PostgreSQL
280 Summary(pl): Interface C++ do PostgreSQL
281 Group: Applications/Databases
282 Group(pl): Aplikacje/Bazy danych
283 Requires: %{name}-libs = %{version}
286 This package includes library for C++ interface to PostgreSQL.
288 %description -l pl c++
289 Pakiet ten zawiera biblioteki dla interface'u C++ do PostgreSQL.
292 Summary: C++ interface to PostgreSQL - development part
293 Summary(pl): Interface C++ do PostgreSQL - cze¶æ programistyczna
294 Group: Applications/Databases
295 Group(pl): Aplikacje/Bazy danych
296 Requires: %{name}-c++ = %{version}
297 Requires: %{name}-devel = %{version}
299 %description c++-devel
300 This package includes library and header files for C++ interface.
302 %description -l pl c++-devel
303 Pakiet ten zawiera biblioteki i pliki nag³ówkowe dla interface'u C++.
306 Summary: C++ interface to PostgreSQL - static libraries
307 Summary(pl): Interface C++ do PostgreSQL - biblioteki statyczne
308 Group: Applications/Databases
309 Group(pl): Aplikacje/Bazy danych
310 Requires: %{name}-c++-devel = %{version}
312 %description c++-static
313 This package includes static library for interface C++.
315 %description -l pl c++-static
316 Pakiet ten zawiera biblioteki statyczne dla interface'u C++.
319 Summary: ODBC interface to PostgreSQL
320 Summary(pl): Interface ODBC do PostgreSQL
321 Group: Applications/Databases
322 Group(pl): Aplikacje/Bazy danych
323 Requires: %{name}-libs = %{version}
326 This package includes library for interface ODBC.
328 %description -l pl odbc
329 Pakiet ten zawiera biblioteki dla interface'u ODBC.
332 Summary: ODBC interface to PostgreSQL - development part
333 Summary(pl): Interface ODBC do PostgreSQL - cze¶æ programistyczna
334 Group: Applications/Databases
335 Group(pl): Aplikacje/Bazy danych
336 Requires: %{name}-odbc = %{version}
337 Requires: %{name}-devel = %{version}
339 %description odbc-devel
340 This package includes library and header files for interface ODBC.
342 %description -l pl odbc-devel
343 Pakiet ten zawiera biblioteki i pliki nag³ówkowe dla interface'u ODBC.
346 Summary: ODBC interface to PostgreSQL - static libraries
347 Summary(pl): Interface ODBC do PostgreSQL - biblioteki statyczne
348 Group: Applications/Databases
349 Group(pl): Aplikacje/Bazy danych
350 Requires: %{name}-odbc-devel = %{version}
352 %description odbc-static
353 This package includes static library for interface ODBC.
355 %description -l pl odbc-static
356 Pakiet ten zawiera biblioteki statyczne dla interface'u ODBC.
359 Summary: A free graphical database management tool for PostgreSQL.
360 Group: Applications/Databases
361 Group(pl): Aplikacje/Bazy danych
362 Requires: %{name}-tcl = %{version}
364 %description -n pgaccess
365 A free graphical database management tool for PostgreSQL.
368 Summary: tcl interface for PostgreSQL
369 Summary(pl): tcl interface dla PostgreSQL
370 Group: Development/Languages/Tcl
371 Group(de): Entwicklung/Sprachen/Tcl
372 Group(pl): Programowanie/Jêzyki/Tcl
373 Requires: %{name}-libs = %{version}
376 tcl interface for PostgreSQL.
378 %description tcl -l pl
379 tcl interface dla PostgreSQL.
382 Summary: Development part of tcl interface for PostgreSQL
383 Summary(pl): Czê¶æ dla programistów interafece tcl dla PostgreSQL
384 Group: Development/Languages/Tcl
385 Group(de): Entwicklung/Sprachen/Tcl
386 Group(pl): Programowanie/Jêzyki/Tcl
387 Requires: %{name}-tcl = %{version}
388 Requires: %{name}-devel = %{version}
390 %description tcl-devel
391 Development part of tcl interface for PostgreSQL.
393 %description tcl-devel -l pl
394 Czê¶æ dla programistów interafece tcl dla PostgreSQL.
397 Summary: Static libraries of tcl interface for PostgreSQL
398 Summary(pl): Biblioteki statyczne interafece tcl dla PostgreSQL
399 Group: Development/Languages/Tcl
400 Group(de): Entwicklung/Sprachen/Tcl
401 Group(pl): Programowanie/Jêzyki/Tcl
402 Requires: %{name}-tcl-devel = %{version}
404 %description tcl-static
405 Static libraries of tcl interface for PostgreSQL
407 %description tcl-devel -l pl
408 Biblioteki statyczne interafece tcl dla PostgreSQL
410 %package module-datetime
411 Summary: Some useful datetime functions for PostgreSQL
412 Summary(pl): Kilka u¿ytecznych funkcji operuj±cych na dacie i czasie dla PostgreSQL
413 Group: Applications/Databases
414 Group(pl): Aplikacje/Bazy danych
415 Requires: %{name} = %{version}
417 %description module-datetime
418 Some useful datetime function for PostgreSQL such as:
422 - time_difference(time,time)
432 - currentdate() To enable them you need to execute
433 datetime_function.sql script. You can found it in /usr/share/pgsql/sql
436 %description module-datetime -l pl
437 Kilka u¿ytecznych funkcji operuj±cych na dacie i czasie dla
442 - time_difference(time,time)
452 - currentdate() Po wykonaniu skryptu datetime_function.sql mo¿na
453 u¿ywaæ tych funkcji z poziomu zapytañ SQL. Skrypt ten znajduje siê w
454 katalogu /usr/share/pgsql/sql.
456 %package module-plpgsql
457 Summary: PL/pgSQL - PostgreSQL procedural language
458 Summary(pl): PL/pgSQL jêzyk proceduralny bazy danych PostgreSQL
459 Group: Applications/Databases
460 Group(pl): Aplikacje/Bazy danych
461 Requires: %{name} = %{version}
463 %description module-plpgsql
464 From PostgreSQL documentation.
466 Postgres supports the definition of procedural languages. In the case
467 of a function or trigger procedure defined in a procedural language,
468 the database has no built-in knowledge about how to interpret the
469 function's source text. Instead, the task is passed to a handler that
470 knows the details of the language. The handler itself is a special
471 programming language function compiled into a shared object and loaded
474 To enable PL/pgSQL procedural language for your database you have to
475 run createlang command.
477 %description module-plpgsql -l pl
478 Z dokumentacji PostgreSQL.
480 Postgres ma wsparcie dla jêzyków proceduralnych. W przypadku, kiedy
481 programista zdefiniuje procedurê wyzwalacza lub funkcjê w jêzyku
482 proceduralnym, baza danych nie ma pojêcia jak interpretowaæ tego typu
483 funkcjê. Funkcja lub procedura ta jest przekazywana do interpretera,
484 który wie jak j± wykonaæ. Interpreter jest odpowiedni±, specjaln±
485 funkcj±, która jest skompilowana w obiekt dzielony i ³adowany w razie
488 Za pomoc± komendy createlang mo¿na dodaæ wsparcie dla jêzyka
489 proceduralnego PL/pgSQL dla swojej bazy danych.
491 %package module-pltcl
492 Summary: PL/TCL - PostgreSQL procedural language
493 Summary(pl): PL/TCL jêzyk proceduralny bazy danych PostgreSQL
494 Group: Applications/Databases
495 Group(pl): Aplikacje/Bazy danych
496 Requires: %{name} = %{version}
498 %description module-pltcl
499 From PostgreSQL documentation.
501 Postgres supports the definition of procedural languages. In the case
502 of a function or trigger procedure defined in a procedural language,
503 the database has no built-in knowledge about how to interpret the
504 function's source text. Instead, the task is passed to a handler that
505 knows the details of the language. The handler itself is a special
506 programming language function compiled into a shared object and loaded
509 To enable PL/TCL procedural language for your database you have to run
512 %description module-pltcl -l pl
513 Z dokumentacji PostgreSQL.
515 Postgres ma wsparcie dla jêzyków proceduralnych. W przypadku, kiedy
516 programista zdefiniuje procedurê wyzwalacza lub funkcjê w jêzyku
517 proceduralnym, baza danych nie ma pojêcia jak interpretowaæ tego typu
518 funkcjê. Funkcja lub procedura ta jest przekazywana do interpretera,
519 który wie jak j± wykonaæ. Interpreter jest odpowiedni±, specjaln±
520 funkcj±, która jest skompilowana w obiekt dzielony i ³adowany w razie
523 Za pomoc± komendy createlang mo¿na dodaæ wsparcie dla jêzyka
524 proceduralnego PL/TCL dla swojej bazy danych.
536 rm -fR `find contrib/ -type d -name CVS`
539 PATH=$PATH:. ; export PATH
543 # NOTE: this doesn't work.
544 #CONFIGURE_OPT=%{pgsql_with_locale?: "--enable-locale"}
545 #CONFIGURE_OPT="$CONFIGURE_FLAGS %{pgsql_with_unicode?: --with-mulitbyte=UNICODE}"
551 --with-template=linux_i386 \
553 --with-template=linux_%{_target_cpu} \
557 --enable-unicode-conversion \
560 --with-odbcinst=%{_sysconfdir} \
565 --with-perl $CONFIGURE_OPT
567 %{__make} OPT="%{!?debug:$RPM_OPT_FLAGS}%{?debug:-O -g}" \
568 TEMPLATEDIR=%{_libdir}/pgsql
571 %{__make} all PGDOCS=unpacked -C doc
574 make -C src/bin/pgaccess clean pgaccess POSTGRESDIR=/usr/lib
576 # for datetime functions
577 make -C contrib/datetime LIBDIR=%{_libdir}/pgsql
580 rm -rf $RPM_BUILD_ROOT
581 install -d $RPM_BUILD_ROOT%{_sysconfdir}/{rc.d/init.d,sysconfig} \
582 $RPM_BUILD_ROOT/var/{lib/pgsql,log} \
583 $RPM_BUILD_ROOT%{_libdir}/pgsql/{modules,sql} \
584 $RPM_BUILD_ROOT{%{_applnkdir}/System,%{_pixmapsdir}}
586 %{__make} -C src install \
587 DESTDIR=$RPM_BUILD_ROOT \
588 TEMPLATEDIR=%{_libdir}/pgsql \
589 INSTALLMAN3DIR=$RPM_BUILD_ROOT%{_mandir}/man3
591 %{__make} -C doc install DESTDIR=$RPM_BUILD_ROOT
592 touch $RPM_BUILD_ROOT/var/log/pgsql
595 ln -sf . $RPM_BUILD_ROOT%{_libdir}/pgaccess/lib
597 # for datetime functions
598 %{__make} -C contrib/datetime install LIBDIR=$RPM_BUILD_ROOT%{_libdir}/pgsql
600 # Move PL/pgSQL procedural language to %{pgmoduledir}
601 ( cd $RPM_BUILD_ROOT%{_libdir}
602 mv -f plpgsql.so $RPM_BUILD_ROOT%{pgmoduledir}
605 # Move PL/TCL procedural language to %{pgmoduledir}
606 ( cd $RPM_BUILD_ROOT%{_libdir}
607 mv -f pltcl.so $RPM_BUILD_ROOT%{pgmoduledir}
611 ( cd $RPM_BUILD_ROOT%{perl_sitearch}/auto/Pg
612 mv -f .packlist .packlist.old
613 sed -e "s|$RPM_BUILD_ROOT/|/|g" -e "s|./||" < .packlist.old > .packlist
617 install %{SOURCE1} $RPM_BUILD_ROOT/etc/rc.d/init.d/postgresql
618 install %{SOURCE3} $RPM_BUILD_ROOT/etc/sysconfig/postgresql
619 install %{SOURCE4} $RPM_BUILD_ROOT%{_applnkdir}/System
620 install %{SOURCE5} $RPM_BUILD_ROOT%{_pixmapsdir}
624 tar xzf $RPM_SOURCE_DIR/pgsql-Database-HOWTO-html.tar.gz
627 # Install all header files. They are required
628 # by executor/spi.h and commands/trigger.h
631 cp -rf * $RPM_BUILD_ROOT%{_includedir}/pgsql
634 # replace symlinks to header fiels by files
635 rm -f $RPM_BUILD_ROOT%{_includedir}/pgsql/dynloader.h
636 rm -f $RPM_BUILD_ROOT%{_includedir}/pgsql/os.h
638 install src/backend/port/dynloader/linux.h $RPM_BUILD_ROOT%{_includedir}/pgsql/dynloader.h
639 install src/include/port/linux.h $RPM_BUILD_ROOT%{_includedir}/pgsql/os.h
642 getgid postgres >/dev/null 2>&1 || /usr/sbin/groupadd -g 88 -r -f postgres
643 id postgres >/dev/null 2>&1 || /usr/sbin/useradd -M -o -r -u 88 \
644 -d /var/lib/pgsql -s /bin/sh -g postgres \
645 -c "PostgreSQL Server" postgres
648 /sbin/chkconfig --add postgresql
650 if [ -r /var/lock/subsys/postmaster ]; then
651 /etc/rc.d/init.d/postgresql restart >&2
653 echo "Run \"/etc/rc.d/init.d/postgresql start\" to start postgresql server."
657 if [ "$1" = "0" ]; then
658 if [ -f /var/lock/subsys/postmaster ]; then
659 /etc/rc.d/init.d/postgresql stop
661 /sbin/chkconfig --del postgresql
664 %post libs -p /sbin/ldconfig
665 %postun libs -p /sbin/ldconfig
667 %post tcl -p /sbin/ldconfig
668 %postun tcl -p /sbin/ldconfig
670 %post clients -p /sbin/ldconfig
671 %postun clients -p /sbin/ldconfig
673 %post c++ -p /sbin/ldconfig
674 %postun c++ -p /sbin/ldconfig
676 %post odbc -p /sbin/ldconfig
677 %postun odbc -p /sbin/ldconfig
680 rm -rf $RPM_BUILD_ROOT
681 rm -f /tmp/tmp_perl_info
684 %defattr(644,root,root,755)
685 %attr(754,root,root) /etc/rc.d/init.d/*
686 %attr(640,root,root) %config(noreplace) %verify(not md5 size mtime) /etc/sysconfig/*
688 %attr(755,root,root) %{_bindir}/createdb
689 %attr(755,root,root) %{_bindir}/createuser
690 %attr(755,root,root) %{_bindir}/dropdb
691 %attr(755,root,root) %{_bindir}/dropuser
692 %attr(755,root,root) %{_bindir}/initdb
693 %attr(755,root,root) %{_bindir}/initlocation
694 %attr(755,root,root) %{_bindir}/pg_encoding
695 %attr(755,root,root) %{_bindir}/pg_passwd
696 %attr(755,root,root) %{_bindir}/pg_version
697 %attr(755,root,root) %{_bindir}/postgres
698 %attr(755,root,root) %{_bindir}/postmaster
699 %attr(755,root,root) %{_bindir}/ipcclean
700 %attr(755,root,root) %{_bindir}/createlang
701 %attr(755,root,root) %{_bindir}/droplang
703 %dir %{_libdir}/pgsql
704 %dir %{_libdir}/pgsql/modules
705 %dir %{_libdir}/pgsql/sql
706 %{_libdir}/pgsql/*.source
707 %{_libdir}/pgsql/*.sample
708 %{_libdir}/pgsql/*.description
710 %attr(750,postgres,postgres) %dir /var/lib/pgsql
711 %attr(640,postgres,postgres) %config(noreplace) %verify(not md5 size mtime) /var/log/pgsql
713 %{_mandir}/man1/createdb.1*
714 %{_mandir}/man1/createlang.1*
715 %{_mandir}/man1/createuser.1*
716 %{_mandir}/man1/dropdb.1*
717 %{_mandir}/man1/droplang.1*
718 %{_mandir}/man1/dropuser.1*
719 %{_mandir}/man1/initdb.1*
720 %{_mandir}/man1/initlocation.1*
721 %{_mandir}/man1/pg_passwd.1*
722 %{_mandir}/man1/postgres.1*
723 %{_mandir}/man1/postmaster.1*
724 %{_mandir}/man1/ipcclean.1*
727 %doc doc/FAQ doc/FAQ_Linux doc/README*
728 %doc COPYRIGHT README HISTORY doc/bug.template
731 %defattr(644,root,root,755)
736 %defattr(644,root,root,755)
737 %attr(755,root,root) %{_libdir}/libpq.so.*.*
738 %attr(755,root,root) %{_libdir}/libecpg.so.*.*
739 %attr(755,root,root) %{_bindir}/pg_id
742 %defattr(644,root,root,755)
743 %attr(755,root,root) %{_libdir}/libecpg.so
744 %attr(755,root,root) %{_libdir}/libpq.so
745 %dir %{_includedir}/pgsql
746 %{_includedir}/pgsql/c.h
747 %{_includedir}/pgsql/config.h
748 %{_includedir}/pgsql/dynloader.h
749 %{_includedir}/pgsql/ecpgerrno.h
750 %{_includedir}/pgsql/ecpglib.h
751 %{_includedir}/pgsql/ecpgtype.h
752 %{_includedir}/pgsql/fmgr.h
753 %{_includedir}/pgsql/libpgeasy.h
754 %{_includedir}/pgsql/libpgtcl.h
755 %{_includedir}/pgsql/libpq-fe.h
756 %{_includedir}/pgsql/libpq-int.h
757 %{_includedir}/pgsql/miscadmin.h
758 %{_includedir}/pgsql/os.h
759 %{_includedir}/pgsql/postgres.h
760 %{_includedir}/pgsql/postgres_ext.h
761 %{_includedir}/pgsql/pqexpbuffer.h
762 %{_includedir}/pgsql/rusagestub.h
763 %{_includedir}/pgsql/sql3types.h
764 %{_includedir}/pgsql/sqlca.h
765 %{_includedir}/pgsql/strdup.h
766 %{_includedir}/pgsql/version.h
767 %{_includedir}/pgsql/access
768 %{_includedir}/pgsql/bootstrap
769 %{_includedir}/pgsql/catalog
770 %{_includedir}/pgsql/commands
771 %{_includedir}/pgsql/executor
772 %{_includedir}/pgsql/iodbc
773 %{_includedir}/pgsql/lib
774 %{_includedir}/pgsql/libpq
775 %{_includedir}/pgsql/mb
776 %{_includedir}/pgsql/nodes
777 %{_includedir}/pgsql/optimizer
778 %{_includedir}/pgsql/parser
779 %{_includedir}/pgsql/regex
780 %{_includedir}/pgsql/rewrite
781 %{_includedir}/pgsql/storage
782 %{_includedir}/pgsql/tcop
783 %{_includedir}/pgsql/utils
784 %attr(755,root,root) %{_bindir}/ecpg
785 %{_mandir}/man1/ecpg.1*
788 %defattr(644,root,root,755)
793 %defattr(644,root,root,755)
794 %attr(755,root,root) %{_libdir}/libec*.so.*.*
795 %attr(755,root,root) %{_libdir}/libpq*.so.*.*
796 %attr(755,root,root) %{_bindir}/pg_dump
797 %attr(755,root,root) %{_bindir}/pg_dumpall
798 %attr(755,root,root) %{_bindir}/pg_upgrade
799 %attr(755,root,root) %{_bindir}/psql
800 %attr(755,root,root) %{_bindir}/vacuumdb
802 %{_mandir}/man1/pg_dump.1*
803 %{_mandir}/man1/pg_dumpall.1*
804 %{_mandir}/man1/pg_upgrade.1*
805 %{_mandir}/man1/psql.1*
809 %defattr(644,root,root,755)
810 %attr(755,root,root) %{_libdir}/libpq++.so.*.*
813 %defattr(644,root,root,755)
814 %attr(755,root,root) %{_libdir}/libpq++.so
815 %{_includedir}/pgsql/libpq++.h
816 %{_includedir}/pgsql/libpq++
819 %defattr(644,root,root,755)
823 %defattr(644,root,root,755)
824 %dir %{perl_sitearch}/auto/Pg
825 %{perl_sitearch}/auto/Pg/Pg.so
826 %attr(755,root,root) %{perl_sitearch}/auto/Pg/Pg.bs
827 %{perl_sitearch}/auto/Pg/autosplit.ix
828 %{perl_sitearch}/auto/Pg/.packlist
829 %{perl_sitearch}/Pg.pm
833 %defattr(644,root,root,755)
834 %doc src/bin/pgaccess/doc/html/*
835 %attr(755,root,root) %{_bindir}/pgaccess
837 %{_applnkdir}/System/pgaccess.desktop
838 %{_pixmapsdir}/pgaccess.png
841 %defattr(644,root,root,755)
842 %attr(755,root,root) %{_libdir}/libpgtcl.so.*.*
843 %attr(755,root,root) %{_libdir}/libpgtcl.so
844 %attr(755,root,root) %{_bindir}/pgtclsh
845 %attr(755,root,root) %{_bindir}/pgtksh
848 %defattr(644,root,root,755)
849 %attr(755,root,root) %{_includedir}/pgsql/libpgtcl.h
852 %defattr(644,root,root,755)
853 %{_libdir}/libpgtcl.a
856 %defattr(644,root,root,755)
857 %doc src/interfaces/odbc/readme.txt src/interfaces/odbc/notice.txt
858 %config(noreplace) %verify(not size mtime md5) %{_sysconfdir}/odbc*
859 %attr(755,root,root) %{_libdir}/libpsqlodbc.so.*.*
862 %defattr(644,root,root,755)
863 %{_includedir}/pgsql/iodbc
864 %attr(755,root,root) %{_libdir}/libpsqlodbc.so
867 %defattr(644,root,root,755)
868 %attr(755,root,root) %{_libdir}/libpsqlodbc.a
870 %files module-datetime
871 %defattr(644,root,root,755)
872 %attr(755,root,root) %{pgmoduledir}/datetime_functions.so
873 %attr(644,root,root) %{pgsqldir}/datetime_functions.sql
875 %files module-plpgsql
876 %defattr(644,root,root,755)
877 %attr(755,root,root) %{pgmoduledir}/plpgsql.so
880 %defattr(644,root,root,755)
881 %attr(755,root,root) %{pgmoduledir}/pltcl.so