postgresql-vl.spec 47 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438
  1. %bcond_with systemd
  2. %bcond_without plperl
  3. %bcond_without pltcl
  4. %bcond_without plpython3
  5. %define non6xpamdeps 0
  6. %define test 0
  7. %define ssl 1
  8. %define kerberos 0
  9. %define nls 1
  10. %define pam 1
  11. %define pgver 12
  12. Summary: PostgreSQL client programs
  13. Summary(ja): PostgreSQL のクライアントプログラム群
  14. Name: postgresql
  15. Version: 13.2
  16. Release: 1%{?_dist_release}%{?with_systemd:.systemd}
  17. Group: office
  18. Vendor: Project Vine
  19. Distribution: Vine Linux
  20. %global pgver %(echo %{version} | sed -e 's/\\.[0-9]*$//')
  21. # Conventions for PostgreSQL Global Development Group RPM releases:
  22. #
  23. # Official PostgreSQL Development Group RPMS have a PGDG after the release number.
  24. # Integer releases are stable -- 0.1.x releases are Pre-releases, and x.y are
  25. # test releases.
  26. #
  27. # Pre-releases are those that are built from CVS snapshots or pre-release
  28. # tarballs from postgresql.org. Official beta releases are not
  29. # considered pre-releases, nor are release candidates, as their beta or
  30. # release candidate status is reflected in the version of the tarball. Pre-
  31. # releases' versions do not change -- the pre-release tarball of 7.0.3, for
  32. # example, has the same tarball version as the final official release of 7.0.3:
  33. # but the tarball is different.
  34. #
  35. # Test releases are where PostgreSQL itself is not in beta, but certain parts of
  36. # the RPM packaging (such as the spec file, the initscript, etc) are in beta.
  37. #
  38. # Pre-release RPM's should not be put up on the public ftp.postgresql.org server
  39. # -- only test releases or full releases should be.
  40. License: BSD
  41. Url: https://www.postgresql.org/
  42. Source0: https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2
  43. Source3: postgresql.init
  44. Source5: https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2.sha256
  45. Source6: README.rpm-dist
  46. Source15: postgresql-bashprofile
  47. Source1000: postgresql.service
  48. Source1001: postgresql.tmpfiles.d
  49. Patch2: postgresql-8.3.3-nls.patch
  50. Patch3: postgresql-7.4-ecpg-patch
  51. BuildRoot: %{_tmppath}/%{name}-%{version}-root
  52. BuildRequires: perl build-essential
  53. BuildRequires: bison, flex, pam-devel
  54. BuildRequires: libicu-devel
  55. %if %{with plpython3}
  56. BuildRequires: python3 python3-devel python3-rpm-macros
  57. %endif
  58. %if %{with pltcl}
  59. BuildRequires: tcl-devel
  60. %endif
  61. BuildRequires: libedit-devel
  62. BuildRequires: zlib-devel >= 1.0.4
  63. %if %ssl
  64. BuildRequires: openssl-devel
  65. %endif
  66. %if %kerberos
  67. BuildRequires: krb5-devel
  68. %endif
  69. %if %nls
  70. BuildRequires: gettext >= 0.10.35
  71. %endif
  72. %if %pam
  73. %if %non6xpamdeps
  74. BuildRequires: pam-devel
  75. %endif
  76. %endif
  77. Obsoletes: postgresql-clients
  78. Obsoletes: postgresql-python
  79. Obsoletes: postgresql7
  80. Conflicts: postgresql8
  81. Conflicts: postgresql8-jdbc
  82. Conflicts: postgresql-jdbc < %{pgver}
  83. Obsoletes: postgresql7-plperl
  84. # This is the PostgreSQL Global Development Group Official RPMset spec file,
  85. # or a derivative thereof.
  86. # Copyright 2001 Lamar Owen <lamar@postgresql.org> <lamar.owen@wgcr.org>
  87. # and others listed.
  88. # Major Contributors:
  89. # ---------------
  90. # Lamar Owen
  91. # Trond Eivind Glomsrd <teg@redhat.com>
  92. # Thomas Lockhart
  93. # Reinhard Max
  94. # Karl DeBisschop
  95. # Peter Eisentraut
  96. # Joe Conway
  97. # and others in the Changelog....
  98. # This spec file and ancilliary files are licensed in accordance with
  99. # The PostgreSQL license.
  100. # On top of this file you can find the default build package list macros. These can be overridden by defining
  101. # on the rpm command line:
  102. # rpm --define 'packagename 1' .... to force the package to build.
  103. # rpm --define 'packagename 0' .... to force the package NOT to build.
  104. # The base package, the lib package, the devel package, and the server package always get built.
  105. %description
  106. PostgreSQL is an advanced Object-Relational database management system
  107. (DBMS) that supports almost all SQL constructs (including
  108. transactions, subselects and user-defined types and functions). The
  109. postgresql package includes the client programs that you'll need
  110. to access a PostgreSQL DBMS server. These PostgreSQL client programs
  111. are programs that directly manipulate the internal structure of
  112. PostgreSQL databases on a PostgreSQL server. These client programs
  113. can be located on the same machine with the PostgreSQL server,
  114. or may be on a remote machine which accesses a PostgreSQL server
  115. over a network connection. This package contains the docs in HTML
  116. for the whole package, as well as command-line utilities for managing
  117. PostgreSQL databases on a PostgreSQL server.
  118. If you want to manipulate a PostgreSQL database on a remote PostgreSQL
  119. server, you need this package. You also need to install this package
  120. if you're installing the postgresql-server package.
  121. %description -l ja
  122. PostgreSQLはSQLの構成要素(トランザクション、副問い合わせおよびユーザ
  123. 定義型やユーザ定義関数など)のほとんどすべてをサポートした、先進的なオブ
  124. ジェクト指向のデータベース管理システム(DBMS)です。postgresqlのパッケー
  125. ジにはPostgreSQL DBMS サーバにアクセスするために必要なクライアントプロ
  126. グラムを収録しています。PostgreSQLクライアントプログラムは、PostgreSQL
  127. サーバ上のPostgreSQLデータベースの内部構造を直接操作するためのプログラ
  128. ムです。これらのクライアントプログラムは、PostgreSQLサーバと同じマシン
  129. 上で動いていてもよいですし、ネットワークコネクションの向こう側にあるリ
  130. モートマシン上にあっても構いません。このパッケージにはPostgreSQLサーバ
  131. 上のPostgreSQLデータベースを管理するためのユーティリティに加え、全パッ
  132. ケージのドキュメントがHTML形式で収録されています。
  133. リモートにあるPostgreSQLサーバ上のPostgreSQLデータベースを操作する場合
  134. はこのパッケージが必要です。またpostgresql-serverパッケージをインスト
  135. ールする場合にも、このパッケージをインストールする必要があります。
  136. %if 0
  137. %package libs
  138. Summary: The shared libraries required for any PostgreSQL clients.
  139. Summary(ja): PostgreSQL クライアントに必要な共有ライブラリ
  140. Group: system
  141. Obsoletes: postgresql7-libs
  142. Conflicts: postgresql8-libs
  143. Conflicts: postgresql-libs >= 9.3.0
  144. %description libs
  145. The postgresql-libs package provides the essential shared libraries for any
  146. PostgreSQL client program or interface. You will need to install this package
  147. to use any other PostgreSQL package or any clients that need to connect to a
  148. PostgreSQL server.
  149. %description -l ja libs
  150. postgresql-libs パッケージは、すべての PostgreSQL クライアントプログラ
  151. ムやインターフェースのための中核的な共有ライブラリを提供します。
  152. PostgreSQL サーバに接続する必要のある、PostgreSQL パッケージやクライア
  153. ントを使う場合には、このパッケージをインストールする必要があります。
  154. %endif
  155. %package server
  156. Summary: The programs needed to create and run a PostgreSQL server.
  157. Summary(ja): PostgreSQL サーバを構築・実行するのに必要なプログラム
  158. Group: servers
  159. Requires: %{name} = %{version}
  160. Requires: /sbin/ldconfig
  161. Requires(pre): shadow-utils
  162. %if %{with systemd}
  163. BuildRequires: systemd-devel
  164. %{?systemd_requires}
  165. %else
  166. Requires: initscripts
  167. Requires(post): chkconfig
  168. Requires(preun): chkconfig, /sbin/service
  169. Requires(postun): chkconfig, /sbin/service
  170. %endif
  171. Obsoletes: postgresql7-server
  172. Conflicts: postgresql8-server
  173. %description server
  174. The postgresql-server package includes the programs needed to create
  175. and run a PostgreSQL server, which will in turn allow you to create
  176. and maintain PostgreSQL databases. PostgreSQL is an advanced
  177. Object-Relational database management system (DBMS) that supports
  178. almost all SQL constructs (including transactions, subselects and
  179. user-defined types and functions). You should install
  180. postgresql-server if you want to create and maintain your own
  181. PostgreSQL databases and/or your own PostgreSQL server. You also need
  182. to install the postgresql package.
  183. %description -l ja server
  184. postgresql-server パッケージには、PostgreSQL サーバを生成して実行する
  185. ために必要なプログラムが含まれています。これらにより、PostgreSQL のデ
  186. ータベースを新規に作成したり、メンテナンスしたりできるようになります。
  187. PostgreSQL は先進的でオブジェクト指向的なデータベース管理システム(DBMS)
  188. であり、(トランザクション、副問い合わせ、ユーザ定義型および関数といっ
  189. た)ほとんどすべての SQL 構造をサポートしています。自分自身の PostgreSQL
  190. サーバを動かして、自分自身の PostgreSQL データベースを作成したりメン
  191. テナンスしたりしたい場合は postgresql-server をインストールする必要が
  192. あります。さらに postgresql パッケージもインストールしてください。
  193. %package llvmjit
  194. Summary: Just-in-time compilation support for PostgreSQL
  195. Summary(ja): PostgreSQLのJust-in-timeコンパイルサポート
  196. Group: programming
  197. Requires: %{name}-server%{?_isa} = %{version}-%{release}
  198. Requires: llvm => 5.0
  199. Provides: postgresql-llvmjit >= %{version}-%{release}
  200. BuildRequires: llvm-devel
  201. BuildRequires: clang-devel
  202. %description llvmjit
  203. The postgresql-llvmjit package contains support for
  204. just-in-time compiling parts of PostgreSQL queries. Using LLVM it
  205. compiles e.g. expressions and tuple deforming into native code, with the
  206. goal of accelerating analytics queries.
  207. %package docs
  208. Summary: Extra documentation for PostgreSQL
  209. Summary(ja): PostgreSQL に関するその他の文書
  210. Group: documentation
  211. Obsoletes: postgresql7-docs
  212. Conflicts: postgresql8-docs
  213. %description docs
  214. The postgresql-docs package includes the SGML source for the documentation
  215. as well as the documentation in other formats, and some extra documentation.
  216. Install this package if you want to help with the PostgreSQL documentation
  217. project, or if you want to generate printed documentation.
  218. %package contrib
  219. Summary: Contributed source and binaries distributed with PostgreSQL
  220. Summary(ja): PostgreSQL と一緒に配布される、寄贈されたソースとバイナリ
  221. Group: Applications/Databases
  222. Requires: %{name} = %{version} perl-DBD-Pg
  223. Obsoletes: postgresql7-contrib
  224. Conflicts: postgresql8-contrib
  225. %description contrib
  226. The postgresql-contrib package contains contributed packages that are
  227. included in the PostgreSQL distribution.
  228. %package devel
  229. Summary: PostgreSQL development header files.
  230. Summary(ja): PostgreSQL のサーバサイド開発用ヘッダファイル
  231. Group: programming
  232. Requires: %{name}-static = %{version}
  233. Requires: libicu-devel
  234. Requires: clang-devel
  235. Requires: llvm-devel
  236. Obsoletes: postgresql7-devel
  237. Conflicts: postgresql8-devel
  238. Conflicts: libpq-devel >= 9.3.0
  239. %description devel
  240. The postgresql-devel package contains the header files needed to compile
  241. server-side C or C++ applications.
  242. %description -l ja devel
  243. postgresql-devel パッケージには、PostgreSQL サーバサイド C / C++ アプリケー
  244. ションをコンパイルするために必要なヘッダファイルが含まれています。
  245. %package static
  246. Summary: PostgreSQL development libraries.
  247. Summary(ja): PostgreSQL のサーバサイド開発用ライブラリ
  248. Group: programming
  249. Obsoletes: postgresql7-devel
  250. Conflicts: postgresql8-devel
  251. Conflicts: libpq-devel >= 9.3.0
  252. %description static
  253. The postgresql-static package contains libraries needed to compile
  254. server-side C or C++ applications.
  255. %description -l ja static
  256. postgresql-static パッケージには、PostgreSQL サーバサイド C / C++ アプリケー
  257. ションをコンパイルするために必要なライブラリが含まれています。
  258. #------------
  259. %if %{with plperl}
  260. %package plperl
  261. Summary: The Perl procedural languages for PostgreSQL.
  262. Summary(ja): PostgreSQL用の手続き言語PL/Perl
  263. Group: programming
  264. Requires: %{name} = %{version}
  265. Obsoletes: postgresql7-pl
  266. Conflicts: postgresql8-pl
  267. %description plperl
  268. The postgresql-plperl package contains the PL/Perl procedural language,
  269. which is an extension to the PostgreSQL database server.
  270. Install this if you want to write database functions in Perl.
  271. %endif
  272. #------------
  273. %if %{with pltcl}
  274. %package pltcl
  275. Summary: The Tcl procedural languages for PostgreSQL.
  276. Summary(ja): PostgreSQL用の手続き言語PL/Tcl
  277. Group: programming
  278. Requires: %{name} = %{version}
  279. Obsoletes: postgresql7-pl
  280. Conflicts: postgresql8-pl
  281. %description pltcl
  282. The postgresql-pltcl package contains the PL/Tcl procedural language,
  283. which is an extension to the PostgreSQL database server.
  284. Install this if you want to write database functions in Tcl.
  285. %endif
  286. #------------
  287. %if %{with plpython3}
  288. %package plpython3
  289. Summary: The Python3 procedural languages for PostgreSQL.
  290. Summary(ja): PostgreSQL用の手続き言語PL/Python
  291. Group: programming
  292. Requires: %{name} = %{version}
  293. Obsoletes: postgresql7-pl
  294. Conflicts: postgresql8-pl
  295. %description plpython3
  296. The postgresql-plpython3 package contains the PL/Python3 procedural language,
  297. which is an extension to the PostgreSQL database server.
  298. Install this if you want to write database functions in Python 3.
  299. %endif
  300. #------------
  301. %if %test
  302. %package test
  303. Summary: The test suite distributed with PostgreSQL.
  304. Summary(ja): PostgreSQL と共に配布されるテストスート
  305. Group: other
  306. Requires: postgresql = %{version}
  307. Obsoletes: postgresql7-test
  308. Conflicts: postgresql8-test
  309. %description test
  310. PostgreSQL is an advanced Object-Relational database management
  311. system. The postgresql-test package includes the sources and pre-built
  312. binaries of various tests for the PostgreSQL database management
  313. system, including regression tests and benchmarks.
  314. %endif
  315. %debug_package
  316. %prep
  317. %setup -q -n postgresql-%{version}
  318. %build
  319. CFLAGS="${CFLAGS:-%optflags}" ; export CFLAGS
  320. CXXFLAGS="${CXXFLAGS:-%optflags}" ; export CXXFLAGS
  321. # Strip out -ffast-math from CFLAGS....
  322. # to link libpq statically.
  323. LIBPQ_PATH=`pwd`/src/interfaces/libpq/libpq.a
  324. perl -pi -e "s|^libpq = .+\$|libpq = $LIBPQ_PATH -lpthread|" src/Makefile.global.in
  325. CFLAGS=`echo $CFLAGS|xargs -n 1|grep -v ffast-math|xargs -n 100`
  326. export PYTHON=%{__python3}
  327. ./configure \
  328. --prefix=%{_prefix} \
  329. --libdir=%{_libdir} \
  330. --disable-rpath \
  331. %if %{with plperl}
  332. --with-perl \
  333. %endif
  334. %if %{with pltcl}
  335. --with-tcl \
  336. --with-tclconfig=%{_libdir} \
  337. %endif
  338. %if %{with plpython3}
  339. --with-python \
  340. %endif
  341. %if %ssl
  342. --with-openssl \
  343. %endif
  344. %if %pam
  345. --with-pam \
  346. %endif
  347. %if %kerberos
  348. --with-krb5=/usr/kerberos \
  349. %endif
  350. %if %nls
  351. --enable-nls \
  352. %endif
  353. --with-libedit-preferred \
  354. --sysconfdir=%{_sysconfdir}/sysconfig/pgsql \
  355. --mandir=%{_mandir} \
  356. --with-docdir=%{_docdir} \
  357. --includedir=%{_includedir}/pgsql \
  358. --datadir=%{_datadir}/pgsql \
  359. --with-icu \
  360. --with-llvm \
  361. %if %{with systemd}
  362. --with-systemd \
  363. %endif
  364. %{nil}
  365. make %{?_smp_mflags} all
  366. make %{?_smp_mflags} -C contrib all
  367. %if %test
  368. pushd src/test
  369. make all
  370. popd
  371. %endif
  372. %install
  373. rm -rf $RPM_BUILD_ROOT
  374. # exclude client libraries.
  375. perl -pi -e 's/^\tinterfaces \\\n//' src/Makefile
  376. make DESTDIR=$RPM_BUILD_ROOT install
  377. make -C contrib DESTDIR=$RPM_BUILD_ROOT install
  378. # copy over Makefile.global to the include dir....
  379. install -m644 src/Makefile.global $RPM_BUILD_ROOT%{_includedir}/pgsql
  380. install -m644 src/Makefile.shlib $RPM_BUILD_ROOT%{_includedir}/pgsql
  381. %if %{with systemd}
  382. install -Dpm0644 %{SOURCE1000} $RPM_BUILD_ROOT%{_unitdir}/postgresql.service
  383. # ... and make a tmpfiles script to recreate it at reboot.
  384. install -Dpm0644 %{SOURCE1001} $RPM_BUILD_ROOT%{_tmpfilesdir}/postgresql.conf
  385. %else
  386. # initscript
  387. install -d $RPM_BUILD_ROOT/etc/rc.d/init.d
  388. sed -e "s/@pgver@/%{pgver}/" \
  389. -e "s|@docdir@|%{_docdir}/postgresql-%{version}|" %{SOURCE3} \
  390. > $RPM_BUILD_ROOT/etc/rc.d/init.d/postgresql
  391. chmod 755 $RPM_BUILD_ROOT/etc/rc.d/init.d/postgresql
  392. %endif
  393. # PGDATA needs removal of group and world permissions due to pg_pwd hole.
  394. install -d -m 700 $RPM_BUILD_ROOT/var/lib/pgsql/data
  395. # backups of data go here...
  396. install -d -m 700 $RPM_BUILD_ROOT/var/lib/pgsql/backups
  397. # postgres' .bash_profile
  398. install -m 644 %{SOURCE15} $RPM_BUILD_ROOT/var/lib/pgsql/.bash_profile
  399. # Create the multiple postmaster startup directory
  400. install -d -m 700 $RPM_BUILD_ROOT/etc/sysconfig/pgsql
  401. %if %test
  402. # tests. There are many files included here that are unnecessary, but include
  403. # them anyway for completeness.
  404. mkdir -p $RPM_BUILD_ROOT%{_libdir}/pgsql/test
  405. cp -a src/test/regress $RPM_BUILD_ROOT%{_libdir}/pgsql/test
  406. install -m 0755 contrib/spi/refint.so $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress
  407. install -m 0755 contrib/spi/autoinc.so $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress
  408. pushd $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress/
  409. strip *.so
  410. popd
  411. %endif
  412. # Fix some more documentation
  413. ##gzip doc/internals.ps
  414. cp %{SOURCE6} README.rpm-dist
  415. ##cp -pr $RPM_BUILD_ROOT%{_docdir}/postgresql/html doc
  416. ##rm -rf $RPM_BUILD_ROOT%{_docdir}/postgresql/html
  417. mkdir -p $RPM_BUILD_ROOT/%{_mandir}/man1
  418. mkdir -p $RPM_BUILD_ROOT/%{_mandir}/man3
  419. mkdir -p $RPM_BUILD_ROOT/%{_mandir}/man7
  420. install -m 644 ./doc/src/sgml/man1/* $RPM_BUILD_ROOT/%{_mandir}/man1
  421. install -m 644 ./doc/src/sgml/man3/* $RPM_BUILD_ROOT/%{_mandir}/man3
  422. install -m 644 ./doc/src/sgml/man7/* $RPM_BUILD_ROOT/%{_mandir}/man7
  423. find_lang_bins ()
  424. {
  425. lstfile=$1 ; shift
  426. cp /dev/null "$lstfile"
  427. for binary; do
  428. %find_lang "$binary"-%{pgver}
  429. cat "$binary"-%{pgver}.lang >>"$lstfile"
  430. done
  431. }
  432. find_lang_bins devel.lst pg_config
  433. find_lang_bins server.lst \
  434. initdb pg_archivecleanup pg_basebackup pg_checksums pg_controldata \
  435. pg_ctl pg_resetwal pg_rewind pg_test_fsync pg_test_timing pg_waldump \
  436. plpgsql postgres pg_upgrade pg_verifybackup
  437. find_lang_bins main.lst \
  438. pg_dump pgscripts psql
  439. %if %{with plperl}
  440. find_lang_bins plperl.lst plperl
  441. %endif
  442. %if %{with plpython3}
  443. # plpython3 shares message files with plpython
  444. find_lang_bins plpython3.lst plpython
  445. %endif
  446. %if %{with pltcl}
  447. find_lang_bins pltcl.lst pltcl
  448. %endif
  449. rm -rf ./extension
  450. mv -f %{buildroot}%{_docdir}/postgresql/extension ./
  451. rm -f %{buildroot}%{_mandir}/man1/ecpg.*
  452. %pre server
  453. groupadd -g 26 -o -r postgres >/dev/null 2>&1 || :
  454. useradd -M -n -g postgres -o -r -d /var/lib/pgsql -s /bin/bash \
  455. -c "PostgreSQL Server" -u 26 postgres >/dev/null 2>&1 || :
  456. touch /var/log/pgsql
  457. chown postgres.postgres /var/log/pgsql
  458. chmod 0700 /var/log/pgsql
  459. if [ $1 -gt 1 ]; then
  460. if [ -e /var/lib/pgsql/data/PG_VERSION ]; then
  461. PGVER=`cat /var/lib/pgsql/data/PG_VERSION`
  462. if [ "x%{pgver}" != "x$PGVER" -a ! -d /var/lib/pgsql/$PGVER ]; then
  463. mkdir -p /var/lib/pgsql/$PGVER/{bin,share,%{_lib}/postgresql}
  464. mv -f /var/lib/pgsql/data /var/lib/pgsql/$PGVER/
  465. cp -af %{_datadir}/pgsql /var/lib/pgsql/$PGVER/share/
  466. for f in %{_libdir}/postgresql/*; do
  467. cp -af $f /var/lib/pgsql/$PGVER/%{_lib}/postgresql/
  468. done
  469. for f in `rpm -ql %{name}-server | grep /usr/bin/`; do
  470. cp -af $f /var/lib/pgsql/$PGVER/bin/
  471. done
  472. cat - <<EOF > /var/lib/pgsql/pgsql_upgrade.sh
  473. #!/bin/sh
  474. sudo -u postgres pg_upgrade -d /var/lib/pgsql/$PGVER/data/ -D /var/lib/pgsql/data -b /var/lib/pgsql/$PGVER/bin/ -B /usr/bin
  475. EOF
  476. chown postgres.postgres /var/lib/pgsql/pgsql_upgrade.sh
  477. chmod 700 /var/lib/pgsql/pgsql_upgrade.sh
  478. cat - <<EOF
  479. The old database was saved into /var/lib/pgsql/$PGVER/data/ and
  480. a migration script was created as /var/lib/pgsql/pgsql_upgrade.sh
  481. EOF
  482. fi
  483. fi
  484. fi
  485. %post server
  486. /sbin/ldconfig
  487. %if %{with systemd}
  488. %systemd_post postgresql.service
  489. %else
  490. chkconfig --add postgresql
  491. %endif
  492. %preun server
  493. %if %{with systemd}
  494. %systemd_preun postgresql.service
  495. %else
  496. if [ $1 = 0 -o -x /bin/systemctl ] ; then
  497. chkconfig --del postgresql
  498. fi
  499. %endif
  500. %postun server
  501. /sbin/ldconfig
  502. %if %{with systemd}
  503. %systemd_postun_with_restart postgresql.service
  504. %else
  505. if [ $1 -ge 1 ]; then
  506. /sbin/service postgresql condrestart >/dev/null 2>&1
  507. fi
  508. if [ $1 = 0 ] ; then
  509. if [ ! -x /usr/bin/postgres ] ; then
  510. userdel postgres >/dev/null 2>&1 || :
  511. groupdel postgres >/dev/null 2>&1 || :
  512. fi
  513. fi
  514. %endif
  515. %if %{with plperl}
  516. %post -p /sbin/ldconfig plperl
  517. %postun -p /sbin/ldconfig plperl
  518. %endif
  519. %if %{with plpython3}
  520. %post -p /sbin/ldconfig plpython3
  521. %postun -p /sbin/ldconfig plpython3
  522. %endif
  523. %if %{with pltcl}
  524. %post -p /sbin/ldconfig pltcl
  525. %postun -p /sbin/ldconfig pltcl
  526. %endif
  527. %if %test
  528. %post test
  529. chown -R postgres.postgres %{_datadir}/pgsql/test >/dev/null 2>&1 || :
  530. %endif
  531. %clean
  532. rm -rf $RPM_BUILD_ROOT
  533. %files -f main.lst
  534. %defattr(-,root,root)
  535. %license COPYRIGHT
  536. %doc doc/KNOWN_BUGS doc/MISSING_FEATURES
  537. %doc README HISTORY INSTALL
  538. %doc README.rpm-dist
  539. ##doc doc/html
  540. %{_bindir}/clusterdb
  541. %{_bindir}/createdb
  542. %{_bindir}/createuser
  543. %{_bindir}/dropdb
  544. %{_bindir}/dropuser
  545. %{_bindir}/pg_dump
  546. %{_bindir}/pg_dumpall
  547. %{_bindir}/pg_restore
  548. %{_bindir}/psql
  549. %{_bindir}/reindexdb
  550. %{_bindir}/vacuumdb
  551. %{_mandir}/man1/clusterdb.*
  552. %{_mandir}/man1/createdb.*
  553. %{_mandir}/man1/createuser.*
  554. %{_mandir}/man1/dropdb.*
  555. %{_mandir}/man1/dropuser.*
  556. %{_mandir}/man1/pg_dump.*
  557. %{_mandir}/man1/pg_dumpall.*
  558. %{_mandir}/man1/pg_restore.*
  559. %{_mandir}/man1/psql.*
  560. %{_mandir}/man1/reindexdb.*
  561. %{_mandir}/man1/vacuumdb.*
  562. %{_mandir}/man3/*
  563. %{_mandir}/man7/*
  564. %dir %{_libdir}/postgresql/bitcode
  565. %files docs
  566. %defattr(-,root,root)
  567. %doc doc/src/*
  568. %files contrib
  569. %defattr(-,root,root)
  570. %doc contrib/README contrib/spi/*.example
  571. %{_libdir}/postgresql/_int.so
  572. %{_libdir}/postgresql/adminpack.so
  573. %{_libdir}/postgresql/amcheck.so
  574. %{_libdir}/postgresql/auth_delay.so
  575. %{_libdir}/postgresql/auto_explain.so
  576. %{_libdir}/postgresql/autoinc.so
  577. %{_libdir}/postgresql/bloom.so
  578. %{_libdir}/postgresql/btree_gin.so
  579. %{_libdir}/postgresql/btree_gist.so
  580. %{_libdir}/postgresql/citext.so
  581. %{_libdir}/postgresql/cube.so
  582. %{_libdir}/postgresql/dblink.so
  583. %{_libdir}/postgresql/dict_int.so
  584. %{_libdir}/postgresql/dict_xsyn.so
  585. %{_libdir}/postgresql/earthdistance.so
  586. %{_libdir}/postgresql/file_fdw.so
  587. %{_libdir}/postgresql/fuzzystrmatch.so
  588. %{_libdir}/postgresql/hstore.so
  589. %{_libdir}/postgresql/insert_username.so
  590. %{_libdir}/postgresql/isn.so
  591. %{_libdir}/postgresql/lo.so
  592. %{_libdir}/postgresql/ltree.so
  593. %{_libdir}/postgresql/moddatetime.so
  594. %{_libdir}/postgresql/pageinspect.so
  595. %{_libdir}/postgresql/passwordcheck.so
  596. %{_libdir}/postgresql/pg_buffercache.so
  597. %{_libdir}/postgresql/pg_freespacemap.so
  598. %{_libdir}/postgresql/pg_stat_statements.so
  599. %{_libdir}/postgresql/pg_trgm.so
  600. %{_libdir}/postgresql/pg_visibility.so
  601. %{_libdir}/postgresql/pgcrypto.so
  602. %{_libdir}/postgresql/pgoutput.so
  603. %{_libdir}/postgresql/pgrowlocks.so
  604. %{_libdir}/postgresql/pgstattuple.so
  605. %{_libdir}/postgresql/postgres_fdw.so
  606. %{_libdir}/postgresql/refint.so
  607. %{_libdir}/postgresql/seg.so
  608. %{_libdir}/postgresql/sslinfo.so
  609. %{_libdir}/postgresql/tablefunc.so
  610. %{_libdir}/postgresql/tcn.so
  611. %{_libdir}/postgresql/test_decoding.so
  612. %{_libdir}/postgresql/unaccent.so
  613. %{_bindir}/oid2name
  614. %{_bindir}/pg_standby
  615. %{_bindir}/vacuumlo
  616. %{_mandir}/man1/oid2name.*
  617. %{_mandir}/man1/pg_standby.*
  618. %{_mandir}/man1/vacuumlo.*
  619. %if 0
  620. %files libs -f libpq5-%{pgver}.lang
  621. %defattr(-,root,root)
  622. %{_libdir}/libecpg.so.*
  623. %{_libdir}/libecpg_compat.so.*
  624. %{_libdir}/libpgtypes.so.*
  625. %{_libdir}/libpq.so.*
  626. %endif
  627. %files server -f server.lst
  628. %defattr(-,root,root)
  629. %doc extension
  630. %if %{with systemd}
  631. %{_unitdir}/postgresql.service
  632. %{_tmpfilesdir}/postgresql.conf
  633. %else
  634. %{_sysconfdir}/rc.d/init.d/postgresql
  635. %endif
  636. %dir %{_sysconfdir}/sysconfig/pgsql
  637. %{_bindir}/initdb
  638. %{_bindir}/pg_archivecleanup
  639. %{_bindir}/pg_basebackup
  640. %{_bindir}/pg_checksums
  641. %{_bindir}/pg_controldata
  642. %{_bindir}/pg_ctl
  643. %{_bindir}/pg_isready
  644. %{_bindir}/pg_receivewal
  645. %{_bindir}/pg_recvlogical
  646. %{_bindir}/pg_resetwal
  647. %{_bindir}/pg_rewind
  648. %{_bindir}/pg_test_fsync
  649. %{_bindir}/pg_test_timing
  650. %{_bindir}/pg_upgrade
  651. %{_bindir}/pg_verifybackup
  652. %{_bindir}/pg_waldump
  653. %{_bindir}/pgbench
  654. %{_bindir}/postgres
  655. %{_bindir}/postmaster
  656. %{_mandir}/man1/initdb.*
  657. %{_mandir}/man1/pg_archivecleanup.*
  658. %{_mandir}/man1/pg_basebackup.*
  659. %{_mandir}/man1/pg_checksums.*
  660. %{_mandir}/man1/pg_controldata.*
  661. %{_mandir}/man1/pg_ctl.*
  662. %{_mandir}/man1/pg_isready.*
  663. %{_mandir}/man1/pg_receivewal.*
  664. %{_mandir}/man1/pg_recvlogical.*
  665. %{_mandir}/man1/pg_resetwal.*
  666. %{_mandir}/man1/pg_rewind.*
  667. %{_mandir}/man1/pg_test_fsync.*
  668. %{_mandir}/man1/pg_test_timing.*
  669. %{_mandir}/man1/pg_upgrade.*
  670. %{_mandir}/man1/pg_verifybackup.*
  671. %{_mandir}/man1/pg_waldump.*
  672. %{_mandir}/man1/pgbench.*
  673. %{_mandir}/man1/postgres.*
  674. %{_mandir}/man1/postmaster.*
  675. %dir %{_libdir}/postgresql
  676. %{_libdir}/postgresql/dict_snowball.so
  677. %{_libdir}/postgresql/libpqwalreceiver.so
  678. %{_libdir}/postgresql/pg_prewarm.so
  679. %{_libdir}/postgresql/plpgsql.so
  680. %{_libdir}/postgresql/*_and_*.so
  681. %{_libdir}/postgresql/euc2004_sjis2004.so
  682. %{_libdir}/postgresql/tsm_system_rows.so
  683. %{_libdir}/postgresql/tsm_system_time.so
  684. %dir %{_datadir}/pgsql
  685. %{_datadir}/pgsql/errcodes.txt
  686. %dir %{_datadir}/pgsql/extension
  687. %{_datadir}/pgsql/extension/*
  688. %exclude %{_datadir}/pgsql/extension/pl*
  689. %{_datadir}/pgsql/*.sql
  690. %{_datadir}/pgsql/postgres.bki
  691. %{_datadir}/pgsql/*.sample
  692. %{_datadir}/pgsql/sql_features.txt
  693. %{_datadir}/pgsql/timezone
  694. %{_datadir}/pgsql/timezonesets
  695. %{_datadir}/pgsql/tsearch_data
  696. %attr(700,postgres,postgres) %dir /var/lib/pgsql
  697. %attr(700,postgres,postgres) %dir /var/lib/pgsql/data
  698. %attr(700,postgres,postgres) %dir /var/lib/pgsql/backups
  699. %attr(644,postgres,postgres) %config(noreplace) /var/lib/pgsql/.bash_profile
  700. %files llvmjit
  701. %defattr(-,root,root)
  702. %{_libdir}/postgresql/bitcode/*
  703. %{_libdir}/postgresql/llvmjit.so
  704. %{_libdir}/postgresql/llvmjit_types.bc
  705. %files devel -f devel.lst
  706. %defattr(-,root,root)
  707. %{_includedir}/pgsql
  708. %{_bindir}/pg_config
  709. %{_libdir}/postgresql/pgxs
  710. %{_mandir}/man1/pg_config.*
  711. %files static
  712. %{_libdir}/libpgcommon.a
  713. %{_libdir}/libpgcommon_shlib.a
  714. %{_libdir}/libpgfeutils.a
  715. %{_libdir}/libpgport.a
  716. %{_libdir}/libpgport_shlib.a
  717. %if %{with plperl}
  718. %files plperl -f plperl-%{pgver}.lang
  719. %defattr(-,root,root)
  720. %{_libdir}/postgresql/plperl.so
  721. %{_libdir}/postgresql/bool_plperl.so
  722. %{_libdir}/postgresql/hstore_plperl.so
  723. %{_libdir}/postgresql/jsonb_plperl.so
  724. %{_datadir}/pgsql/extension/plperl*
  725. %endif
  726. %if %{with pltcl}
  727. %files pltcl -f pltcl-%{pgver}.lang
  728. %defattr(-,root,root)
  729. %{_libdir}/postgresql/pltcl.so
  730. %{_datadir}/pgsql/extension/pltcl*
  731. %endif
  732. %if %{with plpython3}
  733. %files plpython3 -f plpython3.lst
  734. %defattr(-,root,root)
  735. %{_libdir}/postgresql/plpython3.so
  736. %{_libdir}/postgresql/hstore_plpython3.so
  737. %{_libdir}/postgresql/ltree_plpython3.so
  738. %{_libdir}/postgresql/jsonb_plpython3.so
  739. %{_datadir}/pgsql/extension/plpython3*
  740. %endif
  741. %if %test
  742. %files test
  743. %defattr(-,postgres,postgres)
  744. %attr(-,postgres,postgres) %{_libdir}/postgresql/test/*
  745. %attr(-,postgres,postgres) %dir %{_libdir}/postgresql/test
  746. %endif
  747. %changelog
  748. * Fri Feb 12 2021 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 13.2-1
  749. - new upstream release.
  750. * Fri Nov 13 2020 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 13.1-1
  751. - new upstream release.
  752. * Mon Oct 05 2020 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 13.0-1
  753. - new upstream release.
  754. * Mon Aug 17 2020 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 12.4-2
  755. - rebuilt with python-3.8.
  756. * Fri Aug 14 2020 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 12.4-1
  757. - new upstream release.
  758. - fixed %%files.
  759. * Fri May 15 2020 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 12.3-1
  760. - new upstream release.
  761. - added systemd support (disabled as default).
  762. * Fri Feb 14 2020 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 12.2-1
  763. - new upstream release.
  764. * Fri Oct 04 2019 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 12.0-1
  765. - new upstream release.
  766. * Fri Mar 02 2018 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 10.3-1
  767. - new upstream release.
  768. * Fri Apr 1 2016 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 9.5.2-1
  769. - new upstream release.
  770. * Tue Mar 15 2016 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 9.5.1-1
  771. - new upstream release.
  772. * Sat Jan 9 2016 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 9.5.0-1
  773. - new upstream release.
  774. * Fri Oct 9 2015 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 9.4.5-1
  775. - new upstream release.
  776. * Sat Jun 20 2015 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 9.4.4-2
  777. - fixed initscript.
  778. - modified %%pre to prepare for pg_upgrade.
  779. * Sat Jun 13 2015 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 9.4.4-1
  780. - new upstream release.
  781. * Fri Jun 12 2015 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 9.4.3-1
  782. - new upstream release.
  783. * Sun Mar 22 2015 Ryoichi INAGAKI <ryo1@toki.waseda.jp> 9.3.4-2
  784. - rebuilt without readline to avoid GPL infection
  785. - added BuildRequires: libedit-devel instead of readline-devel
  786. - added BuildRequires: tcl-devel instead of tcl
  787. * Tue Apr 1 2014 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 9.3.4-1
  788. - new upstream release.
  789. * Sun Dec 01 2013 Tomohiro "Tomo-p" KATO <tomop@teamgedoh.net> 9.3.1-1
  790. - new upstream release.
  791. - built without client libraries.
  792. * Thu Feb 21 2013 IWAI, Masaharu <iwai@alib.jp> 9.0.12-1
  793. - new upstream release
  794. * Thu Feb 7 2013 IWAI, Masaharu <iwai@alib.jp> 9.0.11-1
  795. - new upstream release
  796. - add Vendor and Distribution tags
  797. * Mon Jan 7 2013 IWAI, Masaharu <iwai@alib.jp> 9.0.7-2vl7
  798. - build with Tcl/Tk 8.5.7-1
  799. - fix init script (Source3): fix su(1) paramaters.
  800. * Tue Mar 06 2012 Daisuke SUZUKI <daisuke@linux.or.jp> 9.0.7-1
  801. - new upstream release
  802. - move euc2004_sjis2004.so from -contrib to -server (BTS:1266)
  803. - remove *_and_*.so from -contrib (included in -server)
  804. * Sat Apr 23 2011 Shu KONNO <owa@bg.wakwak.com> 9.0.4-1
  805. - updated postgresql to 9.0.4
  806. * Tue Apr 12 2011 Shu KONNO <owa@bg.wakwak.com> 9.0.3-1
  807. - updated postgresql to 9.0.3
  808. - separated postgresql-jdbc package
  809. * Thu Feb 03 2011 Shu KONNO <owa@bg.wakwak.com> 8.4.7-1
  810. - updated postgresql to 8.4.7 (contains a variety of fixes)
  811. * Sat Jan 29 2011 Shu KONNO <owa@bg.wakwak.com> 8.4.6-1
  812. - updated postgresql to 8.4.6
  813. - updated JDBC2 driver to postgresql-8.3-606.{jdbc2,jdbc2ee}.jar
  814. - updated JDBC3 driver to postgresql-8.4-702.jdbc3.jar
  815. - updated JDBC4 driver to postgresql-8.4-702.jdbc4.jar
  816. * Thu Jan 13 2011 Shu KONNO <owa@bg.wakwak.com> 8.4.5-2
  817. - rebuilt with openssl-1.0.0c
  818. * Thu Oct 07 2010 Shu KONNO <owa@bg.wakwak.com> 8.4.5-1
  819. - updated postgresql to 8.4.5
  820. * Sun May 16 2010 Shu KONNO <owa@bg.wakwak.com> 8.4.4-1
  821. - updated postgresql to 8.4.4
  822. * Thu Apr 15 2010 Shu KONNO <owa@bg.wakwak.com> 8.4.3-1
  823. - updated postgresql to 8.4.3
  824. - s/BuildPrereq/Buildrequires/
  825. * Wed Feb 17 2010 Shu KONNO <owa@bg.wakwak.com> 8.4.2-1
  826. - updated postgresql to 8.4.2
  827. - rebuilt with new environment
  828. * Thu Sep 10 2009 Shu KONNO <owa@bg.wakwak.com> 8.4.1-1
  829. - updated postgresql to 8.4.1
  830. * Fri Aug 21 2009 Shu KONNO <owa@bg.wakwak.com> 8.4.0-2
  831. - moved dict_snowball.so from conrib to server
  832. * Tue Jul 07 2009 Shu KONNO <owa@bg.wakwak.com> 8.4.0-1
  833. - updated postgresql to 8.4.0
  834. - updated jdbc3,4 to 701
  835. - dropt postgresql-8.3.3-nls.patch (fixed)
  836. - dropt postgresql-7.4-ecpg-patch (no effect)
  837. * Sat Apr 18 2009 Ryoichi INAGAKI <ryo1@bc.wakwak.com> 8.3.7-2
  838. - changed libs Group to System Environment/Libraries
  839. * Sun Apr 12 2009 Shu KONNO <owa@bg.wakwak.com> 8.3.7-1
  840. - updated postgresql to 8.3.7
  841. * Sun Jan 25 2009 MATSUBAYASHI Kohji <shaolin@vinelinux.org> - 8.3.5-2
  842. - remove "-E EUC_JP --no-locale" option from initdb in postgresql.init
  843. * Thu Jan 22 2009 MATSUBAYASHI Kohji <shaolin@vinelinux.org> - 8.3.5-1
  844. - new upstream release (postgresql to 8.3.5, jdbc to 604)
  845. * Sat Jul 05 2008 Shu KONNO <owa@bg.wakwak.com> 8.3.3-1vl5
  846. - applied new versioning policy, and spec in utf-8
  847. - updated postgresql to 8.3.3
  848. - updated jdbcver to 603
  849. - added postgresql-8.3.3-nls.patch instead of postgresql-8.2.0-nls.patch.gz
  850. - added a script to replace PGVERSION in postgresql.init
  851. * Sun Feb 17 2008 Shu KONNO <owa@bg.wakwak.com> 8.2.6-0vl2
  852. - rebuild with tcl/tk-8.4.18
  853. * Tue Jan 08 2008 Shu KONNO <owa@bg.wakwak.com> 8.2.6-0vl1
  854. - updated postgresql to 8.2.6
  855. - included security fixes: CVE-{2007-6600, 2007-4772, 2007-6067, 2007-4769, 2007-6601}
  856. * Tue Oct 16 2007 Shu KONNO <owa@bg.wakwak.com> 8.2.5-0vl3
  857. - updated PGVERSION to 8.2 in postgresql.init (sorry;)
  858. * Tue Oct 09 2007 Shu KONNO <owa@bg.wakwak.com> 8.2.5-0vl2
  859. - rebuild with tcl/tk-8.4.16
  860. * Wed Sep 19 2007 Shu KONNO <owa@bg.wakwak.com> 8.2.5-0vl1
  861. - updated postgresql to 8.2.5
  862. - updated jdbc driver to 8.2-506, and added 8.2-506.jdbc4.jar
  863. - updated nls-patch to 8-2-0
  864. - dropt postgresql-8.1.4-Pg.patch.gz
  865. * Wed Sep 19 2007 MATSUBAYASHI Kohji <shaolin@vinelinux.org> 8.1.10-0vl1
  866. - for VineSeed
  867. - updated to 8.1.10 (8.1.9 and up has fixes for CVE-2007-2138)
  868. - JDBC driver updated to 410
  869. * Sun Jul 1 2007 Ryoichi INAGAKI <ryo1@bc.wakwak.com> 8.1.5-0vl1
  870. - rebuilt for VineSeed
  871. - fixed install script
  872. * Thu Nov 23 2006 HOTTA Michihide <hotta@net-newbie.com> 8.1.5-0vl0
  873. - upstream release
  874. - fix missing %defattr in %files server
  875. * Fri Sep 15 2006 HOTTA Michihide <hotta@net-newbie.com> 8.1.4-0vl2
  876. - fix version number in postgresql.init
  877. * Tue Sep 12 2006 HOTTA Michihide <hotta@net-newbie.com> 8.1.4-0vl1
  878. - upstream release
  879. - drop rpm-pgsql-8.0.0.patch
  880. - add Requires: perl-DBD-Pg for contrib
  881. - add postgresql-8.1.4-Pg.patch.gz
  882. - update nls patches
  883. - new JDBC driver
  884. * Sat Mar 18 2006 Shu KONNO <owa@bg.wakwak.com> 8.0.3-0vl4
  885. - added build options --without perl, --without python
  886. - rebuilt for x86_64 architecture support
  887. * Tue May 31 2005 HOTTA Michihide <hotta@net-newbie.com> 8.0.3-0vl3
  888. - drop Provides: on postgresql-libs
  889. - drop Requires: libpq.so on postgresql-server
  890. * Tue May 31 2005 HOTTA Michihide <hotta@net-newbie.com> 8.0.3-0vl2
  891. - change SONAME -- Provides: libpq.so.4 libpq.so.4.0 libpq.so
  892. * Thu May 26 2005 HOTTA Michihide <hotta@net-newbie.com> 8.0.3-0vl1
  893. - upstream release
  894. - update nls patches
  895. * Fri Apr 22 2005 HOTTA Michihide <hotta@net-newbie.com> 8.0.2-0vl1
  896. - upstream release
  897. - update nls patches
  898. * Sun Apr 03 2005 Shu KONNO <owa@bg.wakwak.com> 8.0.1-0vl3
  899. - rebuilded with python-2.4.1-0vl1
  900. * Sat Mar 26 2005 Shu KONNO <owa@bg.wakwak.com> 8.0.1-0vl2
  901. - Dropped PyGreSQL-3.4.tgz.
  902. - Dropped PyGreSQL-3.4-setup-2.patch.
  903. - Dropped plpython.so in postgresql-server, because it's exist in postgresql-pl.
  904. - Dropped pyver and pynextver macros.
  905. - Changed macro name "python" to "plpython" like plperl.
  906. - Added "Obsoletes: postgresql-python"
  907. * Fri Feb 18 2005 HOTTA Michihide <hotta@net-newbie.com> 8.0.1-0vl1
  908. - Major version up
  909. - Obsoletes: postgresql7
  910. - update nls patch(es)
  911. - modify %postun not to delete postgres account on upgrade
  912. * Thu Jan 27 2005 HOTTA Michihide <hotta@net-newbie.com> 8.0.0-0vl1
  913. - upstream release (release as a new package)
  914. - Conflicts: postgresql
  915. - update nls patch(es)
  916. - (this package revision was rejected by Vine Project)
  917. * Sat Dec 04 2004 HOTTA Michihide <hotta@net-newbie.com> 7.4.6-0vl2
  918. - upstream release
  919. - new JDBC driver
  920. - add BuildRequires: bison, flex, pam-devel
  921. - drop postgresql-7.4.5-tempfile.patch (repaired)
  922. * Thu Nov 18 2004 IKEDA Katsumi <ikeda@webmasters.gr.jp> 7.4.5-0vl2
  923. - Added a security fix patch postgresql-7.4.5-tempfile.patch
  924. from Gentoo Linux (CAN-2004-0977).
  925. - Changed Patch4:
  926. from PyGreSQL-3.4-setup-2.patch into PyGreSQL-3.4-setup-2.patch
  927. It is possible to compile this package without pre-installed postgresql.
  928. - Removed Patch5 because Patch4 was changed.
  929. * Tue Aug 24 2004 HOTTA Michihide <hotta@net-newbie.com> 7.4.5-0vl1
  930. - upstream release
  931. * Mon Jun 21 2004 HOTTA Michihide <hotta@net-newbie.com> 7.4.3-0vl1
  932. - upstream release
  933. - new jdbc driver
  934. * Sat Apr 17 2004 Shu KONNO <owa@bg.wakwak.com> 7.4.2-0vl3
  935. - rebuild with python-2.3.3-0vl1
  936. * Tue Apr 13 2004 Shu KONNO <owa@bg.wakwak.com> 7.4.2-0vl2.3
  937. - changed mode to 644 at Makefile.global, Makefile.shlib
  938. * Mon Apr 12 2004 Shu KONNO <owa@bg.wakwak.com> 7.4.2-0vl2.2
  939. - updated python install section
  940. * Sat Apr 10 2004 Shu KONNO <owa@bg.wakwak.com> 7.4.2-0vl2.1
  941. - added PyGreSQL-3.4.tgz and set python flag
  942. - added PyGreSQL-3.4-setup.patch
  943. - added PyGreSQL-3.4-pgmodule.patch
  944. - rebuilded with python-2.3.3-0vl0.3 (for TestPkg)
  945. * Sun Mar 28 2004 Ryoichi INAGAKI <ryo1@bc.wakwak.com> 7.4.2-0vl2
  946. - rebuild with new openssl
  947. * Wed Mar 17 2004 HOTTA Michihide <hotta@net-newbie.com> 7.4.2-0vl1
  948. - upstream release
  949. - change all of %{?foo:%define foo 0} -like descriptions to simple
  950. %define format for latest rpm to build.
  951. * Sat Feb 14 2004 HOTTA Michihide <hotta@net-newbie.com> 7.4.1-0vl3
  952. - rebuild on latest tcl package environment.
  953. * Wed Feb 11 2004 HOTTA Michihide <hotta@net-newbie.com> 7.4.1-0vl2
  954. - fixed lacking files at server's %files
  955. * Fri Dec 05 2003 HOTTA Michihide <hotta@net-newbie.com> 7.4-0vl2
  956. - include JDBC driver for 7.4
  957. - fix typo in postgresql-7.4-psql-patch
  958. * Thu Nov 20 2003 HOTTA Michihide <hotta@net-newbie.com> 7.4-0vl1
  959. - upstream release
  960. - change '--includedir=' option to avoid conflicting with unixODBC
  961. - add postgresql-7.4-ecpg-patch
  962. * Wed Sep 10 2003 HOTTA Michihide <hotta@net-newbie.com> 7.3.4-0vl1
  963. - upstream release
  964. * Wed Jul 23 2003 HOTTA Michihide <hotta@net-newbie.com> 7.3.3-0vl2
  965. - drop previous version of libpq's trash
  966. * Wed May 28 2003 HOTTA Michihide <hotta@net-newbie.com> 7.3.3-0vl1
  967. - upstream release with new nls patch
  968. - fix postgresql-bashprofile (value of PGDATA)
  969. - fix postgresql-init for Japanese-specific use (-E EUC_JP --no-locale)
  970. * Wed Apr 02 2003 KOBAYASHI R. Taizo <tkoba@vinelinux.org> 7.3.2-0vl2
  971. - rebuild with tcltk8.4 and readline-4.3
  972. * Fri Mar 07 2003 HOTTA Michihide <hotta@net-newbie.com> 7.3.2-0vl1
  973. - upstream release
  974. * Wed Dec 25 2002 HOTTA Michihide <hotta@net-newbie.com> 7.3.1-0vl1
  975. - upstream release
  976. - remove garbage changelog
  977. * Mon Dec 23 2002 HOTTA Michihide <hotta@net-newbie.com> 7.3-0vl1
  978. - upstream release based on 7.3-2PGDG
  979. - add nls patch
  980. * Thu Dec 05 2002 Lamar Owen <lamar.owen@ramifordistat.net>
  981. - 7.3-2PGDG
  982. - Fix typo in initscript. Argh!!
  983. * Wed Dec 04 2002 Lamar Owen <lamar.owen@ramifordistat.net>
  984. - 7.3-0.5PGDG
  985. - Jerk out all perl client stuff and kludgage
  986. - Rename plperl subpackage to a pl subpackage containing all but PL/Pgsql PL's
  987. - Eliminate locale and multibyte explicit enables -- they are both defaults now
  988. - Eliminate pgaccess code; it's not a part of the main tarball anymore
  989. - Eliminate ODBC stuff -- it's also separate now. Use unixODBC instead.
  990. - Eliminated separate tk client package -- rolled the tk client into the tcl client.
  991. - Moved pltcl into the pl subpackage.
  992. - Added plpython to the pl subpackage.
  993. - /etc/sysconfig/pgsql is sysconfdir for multiple postmaster startup.
  994. * Mon Dec 02 2002 Lamar Owen <lamar.owen@ramifordistat.net>
  995. - 7.3-0.1PGDG (not released)
  996. - Integrate 7.3 jar's courtesy Joe Conway
  997. - Integrate multi-postmaster initscript courtesy Karl DeBisschop
  998. - Some renames and restructures.
  999. - Stripped out the last dregs of the postgresql-dump migration script.
  1000. - Conflicts with less than 7.3.
  1001. - (See below for old changelogs from VineSeed)
  1002. * Fri Oct 04 2002 HOTTA Michihide <hotta@net-newbie.com> 7.2.3-0vl1
  1003. - updated to 7.2.3.
  1004. * Tue Sep 10 2002 HOTTA Michihide <hotta@net-newbie.com> 7.2.2-0vl3
  1005. - absorbed previous patch8 into original nlspatch
  1006. - fixed configure options (--enable-nls and --enable-locale to be antinomy)
  1007. * Fri Aug 30 2002 Shoji Matsumoto <shom@vinelinux.org> 7.2.2-0vl2
  1008. - add patch8 (ja.po for psql was invalid)
  1009. * Thu Aug 29 2002 HOTTA Michihide <hotta@net-newbie.com> 7.2.2-0vl1
  1010. - updated to 7.2.2.
  1011. - improved nlspatch to enable japanese SQL help in psql.
  1012. * Sat Jul 06 2002 HOTTA Michihide <hotta@net-newbie.com> 7.2.1-5vl3
  1013. - fixed garbage chars in description(ja).
  1014. * Wed Jul 03 2002 HOTTA Michihide <hotta@net-newbie.com> 7.2.1-5vl2
  1015. - imported & replaced changelog (following VineSeed's).
  1016. add some stuff to '%%files'.
  1017. * Wed Jul 03 2002 HOTTA Michihide <hotta@net-newbie.com> 7.2.1-5vl1
  1018. - Modified for Vine Linux 2.5. Originaly from RHL 7.2.1-5, adding
  1019. nls patch, pg_dump patch, date_part patch by Jun Kuwamura
  1020. * Thu May 23 2002 Tomohiro 'Tomo-p' KATO <tomop@teamgedoh.net>
  1021. - replace nls patch.
  1022. - add *.mo to '%%files'.
  1023. * Mon Mar 04 2002 Tomohiro 'Tomo-p' KATO <tomop@teamgedoh.net>
  1024. - fix initscript
  1025. * Sun Mar 03 2002 Tomohiro 'Tomo-p' KATO <tomop@teamgedoh.net>
  1026. - add /usr/bin/pg_id to the package (fix)
  1027. * Fri Mar 01 2002 Satoshi MACHINO <machino@vinelinux.org> 7.2-0vl1
  1028. - updated 7.2
  1029. - added nls.patch
  1030. - fixed spec file
  1031. - added New JDBC
  1032. -- pgjdbc1.jar(for JDK1.1.x), pgjdbc2(for Java2)
  1033. * Sat Sep 22 2001 Satoshi MACHINO <machino@vinelinux.org> 7.1.3-4vl1
  1034. - updated 7.1.3
  1035. * Tue Aug 21 2001 Hisao SHIBUYA <shibuya@alpha.or.jp>
  1036. - 7.1.2-7vl3
  1037. - merge 7.1.2-7vl2 and 7.1.2-7
  1038. * Sun Aug 19 2001 MATSUBAYASHI 'Shaolin' Kohji <shaolin@vinelinux.org>
  1039. - 7.1.2-7vl2
  1040. - fixed spec typo (%%{_includesir} -> %%{_includedir})
  1041. * Tue Aug 14 2001 Satoshi MACHINO <machino@vinelinux.org> 7.1.2-7vl1
  1042. - updated 7.1.2 (used postgresql-7.1.2-7)
  1043. - used psqlj patch for 7.1.2
  1044. - used jumbo-20010801.patch.gz
  1045. * Mon Aug 6 2001 Trond Eivind Glomsr <teg@redhat.com> 7.1.2-7
  1046. - Add patches from 7.1-stable branch. This should fix #50799 and #50797
  1047. - Enable kerberos authentication (#50644)
  1048. - handle stop with stale pid file (#50499)
  1049. - make the test subpackage (not built by default) own /usr/lib/pgsql/test
  1050. * Mon Jul 9 2001 Trond Eivind Glomsr <teg@redhat.com>
  1051. - Make the -devel subpackage depend on -libs, not the main package
  1052. * Tue Jun 19 2001 Trond Eivind Glomsr <teg@redhat.com>
  1053. - Make sure the python subpackage depends on mx - otherwise, you'd get an error when importing
  1054. * Mon Jun 18 2001 Florian La Roche <Florian.LaRoche@redhat.de>
  1055. - add changes for s390x
  1056. * Fri Jun 15 2001 Trond Eivind Glomsr <teg@redhat.com>
  1057. - Many path fixes for contrib packages
  1058. - Newer intarray
  1059. - Don't use nested ifs for tkpkg/pgaccess
  1060. - Turn off test package for Red Hat Linux - it makes most sense just to use
  1061. this during development
  1062. - One "pgacess" -> "pgaccess"
  1063. * Wed Jun 13 2001 Lamar Owen <lamar.owen@wgcr.org> <lamar@postgresql.org>
  1064. - -4PGDG
  1065. - patchset update for pg_regress.sh
  1066. - can the dot in the release -- confused too many people and some programs.
  1067. - -3.PGDG
  1068. - updated README.rpm-dist
  1069. - updated patch to 7.1.2, fixing some places where /usr/share/pgsql
  1070. was still being used where /usr/lib/pgsql was intended.
  1071. - PGLIB now set to /usr/lib/pgsql -- initdb doesn't use it to find the bki's.
  1072. * Tue Jun 12 2001 Trond Eivind Glomsr <teg@redhat.com>
  1073. - sync
  1074. - Run chkconfig --add on server install
  1075. - Move the prereqs on useradd on chkconfig to the server package
  1076. - don't disable the %%clean section
  1077. * Sat Jun 09 2001 Lamar Owen <lamar.owen@wgcr.org>
  1078. - Sync up with Trond Eivind's set.
  1079. * Thu Jun 7 2001 Trond Eivind Glomsr <teg@redhat.com>
  1080. - Don't create postgres' .bashrc from the server post script: include it instead
  1081. - Move the test packages from /usr/share/pgsql to /usr/lib/pgsql
  1082. - Move the symlinks libpq.so, libecpg.so, libpq++.so and libpgeasy.so to the devel subpackage from
  1083. libs
  1084. - Source the i18n data from the .bashrc instead of in the initscript
  1085. * Mon May 28 2001 Trond Eivind Glomsr <teg@redhat.com>
  1086. - Handle i18n for database startup - backend needs to have the same locale everytime,
  1087. but this certainly can't be hardcoded to C either
  1088. - Fix stop, restart in initscript (#42217)
  1089. - Make database init _much_ less verbose
  1090. - other minor fixes to the initscript
  1091. * Fri May 25 2001 Trond Eivind Glomsr <teg@redhat.com>
  1092. - 7.1.2
  1093. * Thu May 24 2001 Lamar Owen <lamar@postgresql.org> <lamar.owen@wgcr.org>
  1094. - 7.1.2-0.1.1.PGDG PRERELEASE
  1095. - Changed versioning and release numbering a little for better flexibility,
  1096. -- particularly for distribution packagers.
  1097. - Release numbering comment at top of spec, where it's more useful.
  1098. - Trimmed changelog to 7.1.x. See the last 7.0.3's specfile for the 7.0
  1099. changlog, and the last 6.5.3's specfile for the changelog prior to
  1100. 7.0.
  1101. * Sun May 20 2001 Lamar Owen <lamar@postgresql.org> <lamar.owen@wgcr.org>
  1102. - 7.1.1-4.PGDG
  1103. - _really_ got Python version agnosticism working.
  1104. * Sat May 19 2001 Lamar Owen <lamar@postgresql.org> <lamar.owen@wgcr.org>
  1105. - 7.1.1-3.PGDG Release
  1106. - Python version agnosticism.....
  1107. * Tue May 15 2001 Trond Eivind Glomsr <teg@redhat.com>
  1108. - Use openssl
  1109. - Make it obsolete subpackages if they aren't built
  1110. * Mon May 14 2001 Lamar Owen <lamar@postgresql.org> <lamar.owen@wgcr.org>
  1111. - 7.1.1-2.PGDG Release.
  1112. - Appended .PGDG to release string to differentiate our RPM set from the others.
  1113. - /bin/sh fix in initscript
  1114. - README.rpm-dist updates.
  1115. * Mon May 14 2001 Bernhard Rosenkraenzer <bero@redhat.com> 7.1.1-0.7
  1116. - Rebuild with new readline
  1117. * Thu May 10 2001 Trond Eivind Glomsr <teg@redhat.com>
  1118. - Initial 7.1.1
  1119. * Mon May 7 2001 Trond Eivind Glomsr <teg@redhat.com>
  1120. - Specify shell when running commands through su in the initscript, to avoid problems
  1121. when people switch the postgres user to use tcsh
  1122. * Thu Apr 19 2001 Trond Eivind Glomsr <teg@redhat.com>
  1123. - JDBC driver for Postgresql 7.1
  1124. * Sun Apr 15 2001 Trond Eivind Glomsr <teg@redhat.com>
  1125. - slightly different versioning scheming, will go back to the official
  1126. later when I'm sure the package is ready to use
  1127. * Fri Apr 13 2001 Lamar Owen <lamar@postgresql.org> <lamar.owen@wgcr.org>
  1128. - 7.1 RELEASE
  1129. - 7.1-1 RPM RELEASE
  1130. - Change to COPTS -- strip out -ffastmath -- Considered Harmful.
  1131. - Back to old versioning scheme, kept teg's other fixes.
  1132. - README.rpm-dist updated.
  1133. - PGVERSION updated all-around (hopefully!)
  1134. - Couple of fixes from Peter E.
  1135. - Rearrange dependencies -- only the -libs subpackage is required for most stuff
  1136. - Removed broken and confusing logrotate script.
  1137. * Mon Apr 9 2001 Trond Eivind Glomsr <teg@redhat.com>
  1138. - chown considered harmful - removed
  1139. - fix dangling symlimks (pg_crc.c)
  1140. - libpq.so changes for maximum compatiblity
  1141. - different versioning scheme, to avoid trouble later
  1142. - remove temporary perl file from the file list
  1143. - fix spelling error in tcl description
  1144. - mark odbcinst.ini as a config file
  1145. - use %%defattr on packages which didn't have it
  1146. * Sat Apr 07 2001 Lamar Owen <lamar@postgresql.org> <lamar.owen@wgcr.org>
  1147. - Integrated the PL/Perl stuff from Karl DeBisschop --conditional.
  1148. - Packaging reorg: added contrib and docs subpackages.
  1149. - Removed sgml source docs from main package --> docs subpackage.
  1150. - Removed contrib tree from main package --> contrib subpackage.
  1151. - Contrib tree is now prebuilt -- HOWEVER, very little install work is
  1152. currently done with this.
  1153. * Fri Apr 06 2001 Lamar Owen <lamar@postgresql.org> <lamar.owen@wgcr.org>
  1154. - Quickie RC3. There will be a 7.1RC3-2 shortly with other stuff.
  1155. * Tue Apr 03 2001 Lamar Owen <lamar@postgresql.org> <lamar.owen@wgcr.org>
  1156. - RC2
  1157. - eliminate versioning information for ancilliary files in prep for CVS.
  1158. - Fix docs mixup.
  1159. * Tue Mar 27 2001 Lamar Owen <lamar@postgresql.org> <lamar.owen@wgcr.org>
  1160. - RC1 quickie.
  1161. * Tue Mar 20 2001 Lamar Owen <lamar@postgresql.org>
  1162. - Beta 6 initial build.
  1163. - Use make install-all-headers instead of cpio hack for devel headers.
  1164. - Split out the libs into the libs subpackage.
  1165. - Updated initscript to use pg_ctl to stop
  1166. - Updated initscript to initdb and start postmaster with LC_ALL=C to
  1167. prevent index corruption.
  1168. * Sun Jan 28 2001 Lamar Owen <lamar@postgresql.org>
  1169. - Beta4
  1170. - Return to 'pgsql' directories instead of 'postgresql'
  1171. - Better perl patches.
  1172. * Mon Jan 15 2001 Lamar Owen <lamar@postgresql.org>
  1173. - Edit patches to get rid of some cruft.
  1174. - Eliminate some more pre-7.1 specfile baggage that is no longer necessary.
  1175. - Moved pg_id to server
  1176. - added Makefile.global and pg_config to devel
  1177. - Corrected /usr/include/pgsql to /usr/include/postgresql
  1178. - Fixed some configure options. Will be trying the configure macro next release
  1179. - Since it is terminally ill in this version pg_upgrade is _gone_.
  1180. - Thanks to Peter E for a good review.
  1181. * Sun Jan 14 2001 Lamar Owen <lamar@postgresql.org>
  1182. - Running regression. 1 on the release-o-meter.
  1183. - Minor patches to get regression running right.
  1184. - Initscript tweaking -- the old test for a database structure fails with 7.1's new structure.
  1185. * Sat Jan 13 2001 Lamar Owen <lamar@postgresql.org>
  1186. - Perl 5 needs to be built with PREFIX set on the Makefile, not GNUmakefile....
  1187. - The 7.1 build is different from the 7.0 build -- see the configure line.
  1188. - NOTE: many files that used to be in /usr/share/postgresql are now in /usr/share/postgresql!
  1189. - by request, conditional packages are now supported. See the top of the spec.
  1190. - Fixed the server postinstall problems.
  1191. * Mon Jan 08 2001 Lamar Owen <lamar@postgresql.org>
  1192. - First 7.1 beta test-build