pool/postgresql
SHA256
9
0
Fork 1
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/postgresql?expand=0&rev=3

Browse Source
This commit is contained in:
OBS User unknown
2008-04-21 16:54:40 +00:00
committed by Git OBS Bridge
parent a1371e6d79
commit aa0b33a028
12 changed files with 1780 additions and 1196 deletions
Download Patch File Download Diff File Expand all files Collapse all files

1
baselibs.conf
View File

@@ -1 +0,0 @@
postgresql-libs

3
postgresql-8.2.6.tar.bz2
View File

@@ -1,3 +0,0 @@
version https://git-lfs.github.com/spec/v1
oid sha256:ee41327e821f933de2894d6e0c319edc4b63e80cb902e673b490b7eaf4ead114
size 12559117

36
postgresql-8.3-conf.patch Normal file
View File

@@ -0,0 +1,36 @@
--- ../postgresql-8.3.0.orig/src/backend/utils/misc/postgresql.conf.sample 2008-01-30 13:35:55.000000000 -0500
+++ src/backend/utils/misc/postgresql.conf.sample 2008-02-11 12:05:51.000000000 -0500
@@ -231,13 +231,13 @@
# - Where to Log -
-#log_destination = 'stderr' # Valid values are combinations of
+log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.
# This is used when logging to stderr:
-#logging_collector = off # Enable capturing of stderr and csvlog
+logging_collector = on # Enable capturing of stderr and csvlog
# into log files. Required to be on for
# csvlogs.
# (change requires restart)
@@ -313,7 +313,7 @@
# and their durations, > 0 logs only
# statements running at least this time.
-#silent_mode = off # DO NOT USE without syslog or
+silent_mode = on # DO NOT USE without syslog or
# logging_collector
# (change requires restart)
@@ -328,7 +328,7 @@
#log_disconnections = off
#log_duration = off
#log_hostname = off
-#log_line_prefix = '' # special values:
+log_line_prefix = '%t %d %u ' # special values:
# %u = user name
# %d = database name
# %r = remote host and port

3
postgresql-8.3.1.tar.bz2 Normal file
View File

@@ -0,0 +1,3 @@
version https://git-lfs.github.com/spec/v1
oid sha256:7ccf1e5c987920e4d6eb98b8589939e29d3a361d285055d5af35ddd8e1a2d992
size 13995572

35
postgresql-conf.patch
View File

@@ -1,35 +0,0 @@
--- src/backend/utils/misc/postgresql.conf.sample
+++ src/backend/utils/misc/postgresql.conf.sample
@@ -224,12 +224,12 @@
# - Where to Log -
-#log_destination = 'stderr' # Valid values are combinations of
+log_destination = 'stderr' # Valid values are combinations of
# stderr, syslog and eventlog,
# depending on platform.
# This is used when logging to stderr:
-#redirect_stderr = off # Enable capturing of stderr into log
+redirect_stderr = on # Enable capturing of stderr into log
# files
# (change requires restart)
@@ -303,7 +303,7 @@
#log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements
# and their durations.
-#silent_mode = off # DO NOT USE without syslog or
+silent_mode = on # DO NOT USE without syslog or
# redirect_stderr
# (change requires restart)
@@ -316,7 +316,7 @@
#log_connections = off
#log_disconnections = off
#log_duration = off
-#log_line_prefix = '' # Special values:
+log_line_prefix = '%t %d %u ' # Special values:
# %u = user name
# %d = database name
# %r = remote host and port

2
postgresql-init
View File

@@ -54,7 +54,7 @@ eval DATADIR=${POSTGRES_DATADIR:-~postgres/data}
OPTIONS=${POSTGRES_OPTIONS}
H=/usr/bin/postmaster
test -x $H || exit 5
PIDFILE=/var/lib/pgsql/data/postmaster.pid
PIDFILE=$DATADIR/postmaster.pid
if [ -r $DATADIR/PG_VERSION ] ; then
BIN_VERSION=$($H --version|sed 's/.* \([0-9]\+\.[0-9]\+\).*/\1/')

1067
postgresql-pl.changes
View File

File diff suppressed because it is too large Load Diff

632
postgresql-pl.spec
View File

@@ -1,5 +1,5 @@
#
# spec file for package postgresql-pl (Version 8.2.6)
# spec file for package postgresql-pl (Version 8.3.1)
#
# Copyright (c) 2008 SUSE LINUX Products GmbH, Nuernberg, Germany.
# This file and all modifications and additions to the pristine
@@ -12,16 +12,20 @@
Name: postgresql-pl
BuildRequires: krb5-devel openssl-devel pam-devel python-devel tcl-devel zlib-devel
BuildRequires: bison flex gettext-devel krb5-devel libxml2-devel libxslt-devel
BuildRequires: openldap2-devel openssl-devel pam-devel readline-devel
BuildRequires: ncurses-devel
BuildRequires: python-devel tcl-devel
Summary: The PL/Tcl, PL/Perl, and PL/Python Procedural Languages for PostgreSQL
Version: 8.2.6
Version: 8.3.1
Release: 2
%define pg_minor_version %(echo %version | cut -f1-2 -d.)
License: BSD 3-Clause
Group: Productivity/Databases/Servers
Source0: postgresql-%version.tar.bz2
NoSource: 0
Url: http://www.postgresql.org/
Requires: postgresql-server = 8.2
Requires: postgresql-server = %pg_minor_version
BuildRoot: %{_tmppath}/%{name}-%{version}-build
%define pls plperl plpython tcl
@@ -49,13 +53,13 @@ Authors:
Jan Wieck <JanWieck@Yahoo.com>
%package -n postgresql-plperl
License: X11/MIT
License: BSD 3-Clause
Summary: The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL
Group: Productivity/Databases/Servers
Requires: perl
Obsoletes: postgresql-pl
Provides: postgresql-pl:%_libdir/postgresql/plperl.so
Requires: perl
Requires: postgresql-server = 8.2
Requires: postgresql-server = %pg_minor_version
%description -n postgresql-plperl
This package contains the the PL/Tcl, PL/Perl, and PL/Python procedural
@@ -81,9 +85,9 @@ License: BSD 3-Clause
Summary: The PL/Python Procedural Languages for PostgreSQL
Group: Productivity/Databases/Servers
Obsoletes: postgresql-pl
Provides: postgresql-pl:%_libdir/postgresql/pltcl.so
Provides: postgresql-pl:%_libdir/postgresql/plpython.so
Requires: python
Requires: postgresql-server = 8.2
Requires: postgresql-server = %pg_minor_version
%description -n postgresql-plpython
PostgreSQL is an advanced object-relational database management system
@@ -113,9 +117,9 @@ License: BSD 3-Clause
Summary: PL/Tcl Procedural Language for PostgreSQL
Group: Productivity/Databases/Tools
Obsoletes: postgresql-pl
Provides: postgresql-pl:%_libdir/postgresql/plpython.so
Provides: postgresql-pl:%_libdir/postgresql/pltcl.so
Requires: tcl
Requires: postgresql-server = 8.2
Requires: postgresql-server = %pg_minor_version
%description -n postgresql-pltcl
PostgreSQL is an advanced object-relational database management system
@@ -146,8 +150,7 @@ Authors:
%setup -q -n postgresql-%{version}
%build
#autoconf
export CFLAGS="%optflags"
export CFLAGS="%optflags $SP"
./configure \
--prefix=%_prefix \
--libdir=%_libdir \
@@ -156,23 +159,23 @@ export CFLAGS="%optflags"
--datadir=%_datadir/postgresql \
--mandir=%_mandir \
--with-docdir=%_docdir \
--disable-rpath \
--enable-nls \
--enable-thread-safety \
--enable-thread-safety-force \
--enable-integer-datetimes \
--without-readline \
--with-python \
--with-perl \
--with-tcl \
--without-tk \
--with-tclconfig=%_libdir \
--with-openssl \
--with-pam \
%if %suse_version < 1000
--with-includes="/usr/include/heimdal /usr/include/et" \
%endif
--with-krb5
# needed for plperl
--with-krb5 \
--with-gssapi \
--with-ldap \
--with-libxml \
--with-libxslt \
--with-system-tzdata=/usr/share/zoneinfo
# fmgroids.h is needed for plperl
make -C src/backend ../../src/include/utils/fmgroids.h
for f in %pls; do
make %{?jobs:-j%jobs} -C src/pl/$f all
@@ -204,30 +207,591 @@ rm -rf %buildroot
%_libdir/postgresql/plpython.so
%changelog
* Thu Apr 10 2008 max@suse.de
- Adopt the 8.3.1 package from Peter Eisentraut's OBS project.
- New features in PostgreSQL 8.3 include:
* Full text search is integrated into the core database system
* Support for the SQL/XML standard, including new operators and an
XML data type
* Enumerated data types (ENUM)
* Arrays of composite types
* Universally Unique Identifier (UUID) data type
* Add control over whether NULLs sort first or last
* Updatable cursors
* Server configuration parameters can now be set on a per-function
basis
* User-defined types can now have type modifiers
* Automatically re-plan cached queries when table definitions
change or statistics are updated
* Numerous improvements in logging and statistics collection
* Support multiple concurrent autovacuum processes, and other
autovacuum improvements
- Add baselibs.conf
- Remove old provides/obsoletes tags for way-back package renames.
* Thu Jan 10 2008 max@suse.de
- Update to 8.2.6 to fix five security issues:
- Index Functions Privilege Escalation: CVE-2007-6600
- Regular Expression Denial-of-Service: CVE-2007-4772,
CVE-2007-6067, CVE-2007-4769, #329282
- DBLink Privilege Escalation: CVE-2007-6601, #328403
* Wed Jun 06 2007 max@suse.de
- Split the package into individual subpackages for PL/Perl, PL/Python
and PL/Tcl.
- New version: 8.2.4
- The list of changes between the 8.1 and 8.2 series is too long
to reproduce here. It can be found under
/usr/share/doc/packages/postgresql/HISTORY when the postgresql
package is installed or online at http://www.postgresql.org.
- Splited the postgresql-pl package into individual packages for
PL/Perl, PL/Python and PL/Tcl.
- Added a config file for SuSEfirewall2 (#247370).
* Thu Mar 29 2007 rguenther@suse.de
- Add bison, flex and zlib-devel BuildRequires.
* Tue Oct 17 2006 max@suse.de
- New patchlevel release: 8.1.5
- Disallow aggregate functions in "UPDATE" commands, except within
sub-SELECTs. The behavior of such an aggregate was unpredictable,
and in 8.1.X could cause a crash, so it has been disabled.
- Fix core dump when an untyped literal is taken as ANYARRAY.
- Fix core dump in duration logging for extended query protocol when
a "COMMIT" or "ROLLBACK" is executed.
- Fix mishandling of AFTER triggers when query contains a SQL function
returning multiple rows.
- Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause.
- Fix string_to_array() to handle overlapping matches for the
separator string.
- Fix to_timestamp() for AM/PM formats.
- Fix autovacuum's calculation that decides whether "ANALYZE" is
needed.
- Fix corner cases in pattern matching for psql's \d commands.
- Fix index-corrupting bugs in /contrib/ltree.
- Numerous robustness fixes in ecpg.
- Fix backslash escaping in /contrib/dbmirror.
- Minor fixes in /contrib/dblink and /contrib/tsearch2.
- Efficiency improvements in hash tables and bitmap index scans.
* Wed May 24 2006 max@suse.de
- Update to 8.1.4 to fix SQL injection vulnerabilities
(bug #177931, CVE-2006-2313, CVE-2006-2314).
- Added a new postgresql-SECURITY-NOTICE file with an FAQ that
explains the issues.
* Mon Feb 13 2006 max@suse.de
- New version: 8.1.3 (#150376).
- Relaxed dependencies between subpackages to simplify future
updates.
* Wed Jan 25 2006 mls@suse.de
- converted neededforbuild to BuildRequires
* Fri Jan 13 2006 max@suse.de
- Moved from logrotate to PostgreSQL's own log rotation facility.
- Log files are now located under /var/lib/pgsql/data/pg_log .
- Improved error reporting on test suite failures.
* Thu Dec 22 2005 max@suse.de
- New version: 8.1.1
* Mon Nov 14 2005 uli@suse.de
- hardwire thread safety to yes (test may hang QEMU, same as
postgres.spec)
* Wed Jun 15 2005 max@suse.de
- Specify the path to tclConfig.sh
* Fri Jun 17 2005 max@suse.de
- Removed bogus %%patch3
* Thu Jun 02 2005 max@suse.de
- Added postgresql-CAN-2005-1409-1410-fix.sh for fixing existing
installations, and referred to it in the SECURITY-NOTICE.
* Tue May 17 2005 max@suse.de
- Added postgresql-SECURITY-NOTICE to describe the manual actions
that are needed to apply the bugfixes from 8.0.3 to existing
installations.
* Tue May 10 2005 max@suse.de
- New patch release: 8.0.3
- Fixes bug #82869, CAN-2005-1410, and CAN-2005-1409
- Obsoletes postgresql-CAN-2005-0247.patch
* Mon Apr 11 2005 max@suse.de
- New version: 8.0.2
- New patch release: 8.0.2
* Mon Apr 04 2005 uli@suse.de
- hardwire thread safety to yes (test may hang QEMU)
* Mon Sep 13 2004 max@suse.de
- Take the proper linking options from Perl, so that libperl.so
can be found when loading plperl into the postgresql server.
* Thu Sep 09 2004 max@suse.de
- Fixed the package name inside postgresql-pl.spec.
* Fri Apr 01 2005 uli@suse.de
- ignore regressions on ARM
* Wed Mar 16 2005 max@suse.de
- Prevent the wrapper libs from ending up in the provides list.
* Mon Mar 14 2005 max@suse.de
- Added postgresql-CAN-2005-0247.patch to fix bug #65692.
* Fri Mar 11 2005 max@suse.de
- Added some wrapper libs so that old postmaster binaries, back
to at least 8.1/SLES8 can still be started.
- Extended the init script to use the wrapper libs when needed.
- Setting a senseful umask when creating the postmaster backups
in %%pre.
* Mon Feb 07 2005 max@suse.de
- New patch release: 8.0.1
- Fixes a vulnerability in the LOAD command.
* Wed Jan 19 2005 max@suse.de
- Update to the final 8.0.0 release.
* Wed Dec 22 2004 max@suse.de
- New version: 8.0.0rc2
* Fri Dec 10 2004 max@suse.de
- New version: 8.0.0rc1
- Recoded README.SuSE.de to UTF-8.
* Fri Dec 03 2004 max@suse.de
- New version: 8.0.0beta5
* Thu Nov 18 2004 ro@suse.de
- use kerberos-devel-packages
* Mon Sep 06 2004 max@suse.de
- Created a separate spec file for the postgresql-pl subpackage.
* Fri Aug 20 2004 max@suse.de
- New version: 7.4.5.
* Thu Jul 15 2004 max@suse.de
- New version: 7.4.3.
* Mon May 24 2004 max@suse.de
- Changed dependency of -devel from the main package to -libs
(Bug #40922).
* Mon Apr 05 2004 max@suse.de
- Added postgresql-regression.patch to prevent test failures
during summertime/wintertime changes.
* Thu Mar 11 2004 max@suse.de
- New patch release: 7.4.2
* Fri Jan 16 2004 kukuk@suse.de
- Add pam-devel to neededforbuild
* Mon Jan 12 2004 max@suse.de
- New version: 7.4.1
- Write timestamps to /var/log/postgresql by default.
* Thu Dec 18 2003 max@suse.de
- Package the backend headers as well (make install-all-headers),
because they are needed for server-side modules written in C.
* Tue Nov 18 2003 max@suse.de
- Install pg_config_manual.h and port.h, because they are needed
by c.h (postgresql-include.patch).
* Mon Nov 17 2003 max@suse.de
- New version: 7.4. For details see
http://www.postgresql.org/docs/7.4/static/release.html, or
/usr/share/doc/packages/postgresql/html/release.html
- Overhauled and simplified the spec file.
- Building with Kerberos-Support.
- Building thread-safe client libraries.
- Architecture-dependent tweaks for the testsuite are not needed
anymore.
- Better detection for embedded Python build options.
* Mon Oct 20 2003 schwab@suse.de
- Fix last change.
* Sat Oct 18 2003 adrian@suse.de
- ignore minor mis-calculation on mips
- build as user
* Tue Sep 23 2003 max@suse.de
- Fixed version detection in the pre script of the server package.
(#31570)
- Ignore errors from stop_on_removal (#31607).
* Mon Sep 15 2003 max@suse.de
- Activated the patch, that fixes dbf2pg (#27427). The patch was
added to the package before, but accidentally didn't get applied.
- Improved handling of old versions of the backend (#27114).
- Stopping the server before uninstallation and restarting it
after update (#29038).
* Fri Aug 29 2003 mcihar@suse.cz
- python bindings require same python version as it was built with
* Thu Aug 14 2003 max@suse.de
- Added ServiceRestart to sysconfig template.
* Thu Aug 14 2003 ro@suse.de
- fixed chown usage in init-script
* Mon Aug 04 2003 max@suse.de
- New version: 7.3.4.
- Adopted postgresql-multilib.patch from the official PostgreSQL
RPMs. This obsoletes postgresql-lib64.patch.
- Use test-and-set locks for x86_64 instead of slow semaphores.
(postgresql-x86_64.patch, Bug #27308)
- make use of %%jobs for parallel builds.
- Fix ownership of /etc/logrotate.d/postgresql (Bug #28431).
- Changed the default locale for the server to "C" to avoid a hard
dependency to glibc-locale (bug #28338).
- Enabled charset conversion for dbf2pg (Bug #27427).
* Wed Jul 16 2003 meissner@suse.de
- fix hanging builds by another rework of the ppc64
locking. Apparently we need to do exact stcwx. ; bne ; isync
sequences to stay correct.
* Tue Jun 24 2003 meissner@suse.de
- Fixed the ppc/ppc64 locking, isync was at the wrong
position. Replaced full sync by lwsync. slock_ts can
be 32bit on ppc64 too, we just use lwarx/stwcx which
handle 32bit components.
* Tue Jun 03 2003 max@suse.de
- New version: 7.3.3.
- Remove unpackaged files.
- pg_hba.conf: only allow local connections from the same user
by default.
* Fri Mar 14 2003 max@suse.de
- Fixed generation of sql files in contrib, and really install the
contrib stuff instead of just copying over the source tree
(Bug #25323, postgresql-contrib.patch).
- Fixed the file-list of the server package.
* Wed Mar 12 2003 max@suse.de
- Fixed a typo in the init script (Bug #25115).
* Thu Mar 06 2003 max@suse.de
- Add support for LSB compatible exit codes for start and stop
to pg_ctl (postgresql-lsb.patch).
- Use pg_ctl instead of startproc/killproc in init script, because
it waits until the server is completely fired up or shut down.
(Bug #24395)
- Removed the libpq.so.2.0 link from the package, because it got
removed by ldconfig after installation anyways (Bug #24557).
* Tue Feb 25 2003 max@suse.de
- Mark manpages as documentation.
- Create the backup directory during install.
* Mon Feb 24 2003 max@suse.de
- Make a backup of the server binaries during update, and use the
old server as long as the data files are still in the old format.
* Thu Feb 06 2003 max@suse.de
- New patch release 7.3.2 which fixes several serious bugs.
See HISTORY for details.
* Tue Jan 28 2003 max@suse.de
- Added metadata for the sysconfig editor.
* Mon Jan 20 2003 max@suse.de
- New version: 7.3.1
- Removed old update scripts, because they don't work anymore.
* Thu Jan 16 2003 bg@suse.de
- Changed the expected test results for hppa to the correct files
* Fri Nov 29 2002 max@suse.de
- New version 7.3.
- Compiling with PAM support.
- Client libraries (perl, tcl, odbc, pgeasy, pq++) have been
taken out of the PostgreSQL core distribution and will be
built as separate packages in the future.
- The plperl subpackage has been renamed to pl, and now contains
PL/Perl, PL/Python, and PL/Tcl.
* Fri Sep 13 2002 max@suse.de
- Added circle_poly-overrun.patch to fix a couple of
buffer overruns.
* Thu Sep 12 2002 max@suse.de
- Corrected symlink /usr/lib/libpq.so.2.0 [#19490].
- Fixed ownership of /var/lib/pgsql [#19523].
* Fri Sep 06 2002 max@suse.de
- Recovered time stamps of source files and patches.
* Mon Sep 02 2002 max@suse.de
- Updated to patch release 7.2.2 which fixes some security holes.
- Essential diff between 7.2.1 and 7.2.2 is included.
* Tue Aug 20 2002 mmj@suse.de
- Correct PreReq
* Mon Aug 19 2002 kukuk@suse.de
- Fix requires egenix-mx-base -> python-egenix-mx-base
* Fri Aug 16 2002 ro@suse.de
- don't chmod 644 to directories
* Wed Aug 14 2002 ro@suse.de
- added "missingok" to logrotate config
* Fri Aug 09 2002 max@suse.de
- Removed sysconfig from neededforbuild.
- Using x-devel-packages instead of xf86.
* Thu Aug 08 2002 max@suse.de
- Removed support for older SuSE versions.
- Moved log file cration from %%post to rcpostgresql.
- Changed group for /etc/logrotate.d/postgresql.
* Mon Aug 05 2002 max@suse.de
- Enabled the plperl subpackage.
* Tue Jul 30 2002 max@suse.de
- Fixed regression tests for ppc64.
* Fri Jul 12 2002 max@suse.de
- Re-enabled the regression tests.
- Running test suite as nobody.
- Adjusted ppc and lib64 patch to the scheme of the other
platform patches.
- Better test-and-set assembler code for s390 and s390x.
- Creating postgres user and group during RPM installation.
* Tue Jun 18 2002 meissner@suse.de
- use the powerpc assembler tas() for ppc64 too with adjusted assembler
names.
* Fri May 24 2002 max@suse.de
- New minor release: 7.2.1
- Temporaryly disabled the regression tests due to changes to
mktime() that caused some tests to fail.
* Fri May 24 2002 ke@suse.de
- postgresql-python requires egenix-mx-base (DateTime) [# 14745].
* Wed May 22 2002 meissner@suse.de
- %%_lib fixes for lib64 architectures. Now fails at the same point as i386.
* Wed Mar 20 2002 max@suse.de
- Changed postgresql package to PreReq postgresql-libs instead of
postgresql-lib which is obsolete.
* Fri Mar 08 2002 poeml@suse.de
- add missing / before %%_lib, fixing the preinstall script of -libs
subpackage
* Wed Mar 06 2002 max@suse.de
- Fixed test-and-set assembler code for s390x.
- Made finding of perl and python site-paths more portable.
- Fixed detection of SuSE dist for older releases.
- Some more %%_libdir corrections.
- Using -fPIC for building shared libs on all architectures.
- Leaving out tk and python subpackages if tk and python
are not OK.
* Mon Mar 04 2002 max@suse.de
- Fixed creation of pkgIndex.tcl
- Removed some python stuff from the spec file that is now part of
PostgreSQL's build system.
- Removed unneeded executable permissions from a couple of files.
* Wed Feb 13 2002 max@suse.de
- added support for logrotate
- changed sysconfig stuff and init script to run on both
schemes (<=7.3 and >=8.0).
* Tue Feb 05 2002 max@suse.de
- Updated to 7.2 final.
- See the file /usr/share/doc/packages/postgresql/HISTORY
for changes and incompatibilities since version 7.1.x.
- Adapted the init script to match the new versions of killproc
and PostgreSQL.
* Mon Jan 28 2002 max@suse.de
- Updated to 7.2rc2
- Removed temporary header fix.
- Added a patch for autoconf-2.52 (disabled by derfault).
- Added english version of README.SuSE
* Tue Jan 22 2002 max@suse.de
- removed os.h. It's not needed anymore.
- fixed locations of internal header files (temporary).
- postgresql-python now obsoletes pygresql.
- updated the files lists.
* Mon Jan 21 2002 max@suse.de
- New version 7.2b5
* Tue Dec 18 2001 max@suse.de
- Changed spec file to make use of %%{_libdir} where appropriate.
* Mon Dec 17 2001 max@suse.de
- Removed the START_POSTGRES variable from the fillup template
and changed init script, and spec file to the new scheme.
- Moved the remaining variables from /etc/rc.config to
/etc/sysconfig/postgresql.
* Wed Sep 12 2001 max@suse.de
- New version (patch release): 7.1.3
The ChangeLog says:
- Remove unused WAL segements of large transactions (Tom)
- Multiaction rule fix (Tom)
- Pl/pgSQL memory allocation fix (Jan)
- VACUUM buffer fix (Tom)
- Regression test fixes (Tom)
- pg_dump fixes for GRANT/REVOKE/comments on views,
user-defined types (Tom)
- Fix subselects with DISTINCT ON or LIMIT (Tom)
- BEOS fix
- Disable COPY TO/FROM a view (Tom)
- Cygwin build (Jason Tishler)
- Fixed bug in init script.
It needed a file that comes only with postgresql-devel
- Better Patch for PgTcl. It now sets the client encoding to
UNICODE (PostgreSQL's name for UTF-8) for Tcl versions >= 8.1
instead of using Tcl's conversion functions to get the correct
string representation.
- Added README.SuSE (only german, so far)
- Some minor typo fixes in the spec file.
* Mon Aug 27 2001 utuerk@suse.de
- removed postgresql.conf (now provided by susehelp)
* Mon Jul 23 2001 max@suse.de
- Fixed %%pre and %%post scripts for YaST.
* Thu Jul 19 2001 max@suse.de
- fixed regression tests for SPARC32.
- fixed init script to warn about incompatible data files.
- added patch for Pgtcl to use UTF8 for internal string
representation if compiled with Tcl >= 8.1 .
- added pkgIndex.tcl to allow dynamic loading of Pgtcl using
Tcl's package mechanism.
* Wed Jul 11 2001 max@suse.de
- fixed regression test to succeed on PPC with glibc-2.2.3 .
* Tue Jul 10 2001 max@suse.de
- new version: 7.1.2
- packages again based on the official PostgreSQL RPMs.
- architecture patches are no longer needed.
- running the regression tests as part of the build process to
ensure that only correctly built binaries get packed in.
- new subpackages: contrib, doc
- renamed subpackage lib to libs to conform to the official RPMs
- ToDo: (semi)automatic conversion for updates
from versions prior 7.1.
* Tue May 08 2001 mfabian@suse.de
- bzip2 sources
* Fri Apr 27 2001 max@suse.de
- updated the init script to be more LSB compliant according to
the current /etc/init.d/skeleton.
* Thu Apr 12 2001 max@suse.de
- fix for deprecated declarations in readline 4.2.
- fixed permissons of some shared objects for the backend.
- recovered timestamps of sources.
* Wed Apr 11 2001 utuerk@suse.de
- added postgresql.conf for susehelp
* Thu Mar 22 2001 ro@suse.de
- added split-aliases as provides
* Thu Mar 22 2001 poeml@suse.de
- 7.0.* does not work on PPC unless compiled with -O0 (7.1 will)
* Wed Mar 07 2001 max@suse.de
- added xshared and xdevel to neededforbuild
because X is no longer in the default buildsystem.
* Fri Feb 23 2001 ro@suse.de
- added readline/readline-devel to neededforbuild (split from bash)
* Wed Jan 24 2001 max@suse.de
- added missing "Provides:" entries to specfile.
* Mon Jan 15 2001 max@suse.de
- dropping the locale environment vars from the init script
as workarround for a locale related bug in the backend.
It shows up when the regression test runs on a backend that
has e.g. LC_CTYPE=de_DE .
* Wed Nov 29 2000 max@suse.de
- new version: 7.0.3
- spec file is based on Lamar Owen's source RPM of
PostgreSQL-7.0.3 for SuSE Linux 7.0
- renamed the whole package
postgres -> postgresql
pg_lib -> postgresql-lib
pg_serv -> postgresql-serv
pg_devel -> postgresql-devel
pg_tcl -> postgresql-tcl
pg_tk -> postgresql-tk
pg_odbc -> postgresql-odbc
pg_jdbc -> postgresql-jdbc
pg_pyth -> postgresql-python
pg_perl -> postgresql-perl
pg_test -> postgresql-test
- renamed some files and scripts from *postgres* to *postgresql*
- moved to the LSB-compliant init scheme
- moved database initialisation from SuSEconfig.postgres
into the init script
- changed postgresql-python to use Python2.0 instead of 1.5
* Sat Oct 28 2000 kukuk@suse.de
- Add python-devel to need for build
* Tue Oct 24 2000 bk@suse.de
- integrated change from max:
- changed /sbin/init.d/postgres and SuSEconfig.postgres
to work arround YaST that quotes the value of POSTGRES_DATADIR
in /etc/rc.config when it gets changed.
* Mon Sep 11 2000 fober@suse.de
- made postgres run&autobuild on s390:
- src/include/port/linux.h, src/include/storage/s_lock.h:
s390-assembler test-and-set (thanks to Andreas Jaeger)
- src/template/.similar, src/template/linux_s390:
created linux_s390-Template from linux_ppc.
TODO: is -O0 really needed?
- regression test passes (with minor deviations in floating point
arithmetics)
TODO: the regression test will not run out of the box as we install
it. this is the missing piece, either in postgres-source or in
.spec
[#] missing files
cd $BUILD_ROOT/usr/src/packages/BUILD/postgresql-7.0.2/;
cp -avP src/backend/*.h $RPM_BUILD_ROOT/usr/lib/pgsql
cp -avP src/include $RPM_BUILD_ROOT/usr/lib/pgsql
cp -avP src/Makefile.port $RPM_BUILD_ROOT/usr/lib/pgsql
cp -avP src/Makefile.global $RPM_BUILD_ROOT/usr/lib/pgsql
[#] directory structure
cd $RPM_BUILD_ROOT/usr/lib/pgsql
mkdir src
mv test src
ln -s src/test .
* Mon Aug 28 2000 max@suse.de
- changed installation order to fix bug #3802
* Mon Jul 03 2000 max@suse.de
- Disabled fcntl(F_SETLK) on the postmaster socket to work arround
a kernel bug in Linux <= 2.2.16.
- New subpackage: pg_lib contains the shared libs for C and C++.
* Thu Jun 29 2000 schwab@suse.de
- Fix spinlocks for ia64.
- Reenable ia64 patch on the other architectures.
* Wed Jun 28 2000 max@suse.de
- disabled the ia64 patch when building for other architectures
- database unload+reload on updates works now
- moved some script and config files out of the diff into
source files of their own.
- template database creation moved from init script into SuSEconfig
- some minor cleanups
* Tue Jun 20 2000 schwab@suse.de
- Add support for ia64.
* Fri Jun 09 2000 max@suse.de
- New version: 7.0.2.
- Re-made the whole package based on the original PostgreSQL RPM.
- There is still a little work needed for clean updates from
PostgreSQL 6.x to 7.0.x
- Heavy testing needed before SuSE Linux 7.0.
* Sun Apr 09 2000 bk@suse.de
- added suse update config macro
- added automake to list of packages needed for building postgres
* Thu Feb 10 2000 ke@suse.de
- add more source files from the official PostgreSQL package.
- start to apply patches from there.
- start to cleanup the spec file.
- start to resolve bug #1948.
* Wed Feb 09 2000 ke@suse.de
- add group tag.
- ./configure -> %%build.
- New default for rc.config variable START_POSTGRES ("no").
* Fri Dec 10 1999 ke@suse.de
- update: version 6.5.3.
- startup script: use -S to remove the socket.
* Tue Oct 12 1999 ro@suse.de
- added tcld to neededforbuild
* Mon Sep 13 1999 bs@suse.de
- ran old prepare_spec on spec file to switch to new prepare_spec.
* Mon Aug 02 1999 ke@suse.de
- postgresql init script: remove the socket in /tmp before trying to
start the postmaster.
* Thu Jul 29 1999 ke@suse.de
- update: version 6.5.1.
* Tue Jul 20 1999 ke@suse.de
- remove MANPATH setting from /etc/postgres.{sh,csh} and from
/etc/pg_ifa.{sh,csh}.
- provide manpage links at /usr/share/man:
/usr/lib/pgsql/man/man?/*.?.gz -> /urs/share/man/man?/*.?.pgsql.gz
- now, you'll find all manpage in "pg_ifa".
* Thu Mar 18 1999 ke@suse.de
- compile an install "spi" (on popular demand...).
* Wed Feb 10 1999 ke@suse.de
- security fix: don't create pg_pwd with mode 666 (thanks to mt).
* Mon Feb 01 1999 ke@suse.de
- fix permissions of libs (thanks to mt).
* Fri Jan 08 1999 ke@suse.de
- update: version 6.4.2.
* Tue Dec 01 1998 ke@suse.de
- add /etc/profile.d/{postgres,pg_ifa}.csh (thanks to werner).
- new bootscript (thanks to werner).
* Fri Nov 27 1998 ke@suse.de
- link libpgtcl against libcrypt.
* Thu Nov 12 1998 bs@suse.de
- fixed spec file for new rpm.
* Fri Oct 30 1998 ke@suse.de
- update: version 6.4-BETA4.
* Sun Sep 27 1998 ke@suse.de
- update: version pre6.4 (snapshot 1998-09-27).
- remove pgaccess (it's a separate package now).
- all libraries and binaries are under the separate hierarchy
/usr/lib/pgsql (on customers' request...).
- provide /etc/profile.d/{postgres,pg_ifa}.sh; .csh files are still
missing.
* Mon Aug 24 1998 ke@suse.de
- shut down the postmaster before uninstalling.
* Tue Aug 18 1998 ke@suse.de
- add pgaccess' GIFs (HTML documentation).
* Sat Jul 25 1998 ke@suse.de
- Use `-n postgres' to make the `%%post' script available.
* Mon Jul 13 1998 ke@suse.de
- update pgaccess: version 0.88.
* Thu May 28 1998 ke@suse.de
- New package split: rip out the base interfaces (libraries and database
tools); the new package is called pg_ifa (subpackage).
- update pgaccess: version 0.87.
* Fri May 22 1998 ke@suse.de
- update: version 6.3.2
- package split to ease maintainability and user updates; now, we've the
following packages:
postgres : base packages, essential interfaces included (libpq,
libpq++, libpqtcl and PgAccess).
pg_datab : initial database (needed only for the first
installation or in case of major number updates); if
not installed, the user has to invoke `initdb'
manually.
pg_iface : PostgreSQL interfaces (Perl, JDBC, more to come...).
* Thu May 07 1998 fehr@suse.de
- add library -lXp for Motif 2.1
* Wed Feb 11 1998 fehr@suse.de
- added the perl interface
* Wed Dec 10 1997 ro@suse.de
- build static and dynamic version of dbbrowser and mpsql
* Wed Dec 03 1997 ro@suse.de
- fixed /sbin/init.d/postgres (path, db-path, read rc.config)
moved logfile to /var/log
* Wed Nov 19 1997 bs@suse.de
- skipped man3/abort.3.gz
* Tue Nov 04 1997 fehr@suse.de
- changed to version 6.2.1 of the new postgresSQL
- changed to version 1.5 of mpsql
- changed to version 0.2 of AppGEN
- added version 0.9 if dbbrowser
- prepare package for automatic build
- home Directory of postgrs user must now be /var/lib/postgres
- this Change is a major step since postgres95 it is possible
that some changes are incompatible with the previos postgres
versions.
* Mon Jun 09 1997 fehr@suse.de
- make symbolic link in /usr/doc/packages relative
* Sun Jun 01 1997 bs@suse.de
- moved fillup stuff to var/adm/fillup-templates
* Mon May 12 1997 fehr@suse.de
- added startup-script for /sbin/init.d
- added fillup for /etc/rc.config START_POSTGRES

4
postgresql-rpmlintrc Normal file
View File

@@ -0,0 +1,4 @@
addFilter("useless-explicit-provides")
addFilter("unnecessary-buildrequires")
addFilter("patch-not-applied")
addFilter("non-standard-uid")

32
postgresql.changes
View File

@@ -1,3 +1,35 @@
-------------------------------------------------------------------
Fri Apr 18 11:37:38 CEST 2008 - max@suse.de
- Removed static libs from postgresql-devel.
- Removed more old Obsoletes: tags.
- Fixed path to pid file in init script.
- Moved "make check" to %check section
- Silence some bogus rpmlint warnings
-------------------------------------------------------------------
Thu Apr 10 14:23:15 CEST 2008 - max@suse.de
- Adopt the 8.3.1 package from Peter Eisentraut's OBS project.
- New features in PostgreSQL 8.3 include:
* Full text search is integrated into the core database system
* Support for the SQL/XML standard, including new operators and
an XML data type
* Enumerated data types (ENUM)
* Arrays of composite types
* Universally Unique Identifier (UUID) data type
* Add control over whether NULLs sort first or last
* Updatable cursors
* Server configuration parameters can now be set on a
per-function basis
* User-defined types can now have type modifiers
* Automatically re-plan cached queries when table definitions
change or statistics are updated
* Numerous improvements in logging and statistics collection
* Support multiple concurrent autovacuum processes, and other
autovacuum improvements
- Remove old provides/obsoletes tags for way-back package renames.
-------------------------------------------------------------------
Thu Apr 10 12:54:45 CEST 2008 - ro@suse.de

97
postgresql.spec
View File

@@ -1,5 +1,5 @@
#
# spec file for package postgresql (Version 8.2.6)
# spec file for package postgresql (Version 8.3.1)
#
# Copyright (c) 2008 SUSE LINUX Products GmbH, Nuernberg, Germany.
# This file and all modifications and additions to the pristine
@@ -12,11 +12,13 @@
Name: postgresql
BuildRequires: bison flex krb5-devel openssl-devel pam-devel readline-devel zlib-devel
BuildRequires: bison flex gettext-devel krb5-devel libxslt-devel
BuildRequires: openldap2-devel openssl-devel pam-devel readline-devel zlib-devel
BuildRequires: ncurses-devel
Summary: Basic Clients and Utilities for PostgreSQL
Version: 8.2.6
Release: 26
%define pg_minor_version 8.2
Version: 8.3.1
Release: 2
%define pg_minor_version %(echo %version | cut -f1-2 -d.)
License: BSD 3-Clause
Group: Productivity/Databases/Tools
Source0: postgresql-%version.tar.bz2
@@ -26,11 +28,11 @@ Source8: postgresql-sysconfig
Source9: postgresql-init
Source15: postgresql-bashprofile
Source16: postgresql-firewall
Source17: postgresql-rpmlintrc
Source99: postgresql-pl.spec
Patch1: postgresql-conf.patch
Patch1: postgresql-8.3-conf.patch
PreReq: postgresql-libs = %pg_minor_version
Url: http://www.postgresql.org/
Obsoletes: postgresql-clients postgres
Provides: postgresql = %pg_minor_version
BuildRoot: %{_tmppath}/%{name}-%{version}-build
@@ -60,9 +62,7 @@ Authors:
License: BSD 3-Clause
Summary: Shared Libraries Required for PostgreSQL Clients
Group: Productivity/Databases/Clients
Provides: pg_ifa pg_lib postgresql-lib
Provides: postgresql-libs = %pg_minor_version
Obsoletes: pg_ifa pg_lib postgresql-lib
PreReq: sh-utils fileutils
%description libs
@@ -95,15 +95,12 @@ PreReq: /usr/sbin/useradd /usr/sbin/groupadd /sbin/chkconfig
PreReq: /usr/bin/strings /bin/sed
PreReq: postgresql = %pg_minor_version
Requires: glibc-locale
Provides: pg_serv postgres:/usr/lib/pgsql/bin/postmaster
Provides: postgresql-server = %pg_minor_version
Obsoletes: pg_serv
%package docs
License: BSD 3-Clause
Summary: HTML Documentation for PostgreSQL
Group: Productivity/Databases/Tools
Provides: postgresql:/usr/share/doc/packages/postgresql/html
%description docs
PostgreSQL is an advanced object-relational database management system
@@ -180,8 +177,6 @@ License: BSD 3-Clause
Summary: PostgreSQL development header files and libraries
Group: Productivity/Databases/Tools
Requires: postgresql-libs = %pg_minor_version
Obsoletes: pg_devel
Provides: pg_devel pg_ifa:/usr/lib/pgsql/bin/ecpg
%description devel
PostgreSQL is an advanced object-relational database management system
@@ -209,11 +204,9 @@ Authors:
%setup -q
%build
%if %suse_version > 1000
# uncomment the following line to enable the stack protector
# SP="-fstack-protector"
%endif
export CFLAGS="%optflags $SP"
# uncomment the following line to enable the stack protector
# CFLAGS="$CFLAGS -fstack-protector"
./configure \
--prefix=%_prefix \
--libdir=%_libdir \
@@ -225,23 +218,27 @@ export CFLAGS="%optflags $SP"
--disable-rpath \
--enable-nls \
--enable-thread-safety \
--enable-thread-safety-force \
--enable-integer-datetimes \
--without-python \
--without-perl \
--without-tcl \
--with-openssl \
--with-pam \
%if %suse_version < 1000
--with-includes="/usr/include/heimdal /usr/include/et" \
%endif
--with-krb5
--with-krb5 \
--with-gssapi \
--with-ldap \
--with-libxml \
--with-libxslt \
--with-system-tzdata=/usr/share/zoneinfo
make %{?jobs:-j%jobs} all
make %{?jobs:-j%jobs} -C contrib all
#
%ifnarch %arm
%check
#
# Run the regression tests.
#
%ifnarch %arm
make check || {
for f in log/* regression.diffs; do
if test -f $f; then
@@ -252,14 +249,16 @@ make check || {
exit 1
}
%endif
%install
#
# The patch that changes postgresql.conf needs to be applied here,
# because doing it before "make check" would break the test suite.
#
patch -p0 < %PATCH1
%install
make DESTDIR=%buildroot install
# Don't ship static libraries.
rm %buildroot/%_libdir/*.a
#
# Install and collect the contrib stuff
#
@@ -275,7 +274,9 @@ do
done
install -m 755 %{SOURCE9} %buildroot/etc/init.d/postgresql
install -m 644 %{SOURCE8} %buildroot/var/adm/fillup-templates/sysconfig.postgresql
%if 0%suse_version > 1020
install -m 644 %SOURCE16 %buildroot/etc/sysconfig/SuSEfirewall2.d/services/postgresql
%endif
ln -s ../../etc/init.d/postgresql %buildroot/usr/sbin/rcpostgresql
install -d -m 750 %buildroot/var/lib/pgsql
install -d -m 700 %buildroot/var/lib/pgsql/data
@@ -284,23 +285,10 @@ sed 's,@LIBDIR@,%_libdir,g' %{SOURCE15} > \
%buildroot/var/lib/pgsql/.bash_profile
# Backup directory for old version binaries
install -d %buildroot%_libdir/postgresql/backup
# This hack is needed to keep the old binaries happy:
gcc -shared -o %buildroot%_libdir/postgresql/backup/libkrb5.so.17 -lkrb5
gcc -shared -o %buildroot%_libdir/postgresql/backup/libreadline.so.4 -lreadline
gcc -shared -o %buildroot%_libdir/postgresql/backup/libssl.so.0.9.6 -lssl
gcc -shared -o %buildroot%_libdir/postgresql/backup/libcrypto.so.0.9.6 -lcrypto
# This hack is needed because the soname major version was bumped in a patchlevel release
cp doc/FAQ doc/KNOWN_BUGS doc/MISSING_FEATURES doc/README* COPYRIGHT \
README HISTORY doc/bug.template %buildroot%_docdir/postgresql
cp -a %SOURCE2 %buildroot%_docdir/postgresql/README.SuSE.de
cp -a %SOURCE3 %buildroot%_docdir/postgresql/README.SuSE.en
# Fix the provides-list
%define my_provides /tmp/my-provides
cat << EOF > %my_provides
grep -vE postgresql/backup/lib | %{__find_provides}
EOF
chmod 755 %my_provides
%define __find_provides %my_provides
%post libs
%{?run_ldconfig:%run_ldconfig}
@@ -414,11 +402,15 @@ rm -f %my_provides
%defattr(-,root,root)
%config /etc/init.d/postgresql
%config /var/adm/fillup-templates/sysconfig.postgresql
%if 0%suse_version > 1020
%config /etc/sysconfig/SuSEfirewall2.d/services/postgresql
%endif
%_sbindir/rcpostgresql
%dir %_libdir/postgresql
%_libdir/postgresql/backup
%_libdir/postgresql/plpgsql.so
%_libdir/postgresql/dict_snowball.so
%_datadir/postgresql/tsearch_data
%_bindir/initdb
%doc %_mandir/man1/initdb.1*
%_bindir/ipcclean
@@ -452,7 +444,6 @@ rm -f %my_provides
%_includedir/pgsql
%_bindir/ecpg
%_bindir/pg_config
%_libdir/lib*.a
%_libdir/lib*.so
%_libdir/postgresql/pgxs
%_datadir/locale/*/*/pg_config.mo
@@ -460,6 +451,32 @@ rm -f %my_provides
%doc %_mandir/man1/pg_config.1*
%changelog
* Fri Apr 18 2008 max@suse.de
- Removed static libs from postgresql-devel.
- Removed more old Obsoletes: tags.
- Fixed path to pid file in init script.
- Moved "make check" to %%check section
- Silence some bogus rpmlint warnings
* Thu Apr 10 2008 max@suse.de
- Adopt the 8.3.1 package from Peter Eisentraut's OBS project.
- New features in PostgreSQL 8.3 include:
* Full text search is integrated into the core database system
* Support for the SQL/XML standard, including new operators and
an XML data type
* Enumerated data types (ENUM)
* Arrays of composite types
* Universally Unique Identifier (UUID) data type
* Add control over whether NULLs sort first or last
* Updatable cursors
* Server configuration parameters can now be set on a
per-function basis
* User-defined types can now have type modifiers
* Automatically re-plan cached queries when table definitions
change or statistics are updated
* Numerous improvements in logging and statistics collection
* Support multiple concurrent autovacuum processes, and other
autovacuum improvements
- Remove old provides/obsoletes tags for way-back package renames.
* Thu Apr 10 2008 ro@suse.de
- added baselibs.conf file to build xxbit packages
for multilib support

1064
postgresql.spec.in
View File

File diff suppressed because it is too large Load Diff