postgresql-vl.spec 45 KB

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