--- postgresql-8.4-8.4.1.orig/debian/rules +++ postgresql-8.4-8.4.1/debian/rules @@ -0,0 +1,160 @@ +#!/usr/bin/make -f +TCL_VER := 8.5 +MAJOR_VER := 8.4 + +include /usr/share/cdbs/1/rules/simple-patchsys.mk +include /usr/share/cdbs/1/class/autotools.mk +include /usr/share/cdbs/1/rules/debhelper.mk + +LDFLAGS+= -Wl,--as-needed +CFLAGS+= -fPIC + +ifneq ($(findstring $(DEB_BUILD_ARCH), sparc alpha),) +# sparc and alpha's gcc currently miscompiles; see +# http://lists.debian.org/debian-alpha/2007/11/msg00025.html + CFLAGS+=-O1 +endif + +export DEB_BUILD_HARDENING=1 + +# build should fail on test suite failures on all arches +TESTSUITE_FAIL_CMD=exit 1 + +DEB_DH_INSTALL_SOURCEDIR=debian/tmp +DEB_CONFIGURE_EXTRA_FLAGS := --mandir=\$${prefix}/share/postgresql/$(MAJOR_VER)/man \ + --with-docdir=\$${prefix}/share/doc/postgresql-doc-$(MAJOR_VER) \ + --sysconfdir=/etc/postgresql-common \ + --datadir=\$${prefix}/share/postgresql/$(MAJOR_VER) \ + --bindir=\$${prefix}/lib/postgresql/$(MAJOR_VER)/bin \ + --includedir=\$${prefix}/include/postgresql/ \ + --enable-nls \ + --enable-integer-datetimes \ + --enable-thread-safety \ + --enable-debug \ + --disable-rpath \ + --with-tcl \ + --with-perl \ + --with-python \ + --with-pam \ + --with-krb5 \ + --with-gssapi \ + --with-openssl \ + --with-libxml \ + --with-libxslt \ + --with-ldap \ + --with-ossp-uuid \ + --with-gnu-ld \ + --with-tclconfig=/usr/lib/tcl$(TCL_VER) \ + --with-tkconfig=/usr/lib/tk$(TCL_VER) \ + --with-includes=/usr/include/tcl$(TCL_VER) \ + --with-system-tzdata=/usr/share/zoneinfo \ + --with-pgport=5432 \ + $(ARCH_OPTS) \ + CFLAGS='$(CFLAGS)' \ + LDFLAGS='$(LDFLAGS)' + +DEB_DH_MAKESHLIBS_ARGS := -Xusr/lib/postgresql/$(MAJOR_VER) +# disabled for CVS builds +#DEB_DH_INSTALLCHANGELOGS_ARGS := HISTORY +DEB_COMPRESS_EXCLUDE := .source .c +DEB_DH_INSTALLINIT_ARGS := -u'defaults 19 21' + +# build documentation tarball if not present +common-configure-indep:: doc/postgres.tar.gz doc/man.tar.gz +common-configure-arch:: doc/postgres.tar.gz doc/man.tar.gz + +doc/postgres.tar.gz: + make -C doc/src postgres.tar + mv doc/src/postgres.tar doc/ + gzip -9 doc/postgres.tar + +doc/man.tar.gz: + chmod 755 debian/docbook2man-sgmlspl/* + make -C doc/src man.tar D2MDIR=`pwd`/debian/docbook2man-sgmlspl + mv doc/src/man.tar doc/ + gzip -9 doc/man.tar + +clean:: + rm -f doc/postgres.tar.gz doc/man.tar.gz + +common-binary-predeb-arch:: + # verify that all files are installed; ignore manpages, since + # they are handled by dh_installman + missing=`dh_install --sourcedir=debian/tmp --list-missing --no-act 2>&1 | grep -v man/man`; \ + if [ -n "$$missing" ]; then \ + echo "Not all files are installed:"; \ + echo "$$missing"; \ + exit 1; \ + fi + +common-post-build-arch:: + # generate POT files for translators + find -name nls.mk -exec sh -c "make -C \$$(dirname {}) init-po" \; + +common-post-build-indep:: + # build tutorial stuff + make -C src/tutorial NO_PGXS=1 + +install/postgresql-doc-$(MAJOR_VER):: + install src/tutorial/*.c src/tutorial/*.source src/tutorial/Makefile src/tutorial/README debian/$(cdbs_curpkg)/usr/share/doc/$(cdbs_curpkg)/tutorial + +binary-predeb/postgresql-$(MAJOR_VER):: +ifeq (, $(findstring nocheck, $(DEB_BUILD_OPTIONS))) + # patch away the "don't execute as root" check for the test + # suite; doing it here will ensure that the actual debs have + # the check. + set -e; \ + patch --no-backup-if-mismatch -p1 < debian/disable-root-check.patch; \ + make -C src/test/regress bigcheck || fail=1; \ + patch --no-backup-if-mismatch -Rp1 < debian/disable-root-check.patch; \ + if [ -n "$$fail" ]; then \ + for l in regression.diffs log/initdb.log log/postmaster.log; do \ + if [ -e src/test/regress/$$l ]; then \ + echo "********* $$l *******"; \ + cat src/test/regress/$$l; \ + fi; \ + done; \ + $(TESTSUITE_FAIL_CMD); \ + fi +endif + + # compress manpages + find debian/postgresql-$(MAJOR_VER)/usr/share/postgresql/$(MAJOR_VER)/man -type f -exec gzip -9 '{}' \; + +binary-predeb/postgresql-client-$(MAJOR_VER):: + find debian/postgresql-client-$(MAJOR_VER)/usr/share/postgresql/$(MAJOR_VER)/man -type f -exec gzip -9 '{}' \; + +binary-install/postgresql-plpython-$(MAJOR_VER):: + dh_pycentral -p$(cdbs_curpkg) + dh_python -p$(cdbs_curpkg) usr/lib/postgresql/$(MAJOR_VER)/lib + +# run tests in contrib in temporary test installations, using programs +# from local tree +contrib-check: + set -e; cd contrib; \ + for d in *; do \ + [ -d $$d/sql ] || continue; \ + echo "============== Running tests in $$d"; \ + (cd $$d; \ + if ! ../../src/test/regress/pg_regress --top-builddir=../.. --temp-install=tmp_check --dbname=contrib_regression `cd sql; ls *.sql | sed 's/.sql$$//'`; then \ + cat regression.diffs; \ + fi); \ + done + +# run tests in contrib in temporary test installation, using programs +# from system installation +contrib-installcheck: + # set up temporary db + rm -rf tmp_data + mkdir tmp_data + /usr/lib/postgresql/$(MAJOR_VER)/bin/initdb -D tmp_data + /usr/lib/postgresql/$(MAJOR_VER)/bin/pg_ctl -D tmp_data -l tmp_data/postgres.log -o '-k /tmp' start + # wait until it started up + while !/usr/lib/postgresql/$(MAJOR_VER)/bin/psql -h /tmp -l >/dev/null 2>&1; do sleep 1; done + sleep 1 + while !/usr/lib/postgresql/$(MAJOR_VER)/bin/psql -h /tmp -l >/dev/null 2>&1; do sleep 1; done + # run the tests + -cd contrib; make installcheck + /usr/lib/postgresql/$(MAJOR_VER)/bin/pg_ctl -D tmp_data stop + # find and print the regression diffs + find contrib/ -name regression.diffs -exec cat '{}' \; --- postgresql-8.4-8.4.1.orig/debian/postgresql-doc-8.4.doc-base +++ postgresql-8.4-8.4.1/debian/postgresql-doc-8.4.doc-base @@ -0,0 +1,13 @@ +Document: postgresql-8.4 +Title: PostgreSQL 8.4 Documentation +Author: The PostgreSQL Global Development Group +Abstract: The documentation for the PostgreSQL database management system, + version 8.4. PostgreSQL is a sophisticated Object-Relational DBMS, supporting + almost all SQL constructs, including subselects, transactions, and + user-defined types and functions. +Section: Data Management + +Format: HTML +Index: /usr/share/doc/postgresql-doc-8.4/html/index.html +Files: /usr/share/doc/postgresql-doc-8.4/html/* + --- postgresql-8.4-8.4.1.orig/debian/control +++ postgresql-8.4-8.4.1/debian/control @@ -0,0 +1,292 @@ +Source: postgresql-8.4 +Section: database +Priority: optional +Maintainer: Martin Pitt +Uploaders: Gerfried Fuchs +Standards-Version: 3.8.3 +XS-Python-Version: current +Build-Depends: debhelper (>= 5.0.37.2), cdbs (>= 0.4.43), perl (>= 5.8), + libperl-dev, tcl8.5-dev, libreadline5-dev (>= 4.2), libssl-dev, + zlib1g-dev | libz-dev, libpam0g-dev | libpam-dev, libxml2-dev, libkrb5-dev, + libldap2-dev, libxslt1-dev, libossp-uuid-dev, python-dev, + python-central (>= 0.5), gettext, bzip2, hardening-wrapper, + bison, flex, docbook-utils, openjade, docbook + +Package: libpq-dev +Architecture: any +Section: libdevel +Depends: ${shlibs:Depends}, libpq5 (= ${binary:Version}), libssl-dev, libkrb5-dev, comerr-dev +Conflicts: postgresql-dev (<< 7.5) +Replaces: postgresql-dev +Suggests: postgresql-doc-8.4 +Description: header files for libpq5 (PostgreSQL library) + Header files and static library for compiling C programs to link + with the libpq library in order to communicate with a PostgreSQL + database backend. + . + PostgreSQL is an object-relational SQL database management system. + +Package: libpq5 +Architecture: any +Section: libs +Depends: ${shlibs:Depends} +Description: PostgreSQL C client library + libpq is a C library that enables user programs to communicate with + the PostgreSQL database server. The server can be on another machine + and accessed through TCP/IP. This version of libpq is compatible + with servers from PostgreSQL 8.2 or later. + . + This package contains the run-time library, needed by packages using + libpq. + . + PostgreSQL is an object-relational SQL database management system. + +Package: libecpg6 +Architecture: any +Section: libs +Depends: ${shlibs:Depends} +Description: run-time library for ECPG programs + The libecpg shared library is used by programs built with ECPG + (Embedded PostgreSQL for C). + . + PostgreSQL is an object-relational SQL database management system. + +Package: libecpg-dev +Architecture: any +Section: libdevel +Depends: ${shlibs:Depends}, libpq-dev, libecpg-compat3, libpgtypes3 +Conflicts: postgresql-dev, libecpg3-dev +Description: development files for ECPG (Embedded PostgreSQL for C) + This package contains the necessary files to build ECPG (Embedded + PostgreSQL for C) programs. It includes the development libraries + and the preprocessor program ecpg. + . + PostgreSQL is an object-relational SQL database management system. + . + Install this package if you want to write C programs with SQL statements + embedded in them (rather than run by an external process). + +Package: libecpg-compat3 +Architecture: any +Section: libs +Depends: ${shlibs:Depends} +Description: older version of run-time library for ECPG programs + The libecpg_compat shared library is used by programs built with ecpg. + (Embedded PostgreSQL for C). + . + PostgreSQL is an object-relational SQL database management system. + +Package: libpgtypes3 +Architecture: any +Section: libs +Depends: ${shlibs:Depends} +Description: shared library libpgtypes for PostgreSQL 8.4 + The libpgtypes shared library is used by programs built with ecpg. + (Embedded PostgreSQL for C). + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-8.4 +Architecture: any +Depends: ${shlibs:Depends}, postgresql-client-8.4, postgresql-common (>= 98~), tzdata, ssl-cert, locales +Suggests: oidentd | ident-server +Conflicts: postgresql (<< 7.5) +Description: object-relational SQL database, version 8.4 server + PostgreSQL is a fully featured object-relational database management + system. It supports a large part of the SQL standard and is designed + to be extensible by users in many aspects. Some of the features are: + ACID transactions, foreign keys, views, sequences, subqueries, + triggers, user-defined types and functions, outer joins, multiversion + concurrency control. Graphical user interfaces and bindings for many + programming languages are available as well. + . + This package provides the database server for PostgreSQL 8.4. Servers + for other major release versions can be installed simultaneously and + are coordinated by the postgresql-common package. A package providing + ident-server is needed if you want to authenticate remote connections + with identd. + +Package: postgresql-client-8.4 +Architecture: any +Depends: ${shlibs:Depends}, postgresql-client-common (>= 98~) +Conflicts: postgresql (<< 7.5) +Suggests: postgresql-8.4, postgresql-doc-8.4 +Provides: postgresql-client +Description: front-end programs for PostgreSQL 8.4 + This package contains client and administrative programs for + PostgreSQL: these are the interactive terminal client psql and + programs for creating and removing users and databases. + . + This is the client package for PostgreSQL 8.4. If you install + PostgreSQL 8.4 on a standalone machine, you need the server package + postgresql-8.4, too. On a network, you can install this package on + many client machines, while the server package may be installed on + only one machine. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-server-dev-8.4 +Architecture: any +Section: libdevel +Depends: ${shlibs:Depends}, libpq-dev (>= 8.4~) +Description: development files for PostgreSQL 8.4 server-side programming + Header files for compiling SSI code to link into PostgreSQL's backend; for + example, for C functions to be called from SQL. + . + This package also contains the Makefiles necessary for building add-on + modules of PostgreSQL, which would otherwise have to be built in the + PostgreSQL source-code tree. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-doc-8.4 +Architecture: all +Section: doc +Conflicts: postgresql-doc (<< 7.5) +Description: documentation for the PostgreSQL database management system + This package contains all README files, user manual, and examples for + PostgreSQL 8.4. The manual is in HTML format. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-contrib-8.4 +Architecture: any +Depends: postgresql-8.4, ${shlibs:Depends}, postgresql-common (>= 98~) +Suggests: libdbd-pg-perl +Conflicts: postgresql-contrib (<< 7.5) +Description: additional facilities for PostgreSQL + The PostgreSQL contrib package provides several additional features + for the PostgreSQL database. This version is built to work with the + server package postgresql-8.4. contrib often serves as a testbed for + features before they are adopted into PostgreSQL proper: + . + adminpack - File and log manipulation routines, used by pgAdmin + btree_gist - B-Tree indexing using GiST (Generalised Search Tree) + chkpass - An auto-encrypted password datatype + cube - Multidimensional-cube datatype (GiST indexing example) + dblink - Functions to return results from a remote database + earthdistance - Operator for computing the distance (in miles) between + two points on the earth's surface + fuzzystrmatch - Levenshtein, metaphone, and soundex fuzzy string matching + hstore - Store (key, value) pairs + intagg - Integer aggregator/enumerator + _int - Index support for arrays of int4, using GiST (benchmark + needs the libdbd-pg-perl package) + isn - type extensions for ISBN, ISSN, ISMN, EAN13 product numbers + lo - Large Object maintenance + ltree - Tree-like data structures + oid2name - Maps OIDs to table names + pageinspect - Inspection of database pages + pg_buffercache - Real time queries on the shared buffer cache + pg_freespacemap- Displays the contents of the free space map (FSM) + pg_trgm - Determine the similarity of text based on trigram matching + pg_standby - Create a warm stand-by server + pgbench - TPC-B like benchmark + pgcrypto - Cryptographic functions + pgrowlocks - A function to return row locking information + pgstattuple - Returns the percentage of dead tuples in a table; this + indicates whether a vacuum is required. + seg - Confidence-interval datatype (GiST indexing example) + spi - PostgreSQL Server Programming Interface; 4 examples of + its use: + autoinc - A function for implementing AUTOINCREMENT/ + IDENTITY + insert_username - function for inserting user names + moddatetime - Update modification timestamps + refint - Functions for implementing referential + integrity (foreign keys). Note that this is + now superseded by built-in referential + integrity. + timetravel - Re-implements in user code the time travel + feature that was removed in 6.3. + tablefunc - examples of functions returning tables + uuid-ossp - UUID generation functions + vacuumlo - Remove orphaned large objects + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-plperl-8.4 +Architecture: any +Depends: ${shlibs:Depends}, postgresql-8.4, perl +Description: PL/Perl procedural language for PostgreSQL 8.4 + PL/Perl enables an SQL developer to write procedural language functions + for PostgreSQL 8.4 in Perl. You need this package if you have any + PostgreSQL 8.4 functions that use the languages plperl or plperlu. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-plpython-8.4 +Architecture: any +Depends: ${shlibs:Depends}, postgresql-8.4 +XB-Python-Version: ${python:Versions} +Description: PL/Python procedural language for PostgreSQL 8.4 + PL/Python enables an SQL developer to write procedural language functions + for PostgreSQL 8.4 in Python. You need this package if you have any + PostgreSQL 8.4 functions that use the languages plpython or plpythonu. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-pltcl-8.4 +Architecture: any +Depends: ${shlibs:Depends}, postgresql-8.4 +Description: PL/Tcl procedural language for PostgreSQL 8.4 + PL/Tcl enables an SQL developer to write procedural language functions + for PostgreSQL 8.4 in Tcl. You need this package if you have any + PostgreSQL 8.4 functions that use the languages pltcl or pltclu. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql +Architecture: all +Depends: postgresql-8.4 +Description: object-relational SQL database (supported version) + PostgreSQL is a fully featured object-relational database management + system. It supports a large part of the SQL standard and is designed + to be extensible by users in many aspects. Some of the features are: + ACID transactions, foreign keys, views, sequences, subqueries, + triggers, user-defined types and functions, outer joins, multiversion + concurrency control. Graphical user interfaces and bindings for many + programming languages are available as well. + . + This package always depends on the currently supported PostgreSQL + database server version. + +Package: postgresql-client +Architecture: all +Depends: postgresql-client-8.4 +Description: front-end programs for PostgreSQL (supported version) + This package contains client and administrative programs for + PostgreSQL: these are the interactive terminal client psql and + programs for creating and removing users and databases. + . + This package always depends on the currently supported database + client package for PostgreSQL. If you install PostgreSQL on a + standalone machine, you need the server package postgresql, too. On a + network, you can install this package on many client machines, while + the server package may be installed on only one machine. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-doc +Architecture: all +Section: doc +Depends: postgresql-doc-8.4 +Description: documentation for the PostgreSQL database management system + This package contains all README files, user manual, and examples for + the currently supported PostgreSQL version. The manual is in HTML + format. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-contrib +Architecture: all +Depends: postgresql-contrib-8.4 +Description: additional facilities for PostgreSQL (supported version) + The PostgreSQL contrib package provides several additional features + for the PostgreSQL database. contrib often serves as a testbed for + features before they are adopted into PostgreSQL proper. + . + This package always depends on the currently supported contrib + package for PostgreSQL. + . + PostgreSQL is an object-relational SQL database management system. --- postgresql-8.4-8.4.1.orig/debian/libecpg6.install +++ postgresql-8.4-8.4.1/debian/libecpg6.install @@ -0,0 +1,2 @@ +usr/lib/libecpg.so.6* +/usr/share/locale/*/*/ecpg*.mo --- postgresql-8.4-8.4.1.orig/debian/changelog +++ postgresql-8.4-8.4.1/debian/changelog @@ -0,0 +1,160 @@ +postgresql-8.4 (8.4.1-1~bpo50+1) lenny-backports; urgency=low + + * Security rebuild for lenny-backports to fix CVE-2007-6600 (privilege + escalation). + + -- Gerfried Fuchs Wed, 09 Sep 2009 19:21:27 +0200 + +postgresql-8.4 (8.4.1-1) unstable; urgency=medium + + * Urgency medium due to security fix. + * New upstream security/bug fix release: + - Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside + security-definer functions. This covers a case that was missed in the + previous patch that disallowed "SET ROLE" and "SET SESSION + AUTHORIZATION" inside security-definer functions. [CVE-2007-6600] + - Fix WAL page header initialization at the end of archive recovery. + This could lead to failure to process the WAL in a subsequent archive + recovery. + - Fix "cannot make new WAL entries during recovery" error. + - Fix problem that could make expired rows visible after a crash. + This bug involved a page status bit potentially not being set + correctly after a server crash. + - Make "LOAD" of an already-loaded loadable module into a no-op. + Formerly, "LOAD" would attempt to unload and re-load the module, + but this is unsafe and not all that useful. + - Make window function PARTITION BY and ORDER BY items always be + interpreted as simple expressions. + In 8.4.0 these lists were parsed following the rules used for + top-level GROUP BY and ORDER BY lists. But this was not correct per + the SQL standard, and it led to possible circularity. + - Fix several errors in planning of semi-joins. These led to wrong query + results in some cases where IN or EXISTS was used together with another + join. + - Fix handling of whole-row references to subqueries that are within + an outer join. An example is SELECT COUNT(ss.-) FROM ... LEFT JOIN + (SELECT ...) ss ON .... Here, ss.- would be treated as + ROW(NULL,NULL,...) for null-extended join rows, which is not the same as + a simple NULL. Now it is treated as a simple NULL. + - Fix locale handling with plperl. This bug could cause the server's + locale setting to change when a plperl function is called, leading to + data corruption. + - Fix handling of reloptions to ensure setting one option doesn't + force default values for others. + - Ensure that a "fast shutdown" request will forcibly terminate open + sessions, even if a "smart shutdown" was already in progress. + - Avoid memory leak for array_agg() in GROUP BY queries. + - Treat to_char(..., 'TH') as an uppercase ordinal suffix with + 'HH'/'HH12'. It was previously handled as 'th'. + - Include the fractional part in the result of EXTRACT(second) and + EXTRACT(milliseconds) for time and time with time zone inputs. + This has always worked for floating-point datetime configurations, + but was broken in the integer datetime code. + - Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million + and integer datetimes are in use. + - Improve performance when processing toasted values in index scans. + This is particularly useful for PostGIS. + - Fix a typo that disabled commit_delay. + - Output early-startup messages to "postmaster.log" if the server is + started in silent mode. Previously such error messages were discarded, + leading to difficulty in debugging. + - Remove translated FAQs. They are now on the wiki. The main FAQ was moved + to the wiki some time ago. + - Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is + empty. + - Fix several errors in pg_dump's --binary-upgrade mode. pg_dump + --binary-upgrade is used by pg_migrator. + - Fix "contrib/xml2"'s xslt_process() to properly handle the maximum + number of parameters (twenty). + - Improve robustness of libpq's code to recover from errors during + "COPY FROM STDIN". + - Avoid including conflicting readline and editline header files when + both libraries are installed. + - Work around gcc bug that causes "floating-point exception" instead + of "division by zero" on some platforms. + * debian/control: Bump Standards-Version to 3.8.3 (no changes necessary). + + -- Martin Pitt Sun, 06 Sep 2009 14:11:13 +0200 + +postgresql-8.4 (8.4.0-2) unstable; urgency=low + + * debian/libpq-dev.install: Ship catalog/genbki.h. (Closes: #536139) + * debian/rules: Drop --enable-cassert for final release. + + -- Martin Pitt Sat, 11 Jul 2009 16:59:35 +0200 + +postgresql-8.4 (8.4.0-1) unstable; urgency=low + + * Final 8.4.0 release. Major enhancements: + - Windowing Functions + - Common Table Expressions and Recursive Queries + - Default and variadic parameters for functions + - Parallel Restore + - Column Permissions + - Per-database locale settings + - Improved hash indexes + - Improved join performance for EXISTS and NOT EXISTS queries + - Easier-to-use Warm Standby + - Automatic sizing of the Free Space Map + - Visibility Map (greatly reduces vacuum overhead for slowly-changing + tables) + - Version-aware psql (backslash commands work against older servers) + - Support SSL certificates for user authentication + - Per-function runtime statistics + - Easy editing of functions in psql + - New contrib modules: pg_stat_statements, auto_explain, citext, + btree_gin + Upload to unstable, 8.4 is the new default. + * debian/control: Build the versionless metapackages and have them point to + 8.4. + + -- Martin Pitt Wed, 01 Jul 2009 17:41:41 +0200 + +postgresql-8.4 (8.4~rc1-1) experimental; urgency=low + + * First release candidate of 8.4. + + -- Martin Pitt Mon, 22 Jun 2009 09:17:52 +0200 + +postgresql-8.4 (8.4~beta2-2) experimental; urgency=low + + * Second public beta of 8.4. + * debian/control: Slightly lower the dependencies for postgresql-common to + >= 98~, so that backports also match. + + -- Martin Pitt Tue, 19 May 2009 14:03:37 +0200 + +postgresql-8.4 (8.4~beta1+cvs20090503-1) experimental; urgency=low + + * New upstream snapshot. + + -- Martin Pitt Tue, 05 May 2009 00:58:06 +0200 + +postgresql-8.4 (8.4~beta1-1) experimental; urgency=low + + * First public beta of 8.4. + * debian/*.install: Add new gettext translations. + * debian/control: Bump p-common dependency to >= 98 to ensure support for + 8.4. + * debian/rules: Build with --enable-cassert while in beta. + + -- Martin Pitt Mon, 27 Apr 2009 08:35:30 +0200 + +postgresql-8.4 (8.4~0cvs20090328-1) experimental; urgency=low + + * Package current trunk, which will become 8.4 in time. Packaging branched + from 8.3 packaging trunk. Move from cdbs' tarball.mk to bzr-builddeb. + * Drop obsolete patches: + - 03-gettext-domains.patch: Adopted upstream. + - 04-psql-passwordprompt.patch: Obsoleted by new psql -w option. + - 05-check-rlimits-nofile.patch: Adopted upstream. + * Update remaining patches for new upstream version. + * Add debian/docbook2man-sgmlspl/docbook2man-spec{.pl,_makelinks}: Current + Debian version in docbook-utils is way too old and broken (see #275715, + #271611), locally ship the current ones from upstream, in order to build + manpages. + * debian/rules: Build documentation and manpage tarballs if not present (as + with building from CVS). Add necessary build dependencies docbook-utils, + openjade, and docbook. + + -- Martin Pitt Fri, 20 Mar 2009 12:00:13 +0100 --- postgresql-8.4-8.4.1.orig/debian/postgresql-client-8.4.prerm +++ postgresql-8.4-8.4.1/debian/postgresql-client-8.4.prerm @@ -0,0 +1,10 @@ +#!/bin/sh -e + +#DEBHELPER# + +VERSION=8.4 + +if [ "$1" = remove ]; then + . /usr/share/postgresql-common/maintscripts-functions + remove_client_version $VERSION +fi --- postgresql-8.4-8.4.1.orig/debian/libecpg-dev.manpages +++ postgresql-8.4-8.4.1/debian/libecpg-dev.manpages @@ -0,0 +1 @@ +debian/tmp/usr/share/postgresql/8.4/man/man1/ecpg.1 --- postgresql-8.4-8.4.1.orig/debian/postgresql-contrib-8.4.postinst +++ postgresql-8.4-8.4.1/debian/postgresql-contrib-8.4.postinst @@ -0,0 +1,11 @@ +#!/bin/sh -e + +VERSION=8.4 + +. /usr/share/postgresql-common/maintscripts-functions + +if [ "$1" = configure ]; then + configure_contrib_version $VERSION "$2" +fi + +#DEBHELPER# --- postgresql-8.4-8.4.1.orig/debian/postgresql-plpython-8.4.install +++ postgresql-8.4-8.4.1/debian/postgresql-plpython-8.4.install @@ -0,0 +1,2 @@ +usr/lib/postgresql/8.4/lib/plpython.so +/usr/share/locale/*/*/plpython-*.mo --- postgresql-8.4-8.4.1.orig/debian/watch +++ postgresql-8.4-8.4.1/debian/watch @@ -0,0 +1,2 @@ +version=3 +http://www.postgresql.org/ftp/source/ /ftp/source/v(8\.4.*)/ --- postgresql-8.4-8.4.1.orig/debian/postgresql-contrib-8.4.prerm +++ postgresql-8.4-8.4.1/debian/postgresql-contrib-8.4.prerm @@ -0,0 +1,10 @@ +#!/bin/sh -e + +#DEBHELPER# + +VERSION=8.4 + +if [ "$1" = remove ]; then + . /usr/share/postgresql-common/maintscripts-functions + remove_contrib_version $VERSION +fi --- postgresql-8.4-8.4.1.orig/debian/postgresql-client-8.4.install +++ postgresql-8.4-8.4.1/debian/postgresql-client-8.4.install @@ -0,0 +1,31 @@ +usr/lib/postgresql/8.4/bin/clusterdb +usr/lib/postgresql/8.4/bin/pg_dumpall +usr/lib/postgresql/8.4/bin/pg_dump +usr/lib/postgresql/8.4/bin/createdb +usr/lib/postgresql/8.4/bin/createlang +usr/lib/postgresql/8.4/bin/createuser +usr/lib/postgresql/8.4/bin/dropdb +usr/lib/postgresql/8.4/bin/droplang +usr/lib/postgresql/8.4/bin/dropuser +usr/lib/postgresql/8.4/bin/reindexdb +usr/lib/postgresql/8.4/bin/pg_restore +usr/lib/postgresql/8.4/bin/psql +usr/lib/postgresql/8.4/bin/vacuumdb +usr/share/postgresql/8.4/man/man1/pg_restore.1 +usr/share/postgresql/8.4/man/man1/psql.1 +usr/share/postgresql/8.4/man/man1/vacuumdb.1 +usr/share/postgresql/8.4/man/man1/clusterdb.1 +usr/share/postgresql/8.4/man/man1/pg_dump.1 +usr/share/postgresql/8.4/man/man1/pg_dumpall.1 +usr/share/postgresql/8.4/man/man1/createdb.1 +usr/share/postgresql/8.4/man/man1/createlang.1 +usr/share/postgresql/8.4/man/man1/createuser.1 +usr/share/postgresql/8.4/man/man1/dropdb.1 +usr/share/postgresql/8.4/man/man1/droplang.1 +usr/share/postgresql/8.4/man/man1/dropuser.1 +usr/share/postgresql/8.4/man/man1/reindexdb.1 +usr/share/postgresql/8.4/man/man7/*7 +usr/share/postgresql/8.4/psqlrc.sample +usr/share/locale/*/LC_MESSAGES/pg_dump-8.4.mo +usr/share/locale/*/LC_MESSAGES/psql-8.4.mo +usr/share/locale/*/LC_MESSAGES/pgscripts-8.4.mo --- postgresql-8.4-8.4.1.orig/debian/disable-root-check.patch +++ postgresql-8.4-8.4.1/debian/disable-root-check.patch @@ -0,0 +1,36 @@ +diff -Nur postgresql-8.4/build-tree/postgresql-8.4beta1/src/backend/main/main.c postgresql-8.4.new/build-tree/postgresql-8.4beta1/src/backend/main/main.c +--- postgresql-8.4beta1/src/backend/main/main.c 2006-09-26 00:50:41.000000000 +0200 ++++ postgresql-8.4beta1/src/backend/main/main.c 2006-09-26 00:51:43.000000000 +0200 +@@ -326,7 +326,7 @@ + check_root(const char *progname) + { + #ifndef WIN32 +- if (geteuid() == 0) ++ if (0 && geteuid() == 0) + { + write_stderr("\"root\" execution of the PostgreSQL server is not permitted.\n" + "The server must be started under an unprivileged user ID to prevent\n" +diff -Nur postgresql-8.4/build-tree/postgresql-8.4beta1/src/bin/initdb/initdb.c postgresql-8.4.new/build-tree/postgresql-8.4beta1/src/bin/initdb/initdb.c +--- postgresql-8.4beta1/src/bin/initdb/initdb.c 2006-09-26 00:50:41.000000000 +0200 ++++ postgresql-8.4beta1/src/bin/initdb/initdb.c 2006-09-26 00:52:09.000000000 +0200 +@@ -636,7 +636,7 @@ + + pw = getpwuid(geteuid()); + +- if (geteuid() == 0) /* 0 is root's uid */ ++ if (0 && geteuid() == 0) /* 0 is root's uid */ + { + fprintf(stderr, + _("%s: cannot be run as root\n" +diff -Nur postgresql-8.4/build-tree/postgresql-8.4beta1/src/bin/pg_ctl/pg_ctl.c postgresql-8.4.new/build-tree/postgresql-8.4beta1/src/bin/pg_ctl/pg_ctl.c +--- postgresql-8.4beta1/src/bin/pg_ctl/pg_ctl.c 2006-09-26 00:50:41.000000000 +0200 ++++ postgresql-8.4beta1/src/bin/pg_ctl/pg_ctl.c 2006-09-26 00:52:23.000000000 +0200 +@@ -1517,7 +1517,7 @@ + * Disallow running as root, to forestall any possible security holes. + */ + #ifndef WIN32 +- if (geteuid() == 0) ++ if (0 && geteuid() == 0) + { + write_stderr(_("%s: cannot be run as root\n" + "Please log in (using, e.g., \"su\") as the " --- postgresql-8.4-8.4.1.orig/debian/libpq5.install +++ postgresql-8.4-8.4.1/debian/libpq5.install @@ -0,0 +1,2 @@ +usr/lib/libpq.so.5* +usr/share/locale/*/LC_MESSAGES/libpq*.mo --- postgresql-8.4-8.4.1.orig/debian/postgresql-doc-8.4.dirs +++ postgresql-8.4-8.4.1/debian/postgresql-doc-8.4.dirs @@ -0,0 +1 @@ +/usr/share/doc/postgresql-doc-8.4/tutorial --- postgresql-8.4-8.4.1.orig/debian/postgresql-contrib-8.4.install +++ postgresql-8.4-8.4.1/debian/postgresql-contrib-8.4.install @@ -0,0 +1,42 @@ +usr/share/doc/postgresql/contrib/* usr/share/doc/postgresql-contrib-8.4 +usr/share/postgresql/8.4/contrib/* +usr/lib/postgresql/8.4/bin/oid2name +usr/lib/postgresql/8.4/bin/pgbench +usr/lib/postgresql/8.4/bin/vacuumlo +usr/lib/postgresql/8.4/bin/pg_standby +usr/lib/postgresql/8.4/lib/_int.so +usr/lib/postgresql/8.4/lib/autoinc.so +usr/lib/postgresql/8.4/lib/btree_gist.so +usr/lib/postgresql/8.4/lib/chkpass.so +usr/lib/postgresql/8.4/lib/cube.so +usr/lib/postgresql/8.4/lib/dblink.so +usr/lib/postgresql/8.4/lib/earthdistance.so +usr/lib/postgresql/8.4/lib/fuzzystrmatch.so +usr/lib/postgresql/8.4/lib/insert_username.so +usr/lib/postgresql/8.4/lib/lo.so +usr/lib/postgresql/8.4/lib/ltree.so +usr/lib/postgresql/8.4/lib/moddatetime.so +usr/lib/postgresql/8.4/lib/pageinspect.so +usr/lib/postgresql/8.4/lib/pg_trgm.so +usr/lib/postgresql/8.4/lib/pgcrypto.so +usr/lib/postgresql/8.4/lib/pgstattuple.so +usr/lib/postgresql/8.4/lib/refint.so +usr/lib/postgresql/8.4/lib/seg.so +usr/lib/postgresql/8.4/lib/tablefunc.so +usr/lib/postgresql/8.4/lib/timetravel.so +usr/lib/postgresql/8.4/lib/pgxml.so +usr/lib/postgresql/8.4/lib/pg_buffercache.so +usr/lib/postgresql/8.4/lib/adminpack.so +usr/lib/postgresql/8.4/lib/sslinfo.so +usr/lib/postgresql/8.4/lib/isn.so +usr/lib/postgresql/8.4/lib/hstore.so +usr/lib/postgresql/8.4/lib/pgrowlocks.so +usr/lib/postgresql/8.4/lib/pg_freespacemap.so +usr/lib/postgresql/8.4/lib/uuid-ossp.so +usr/lib/postgresql/8.4/lib/test_parser.so +usr/lib/postgresql/8.4/lib/dict_int.so +usr/lib/postgresql/8.4/lib/dict_xsyn.so +usr/lib/postgresql/8.4/lib/auto_explain.so +usr/lib/postgresql/8.4/lib/pg_stat_statements.so +usr/lib/postgresql/8.4/lib/citext.so +usr/lib/postgresql/8.4/lib/btree_gin.so --- postgresql-8.4-8.4.1.orig/debian/postgresql-8.4.links +++ postgresql-8.4-8.4.1/debian/postgresql-8.4.links @@ -0,0 +1 @@ +/usr/share/doc/postgresql-common/README.Debian.gz /usr/share/doc/postgresql-8.4/README.Debian.gz --- postgresql-8.4-8.4.1.orig/debian/libpq-dev.install +++ postgresql-8.4-8.4.1/debian/libpq-dev.install @@ -0,0 +1,19 @@ +usr/include/postgresql/internal/* +usr/include/postgresql/libpq-fe.h +usr/include/postgresql/libpq-events.h +usr/include/postgresql/libpq/libpq-fs.h +usr/include/postgresql/pg_config*.h +usr/include/postgresql/postgres_ext.h +usr/include/postgresql/8.4/server/catalog/pg_type.h /usr/include/postgresql/catalog +usr/include/postgresql/8.4/server/catalog/genbki.h /usr/include/postgresql/catalog +usr/include/postgresql/8.4/server/nodes/nodes.h /usr/include/postgresql/nodes +usr/include/postgresql/8.4/server/utils/{elog,errcodes,palloc}.h /usr/include/postgresql/utils +usr/include/postgresql/8.4/server/{c,pg_config,pg_config_manual,pg_config_os,port,pg_trace}.h /usr/include/postgresql/ +usr/include/postgresql/8.4/server/postgres{,_fe,_ext}.h /usr/include/postgresql/ +usr/include/postgresql/8.4/server/mb/pg_wchar.h /usr/include/postgresql/mb +usr/lib/libpgport.a +usr/lib/libpq.a +usr/lib/libpq.so +usr/lib/postgresql/8.4/bin/pg_config usr/bin +usr/share/postgresql/8.4/man/man1/pg_config.1 +usr/share/locale/*/LC_MESSAGES/pg_config-8.4.mo --- postgresql-8.4-8.4.1.orig/debian/copyright +++ postgresql-8.4-8.4.1/debian/copyright @@ -0,0 +1,110 @@ +This package was debianized by Martin Pitt . + +PostgreSQL was downloaded from ftp://ftp.postgresql.org/mirror/postgresql/src/ + +Please note that there are many other mirrors, listed on +http://www.postgresql.org/mirrors-ftp.html. + +Copyright. The following copyright applies to the entire distribution: + + PostgreSQL Data Base Management System + (formerly known as Postgres, then as Postgres95). + + Portions Copyright (c) 1996-2003, The PostgreSQL Global Development Group + + Portions Copyright (c) 1994, The Regents of the University of California + + Permission to use, copy, modify, and distribute this software and its + documentation for any purpose, without fee, and without a written agreement + is hereby granted, provided that the above copyright notice and this + paragraph and the following two paragraphs appear in all copies. + + IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR + DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING + LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS + DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE + POSSIBILITY OF SUCH DAMAGE. + + THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, + INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY + AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS + ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO + PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. + + +The following copyright applies to the regex code in the backend +(src/backend/regex): + + Copyright (c) 1998, 1999 Henry Spencer. All rights reserved. + + Development of this software was funded, in part, by Cray Research Inc., + UUNET Communications Services Inc., Sun Microsystems Inc., and Scriptics + Corporation, none of whom are responsible for the results. The author + thanks all of them. + + Redistribution and use in source and binary forms -- with or without + modification -- are permitted for any purpose, provided that + redistributions in source form retain this entire copyright notice and + indicate the origin and nature of any modifications. + + I'd appreciate being given credit for this package in the documentation + of software which uses it, but that is not a requirement. + + THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, + INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY + AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL + HENRY SPENCER BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, + EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, + PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; + OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, + WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR + OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF + ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. + +PostgreSQL adopted the code out of Tcl 8.4.1. Portions of regc_locale.c +and re_syntax.n were developed by Tcl developers other than Henry; these +files bear the Tcl copyright and license notice: + + This software is copyrighted by the Regents of the University of + California, Sun Microsystems, Inc., Scriptics Corporation, ActiveState + Corporation and other parties. The following terms apply to all files + associated with the software unless explicitly disclaimed in + individual files. + + The authors hereby grant permission to use, copy, modify, distribute, + and license this software and its documentation for any purpose, provided + that existing copyright notices are retained in all copies and that this + notice is included verbatim in any distributions. No written agreement, + license, or royalty fee is required for any of the authorized uses. + Modifications to this software may be copyrighted by their authors + and need not follow the licensing terms described here, provided that + the new terms are clearly indicated on the first page of each file where + they apply. + + IN NO EVENT SHALL THE AUTHORS OR DISTRIBUTORS BE LIABLE TO ANY PARTY + FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES + ARISING OUT OF THE USE OF THIS SOFTWARE, ITS DOCUMENTATION, OR ANY + DERIVATIVES THEREOF, EVEN IF THE AUTHORS HAVE BEEN ADVISED OF THE + POSSIBILITY OF SUCH DAMAGE. + + THE AUTHORS AND DISTRIBUTORS SPECIFICALLY DISCLAIM ANY WARRANTIES, + INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, + FITNESS FOR A PARTICULAR PURPOSE, AND NON-INFRINGEMENT. THIS SOFTWARE + IS PROVIDED ON AN "AS IS" BASIS, AND THE AUTHORS AND DISTRIBUTORS HAVE + NO OBLIGATION TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR + MODIFICATIONS. + + GOVERNMENT USE: If you are acquiring this software on behalf of the + U.S. government, the Government shall have only "Restricted Rights" + in the software and related documentation as defined in the Federal + Acquisition Regulations (FARs) in Clause 52.227.19 (c) (2). If you + are acquiring the software on behalf of the Department of Defense, the + software shall be classified as "Commercial Computer Software" and the + Government shall have only "Restricted Rights" as defined in Clause + 252.227-7013 (c) (1) of DFARs. Notwithstanding the foregoing, the + authors grant the U.S. Government and others acting in its behalf + permission to use and distribute the software in accordance with the + terms specified in this license. + +Subsequent modifications to the code by the PostgreSQL project follow +the same license terms as the rest of PostgreSQL. --- postgresql-8.4-8.4.1.orig/debian/postgresql-8.4.postinst +++ postgresql-8.4-8.4.1/debian/postgresql-8.4.postinst @@ -0,0 +1,24 @@ +#!/bin/sh -e + +VERSION=8.4 + + +if [ "$1" = configure ]; then + # fix init script stop priority on upgrades + if dpkg --compare-versions "$2" le-nl "8.4~rc2-1"; then + echo "Fixing init script priorities..." + for l in 0 1 6; do + old=/etc/rc$l.d/K19postgresql-8.4 + new=/etc/rc$l.d/K21postgresql-8.4 + if [ -e $old ] && ! [ -e $new ]; then + mv $old $new + fi + done + fi + + . /usr/share/postgresql-common/maintscripts-functions + + configure_version $VERSION "$2" +fi + +#DEBHELPER# --- postgresql-8.4-8.4.1.orig/debian/postgresql-doc-8.4.install +++ postgresql-8.4-8.4.1/debian/postgresql-doc-8.4.install @@ -0,0 +1 @@ +usr/share/doc/postgresql/html usr/share/doc/postgresql-doc-8.4/ --- postgresql-8.4-8.4.1.orig/debian/libecpg-dev.install +++ postgresql-8.4-8.4.1/debian/libecpg-dev.install @@ -0,0 +1,12 @@ +usr/include/postgresql/ecpg*.h +usr/include/postgresql/informix/* +usr/include/postgresql/pgtypes_*.h +usr/include/postgresql/sql3types.h +usr/include/postgresql/sqlca.h +usr/lib/postgresql/8.4/bin/ecpg usr/bin +usr/lib/libecpg.so +usr/lib/libecpg_compat.so +usr/lib/libpgtypes.so +usr/lib/libecpg.a +usr/lib/libecpg_compat.a +usr/lib/libpgtypes.a --- postgresql-8.4-8.4.1.orig/debian/pycompat +++ postgresql-8.4-8.4.1/debian/pycompat @@ -0,0 +1 @@ +2 --- postgresql-8.4-8.4.1.orig/debian/compat +++ postgresql-8.4-8.4.1/debian/compat @@ -0,0 +1 @@ +5 --- postgresql-8.4-8.4.1.orig/debian/postgresql-8.4.install +++ postgresql-8.4-8.4.1/debian/postgresql-8.4.install @@ -0,0 +1,30 @@ +usr/lib/postgresql/8.4/bin/initdb +usr/lib/postgresql/8.4/bin/pg_controldata +usr/lib/postgresql/8.4/bin/pg_ctl +usr/lib/postgresql/8.4/bin/pg_resetxlog +usr/lib/postgresql/8.4/bin/postgres +usr/lib/postgresql/8.4/bin/postmaster +usr/lib/postgresql/8.4/lib/*_and_*.so +usr/lib/postgresql/8.4/lib/plpgsql.so +usr/lib/postgresql/8.4/lib/dict_snowball.so +usr/lib/postgresql/8.4/lib/tsearch2.so +usr/share/locale/*/LC_MESSAGES/initdb-8.4.mo +usr/share/locale/*/LC_MESSAGES/pg_controldata-8.4.mo +usr/share/locale/*/LC_MESSAGES/pg_ctl-8.4.mo +usr/share/locale/*/LC_MESSAGES/pg_resetxlog-8.4.mo +usr/share/locale/*/LC_MESSAGES/postgres-8.4.mo +usr/share/locale/*/LC_MESSAGES/plpgsql-8.4.mo +usr/share/postgresql/8.4/man/man1/initdb.1 +usr/share/postgresql/8.4/man/man1/pg_controldata.1 +usr/share/postgresql/8.4/man/man1/pg_ctl.1 +usr/share/postgresql/8.4/man/man1/pg_resetxlog.1 +usr/share/postgresql/8.4/man/man1/postgres.1 +usr/share/postgresql/8.4/man/man1/postmaster.1 +usr/share/postgresql/8.4/timezonesets/* +usr/share/postgresql/8.4/tsearch_data +usr/share/postgresql/8.4/*.sql +usr/share/postgresql/8.4/*.conf.sample +usr/share/postgresql/8.4/postgres.bki +usr/share/postgresql/8.4/postgres.description +usr/share/postgresql/8.4/postgres.shdescription +usr/share/postgresql/8.4/sql_features.txt --- postgresql-8.4-8.4.1.orig/debian/postgresql-client-8.4.postinst +++ postgresql-8.4-8.4.1/debian/postgresql-client-8.4.postinst @@ -0,0 +1,11 @@ +#!/bin/sh -e + +VERSION=8.4 + +. /usr/share/postgresql-common/maintscripts-functions + +if [ "$1" = configure ]; then + configure_client_version $VERSION "$2" +fi + +#DEBHELPER# --- postgresql-8.4-8.4.1.orig/debian/postgresql-pltcl-8.4.install +++ postgresql-8.4-8.4.1/debian/postgresql-pltcl-8.4.install @@ -0,0 +1,4 @@ +usr/lib/postgresql/8.4/lib/pltcl.so +usr/lib/postgresql/8.4/bin/pltcl_* +usr/share/postgresql/8.4/unknown.pltcl +/usr/share/locale/*/*/pltcl-*.mo --- postgresql-8.4-8.4.1.orig/debian/libpgtypes3.install +++ postgresql-8.4-8.4.1/debian/libpgtypes3.install @@ -0,0 +1 @@ +usr/lib/libpgtypes.so.3* --- postgresql-8.4-8.4.1.orig/debian/postgresql-plperl-8.4.install +++ postgresql-8.4-8.4.1/debian/postgresql-plperl-8.4.install @@ -0,0 +1,2 @@ +usr/lib/postgresql/8.4/lib/plperl.so +/usr/share/locale/*/*/plperl-*.mo --- postgresql-8.4-8.4.1.orig/debian/postgresql-8.4.prerm +++ postgresql-8.4-8.4.1/debian/postgresql-8.4.prerm @@ -0,0 +1,11 @@ +#!/bin/sh -e + +VERSION=8.4 + +#DEBHELPER# + +if [ "$1" = remove ]; then + . /usr/share/postgresql-common/maintscripts-functions + remove_version $VERSION +fi + --- postgresql-8.4-8.4.1.orig/debian/postgresql-8.4.postrm +++ postgresql-8.4-8.4.1/debian/postgresql-8.4.postrm @@ -0,0 +1,60 @@ +#!/bin/sh -e + +#DEBHELPER# + +VERSION=8.4 + +clean_dir() { + if [ -d "$1" ] && [ ! -L "$1" ]; then + rmdir "$1" >/dev/null 2>/dev/null || true + fi +} + +drop_cluster() { + # if we still have the postgresql-common package, use it to also shutdown + # server, etc.; otherwise just remove the directories + if [ -x /usr/bin/pg_dropcluster ]; then + pg_dropcluster --stop-server $VERSION "$1" + else + # remove data directory + PGDATALINK="/etc/postgresql/$VERSION/$1/pgdata" + if [ -e "$PGDATALINK" ]; then + rm -rf $(readlink -f "$PGDATALINK") "$PGDATALINK" + else + rm -rf "/var/lib/postgresql/$VERSION/$1/" + fi + + # remove log file, including rotated ones + LOGLINK="/etc/postgresql/$VERSION/$1/log" + if [ -e "$LOGLINK" ]; then + LOG=$(readlink -f "$LOGLINK") + rm -f $LOG* "$LOGLINK" + else + rm -f /var/log/postgresql/postgresql-$VERSION-"$1".log* + fi + + # remove conffiles + for f in pg_hba.conf pg_ident.conf postgresql.conf start.conf environment; do + rm -f /etc/postgresql/$VERSION/"$1"/$f + done + + clean_dir /etc/postgresql/$VERSION/"$1" + fi +} + +if [ "$1" = purge ]; then + [ -d "/etc/postgresql/$VERSION" ] || exit 0 + if [ "$(ls /etc/postgresql/$VERSION)" ]; then + for c in /etc/postgresql/$VERSION/*; do + [ -e "$c/postgresql.conf" ] || continue + cluster=$(basename "$c") + echo "Dropping cluster $cluster..." + drop_cluster "$cluster" + done + fi + + clean_dir /etc/postgresql/$VERSION + clean_dir /etc/postgresql + clean_dir /var/lib/postgresql/$VERSION + clean_dir /var/lib/postgresql +fi --- postgresql-8.4-8.4.1.orig/debian/libecpg-compat3.install +++ postgresql-8.4-8.4.1/debian/libecpg-compat3.install @@ -0,0 +1 @@ +usr/lib/libecpg_compat.so.3* --- postgresql-8.4-8.4.1.orig/debian/postgresql-server-dev-8.4.install +++ postgresql-8.4-8.4.1/debian/postgresql-server-dev-8.4.install @@ -0,0 +1,3 @@ +usr/include/postgresql/8.4/* +usr/lib/postgresql/8.4/lib/pgxs/* +usr/lib/postgresql/8.4/bin/pg_config --- postgresql-8.4-8.4.1.orig/debian/libpq-dev.manpages +++ postgresql-8.4-8.4.1/debian/libpq-dev.manpages @@ -0,0 +1 @@ +debian/tmp/usr/share/postgresql/8.4/man/man1/pg_config.1 --- postgresql-8.4-8.4.1.orig/debian/postgresql-8.4.init +++ postgresql-8.4-8.4.1/debian/postgresql-8.4.init @@ -0,0 +1,46 @@ +#!/bin/sh -e + +### BEGIN INIT INFO +# Provides: postgresql postgresql-8.4 +# Required-Start: $local_fs $remote_fs $network $time +# Required-Stop: $local_fs $remote_fs $network $time +# Should-Start: $syslog +# Should-Stop: $syslog +# Default-Start: 2 3 4 5 +# Default-Stop: 0 1 6 +# Short-Description: PostgreSQL 8.4 RDBMS server +### END INIT INFO + +# Setting environment variables for the postmaster here does not work; please +# set them in /etc/postgresql/8.4//environment instead. + +[ -r /usr/share/postgresql-common/init.d-functions ] || exit 0 + +. /usr/share/postgresql-common/init.d-functions + +VERSION=8.4 + +case "$1" in + start) + start $VERSION + ;; + stop) + stop "$VERSION" + ;; + restart) + restart "$VERSION" + ;; + force-reload | reload) + reload $VERSION + ;; + status) + status $VERSION + ;; + *) + echo "Usage: $0 {start|stop|restart|reload|force-reload|status|autovac-start|autovac-stop|autovac-restart}" + exit 1 + ;; +esac + +exit 0 + --- postgresql-8.4-8.4.1.orig/debian/libpq5.shlibs +++ postgresql-8.4-8.4.1/debian/libpq5.shlibs @@ -0,0 +1 @@ +libpq 5 libpq5 (>= 8.4~0cvs20090328) --- postgresql-8.4-8.4.1.orig/debian/patches/11-pg_regress-socketpath.patch +++ postgresql-8.4-8.4.1/debian/patches/11-pg_regress-socketpath.patch @@ -0,0 +1,42 @@ +diff -Nur -x '*.orig' -x '*~' postgresql-8.4-8.4~0cvs20090328/src/test/regress/pg_regress.c postgresql-8.4-8.4~0cvs20090328.new/src/test/regress/pg_regress.c +--- postgresql-8.4-8.4~0cvs20090328/src/test/regress/pg_regress.c 2009-03-28 23:04:14.000000000 +0100 ++++ postgresql-8.4-8.4~0cvs20090328.new/src/test/regress/pg_regress.c 2009-03-28 23:32:54.660811088 +0100 +@@ -888,7 +888,7 @@ + + /* And now we can build and execute the shell command */ + snprintf(psql_cmd, sizeof(psql_cmd), +- SYSTEMQUOTE "\"%s%spsql\" -X -c \"%s\" \"%s\"" SYSTEMQUOTE, ++ SYSTEMQUOTE "\"%s%spsql\" -h /tmp -X -c \"%s\" \"%s\"" SYSTEMQUOTE, + psqldir ? psqldir : "", + psqldir ? "/" : "", + query_escaped, +@@ -2122,7 +2122,7 @@ + * Check if there is a postmaster running already. + */ + snprintf(buf2, sizeof(buf2), +- SYSTEMQUOTE "\"%s/psql\" -X postgres <%s 2>%s" SYSTEMQUOTE, ++ SYSTEMQUOTE "\"%s/psql\" -h /tmp -X postgres <%s 2>%s" SYSTEMQUOTE, + bindir, DEVNULL, DEVNULL); + + for (i = 0; i < 16; i++) +@@ -2154,7 +2154,7 @@ + */ + header(_("starting postmaster")); + snprintf(buf, sizeof(buf), +- SYSTEMQUOTE "\"%s/postgres\" -D \"%s/data\" -F%s -c \"listen_addresses=%s\" > \"%s/log/postmaster.log\" 2>&1" SYSTEMQUOTE, ++ SYSTEMQUOTE "\"%s/postgres\" -D \"%s/data\" -k /tmp -F%s -c \"listen_addresses=%s\" > \"%s/log/postmaster.log\" 2>&1" SYSTEMQUOTE, + bindir, temp_install, + debug ? " -d 5" : "", + hostname ? hostname : "", +diff -Nur -x '*.orig' -x '*~' postgresql-8.4-8.4~0cvs20090328/src/test/regress/pg_regress_main.c postgresql-8.4-8.4~0cvs20090328.new/src/test/regress/pg_regress_main.c +--- postgresql-8.4-8.4~0cvs20090328/src/test/regress/pg_regress_main.c 2009-03-28 23:04:14.000000000 +0100 ++++ postgresql-8.4-8.4~0cvs20090328.new/src/test/regress/pg_regress_main.c 2009-03-28 23:31:22.307182553 +0100 +@@ -59,7 +59,7 @@ + add_stringlist_item(expectfiles, expectfile); + + snprintf(psql_cmd, sizeof(psql_cmd), +- SYSTEMQUOTE "\"%s%spsql\" -X -a -q -d \"%s\" < \"%s\" > \"%s\" 2>&1" SYSTEMQUOTE, ++ SYSTEMQUOTE "\"%s%spsql\" -h /tmp -X -a -q -d \"%s\" < \"%s\" > \"%s\" 2>&1" SYSTEMQUOTE, + psqldir ? psqldir : "", + psqldir ? "/" : "", + dblist->str, --- postgresql-8.4-8.4.1.orig/debian/patches/12-psql-sensible-editor.patch +++ postgresql-8.4-8.4.1/debian/patches/12-psql-sensible-editor.patch @@ -0,0 +1,11 @@ +--- postgresql-8.3beta3/src/bin/psql/settings.h 2007-01-05 23:19:49.000000000 +0100 ++++ postgresql-8.3beta3/src/bin/psql/settings.h 2007-11-21 17:10:38.000000000 +0100 +@@ -19,7 +19,7 @@ + #if defined(WIN32) || defined(__CYGWIN__) + #define DEFAULT_EDITOR "notepad.exe" + #else +-#define DEFAULT_EDITOR "vi" ++#define DEFAULT_EDITOR "sensible-editor" + #endif + + #define DEFAULT_PROMPT1 "%/%R%# " --- postgresql-8.4-8.4.1.orig/debian/patches/01-build-contrib.patch +++ postgresql-8.4-8.4.1/debian/patches/01-build-contrib.patch @@ -0,0 +1,25 @@ +diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta1/GNUmakefile.in postgresql-8.2.new/build-tree/postgresql-8.2beta1/GNUmakefile.in +--- postgresql-8.2beta1/GNUmakefile.in 2006-08-18 21:58:05.000000000 +0200 ++++ postgresql-8.2beta1/GNUmakefile.in 2006-09-25 19:15:34.000000000 +0200 +@@ -12,18 +14,21 @@ + $(MAKE) -C doc all + $(MAKE) -C src all + $(MAKE) -C config all ++ $(MAKE) -C contrib all + @echo "All of PostgreSQL successfully made. Ready to install." + + install: + $(MAKE) -C doc $@ + $(MAKE) -C src $@ + $(MAKE) -C config $@ ++ $(MAKE) -C contrib $@ + @echo "PostgreSQL installation complete." + + installdirs uninstall: + $(MAKE) -C doc $@ + $(MAKE) -C src $@ + $(MAKE) -C config $@ ++ $(MAKE) -C contrib $@ + + distprep: + $(MAKE) -C doc $@ --- postgresql-8.4-8.4.1.orig/debian/patches/07-relax-sslkey-permscheck.patch +++ postgresql-8.4-8.4.1/debian/patches/07-relax-sslkey-permscheck.patch @@ -0,0 +1,21 @@ +diff -Nur -x '*.orig' -x '*~' postgresql-8.4-8.4~rc1/src/backend/libpq/be-secure.c postgresql-8.4-8.4~rc1.new/src/backend/libpq/be-secure.c +--- postgresql-8.4-8.4~rc1/src/backend/libpq/be-secure.c 2009-06-11 16:48:58.000000000 +0200 ++++ postgresql-8.4-8.4~rc1.new/src/backend/libpq/be-secure.c 2009-06-22 07:49:45.873269466 +0200 +@@ -751,12 +751,15 @@ + * directory permission check in postmaster.c) + */ + #if !defined(WIN32) && !defined(__CYGWIN__) +- if (!S_ISREG(buf.st_mode) || buf.st_mode & (S_IRWXG | S_IRWXO)) ++ if (!S_ISREG(buf.st_mode) || (buf.st_mode & (S_IWGRP | S_IRWXO)) || ++ (buf.st_uid != geteuid()) && buf.st_uid != 0) + ereport(FATAL, + (errcode(ERRCODE_CONFIG_FILE_ERROR), + errmsg("private key file \"%s\" has group or world access", + SERVER_PRIVATE_KEY_FILE), +- errdetail("Permissions should be u=rw (0600) or less."))); ++ errdetail("File must be owned by the \ ++database user or root, must have no write permission for \"group\", and must \ ++have no permissions for \"other\"."))); + #endif + + if (SSL_CTX_use_PrivateKey_file(SSL_context, --- postgresql-8.4-8.4.1.orig/debian/patches/09-server-includedir.patch +++ postgresql-8.4-8.4.1/debian/patches/09-server-includedir.patch @@ -0,0 +1,12 @@ +diff -ruN postgresql-8.2.0-old/src/Makefile.global.in postgresql-8.2.0/src/Makefile.global.in +--- postgresql-8.2.0-old/src/Makefile.global.in 2005-11-05 18:54:55.000000000 -0500 ++++ postgresql-8.2.0/src/Makefile.global.in 2005-11-05 18:55:59.000000000 -0500 +@@ -133,7 +133,7 @@ + + # These derived path variables aren't separately configurable. + +-includedir_server = $(pkgincludedir)/server ++includedir_server = $(pkgincludedir)/8.4/server + includedir_internal = $(pkgincludedir)/internal + pgxsdir = $(pkglibdir)/pgxs + --- postgresql-8.4-8.4.1.orig/debian/patches/02-pager.patch +++ postgresql-8.4-8.4.1/debian/patches/02-pager.patch @@ -0,0 +1,12 @@ +diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta1/src/bin/psql/print.h postgresql-8.2.new/build-tree/postgresql-8.2beta1/src/bin/psql/print.h +--- postgresql-8.2beta1/src/bin/psql/print.h 2006-08-30 00:25:07.000000000 +0200 ++++ postgresql-8.2beta1/src/bin/psql/print.h 2006-09-25 19:18:54.000000000 +0200 +@@ -89,7 +89,7 @@ + void setDecimalLocale(void); + + #ifndef __CYGWIN__ +-#define DEFAULT_PAGER "more" ++#define DEFAULT_PAGER "/usr/bin/pager" + #else + #define DEFAULT_PAGER "less" + #endif --- postgresql-8.4-8.4.1.orig/debian/patches/10-tutorial-README.patch +++ postgresql-8.4-8.4.1/debian/patches/10-tutorial-README.patch @@ -0,0 +1,13 @@ +diff -ruN postgresql-8.2.3-old/src/tutorial/README postgresql-8.2.3/src/tutorial/README +--- postgresql-8.2.3-old/src/tutorial/README 2001-10-26 22:45:33.000000000 +0200 ++++ postgresql-8.2.3/src/tutorial/README 2006-04-10 22:17:29.000000000 +0200 +@@ -1,8 +1,7 @@ + This directory contains SQL tutorial scripts. To look at them, first do a + % make + to compile all the scripts and C files for the user-defined functions +-and types. (make needs to be GNU make --- it may be named something +-different on your system, often gmake) ++and types. This requires postgresql-server-dev-8.4 to be installed. + + Then, run psql with the -s (single-step) flag: + % psql -s --- postgresql-8.4-8.4.1.orig/debian/patches/14-pg_config-paths.patch +++ postgresql-8.4-8.4.1/debian/patches/14-pg_config-paths.patch @@ -0,0 +1,26 @@ +--- postgresql-8.3.0/src/bin/pg_config/pg_config.c 2008-02-03 12:12:01.000000000 +0100 ++++ postgresql-8.3.0/src/bin/pg_config/pg_config.c 2008-02-03 12:13:09.000000000 +0100 +@@ -26,6 +26,8 @@ + + #include "port.h" + ++#include "../port/pg_config_paths.h" ++ + static const char *progname; + static char mypath[MAXPGPATH]; + +@@ -465,13 +467,7 @@ + } + } + +- ret = find_my_exec(argv[0], mypath); +- +- if (ret) +- { +- fprintf(stderr, _("%s: could not find own program executable\n"), progname); +- exit(1); +- } ++ snprintf(mypath, sizeof(mypath), "%s/%s", PGBINDIR, progname); + + /* no arguments -> print everything */ + if (argc < 2) --- postgresql-8.4-8.4.1.orig/debian/patches/08-pkglibdir.patch +++ postgresql-8.4-8.4.1/debian/patches/08-pkglibdir.patch @@ -0,0 +1,12 @@ +diff -ruN postgresql-8.2beta4-old/src/Makefile.global.in postgresql-8.2beta4/src/Makefile.global.in +--- postgresql-8.2beta4-old/src/Makefile.global.in 2005-09-27 18:39:32.000000000 +0100 ++++ postgresql-8.2beta4/src/Makefile.global.in 2005-10-26 20:40:52.000000000 +0100 +@@ -89,7 +89,7 @@ + pkglibdir = $(libdir) + ifeq "$(findstring pgsql, $(pkglibdir))" "" + ifeq "$(findstring postgres, $(pkglibdir))" "" +-override pkglibdir := $(pkglibdir)/postgresql ++override pkglibdir := $(pkglibdir)/postgresql/8.4/lib + endif + endif + --- postgresql-8.4-8.4.1.orig/debian/patches/15-dict-fallback-dir.patch +++ postgresql-8.4-8.4.1/debian/patches/15-dict-fallback-dir.patch @@ -0,0 +1,43 @@ +# Description: If a tsearch/stem dictionary is not found in sharedir/tsearch_data/ll_cc.{dict,affix}, fall back to sharedir/tsearch_data/system_ll_cc.{dict,affix}, where postgresql-common creates them from system directories. +# Ubuntu: https://launchpad.net/bugs/301770 +--- postgresql-8.3.5/src/backend/tsearch/ts_utils.c 2008-06-19 09:52:31.000000000 -0700 ++++ postgresql-8.3.5/src/backend/tsearch/ts_utils.c 2008-12-05 12:48:02.000000000 -0800 +@@ -15,6 +15,7 @@ + #include "postgres.h" + + #include ++#include + + #include "miscadmin.h" + #include "tsearch/ts_locale.h" +@@ -36,7 +37,7 @@ + const char *extension) + { + char sharepath[MAXPGPATH]; +- char *result; ++ char *result, *system_result; + + /* + * We limit the basename to contain a-z, 0-9, and underscores. This may +@@ -58,6 +59,21 @@ + snprintf(result, MAXPGPATH, "%s/tsearch_data/%s.%s", + sharepath, basename, extension); + ++ /* fall back to a system-supplied one */ ++ if (access(result, R_OK) != 0) ++ { ++ system_result = palloc(MAXPGPATH); ++ snprintf(system_result, MAXPGPATH, "%s/tsearch_data/system_%s.%s", ++ sharepath, basename, extension); ++ if (access(system_result, R_OK) == 0) ++ { ++ pfree(result); ++ result = system_result; ++ } ++ else ++ pfree(system_result); ++ } ++ + return result; + } + --- postgresql-8.4-8.4.1.orig/debian/patches/13-pg_service.conf_directory_doc.patch +++ postgresql-8.4-8.4.1/debian/patches/13-pg_service.conf_directory_doc.patch @@ -0,0 +1,13 @@ +--- postgresql-8.3RC2/src/interfaces/libpq/pg_service.conf.sample 2007-09-14 16:31:22.000000000 +0200 ++++ postgresql-8.3RC2/src/interfaces/libpq/pg_service.conf.sample 2008-01-19 17:24:45.000000000 +0100 +@@ -8,8 +8,8 @@ + # to look up such parameters. A sample configuration for postgres is + # included in this file. Lines beginning with '#' are comments. + # +-# Copy this to your sysconf directory (typically /usr/local/pgsql/etc) and +-# rename it pg_service.conf. ++# Copy this to /etc/postgresql-common/ (or select its location with the ++# PGSYSCONFDIR environment variable) and rename it pg_service.conf. + # + # + #[postgres] --- postgresql-8.4-8.4.1.orig/debian/patches/06-libpq-defaultsocketdir.patch +++ postgresql-8.4-8.4.1/debian/patches/06-libpq-defaultsocketdir.patch @@ -0,0 +1,12 @@ +diff -ruN postgresql-8.2.3-old/src/include/pg_config_manual.h postgresql-8.2.3/src/include/pg_config_manual.h +--- postgresql-8.2.3-old/src/include/pg_config_manual.h 2004-09-10 16:27:37.000000000 +0200 ++++ postgresql-8.2.3/src/include/pg_config_manual.h 2005-06-14 19:21:28.200000000 +0200 +@@ -160,7 +160,7 @@ + * here's where to twiddle it. You can also override this at runtime + * with the postmaster's -k switch. + */ +-#define DEFAULT_PGSOCKET_DIR "/tmp" ++#define DEFAULT_PGSOCKET_DIR "/var/run/postgresql" + + /* + * The random() function is expected to yield values between 0 and --- postgresql-8.4-8.4.1.orig/debian/docbook2man-sgmlspl/docbook2man-spec.pl +++ postgresql-8.4-8.4.1/debian/docbook2man-sgmlspl/docbook2man-spec.pl @@ -0,0 +1,1546 @@ +=head1 NAME + +docbook2man-spec.pl - convert DocBook RefEntries to Unix manpages + +=head1 SYNOPSIS + +The sgmlspl script from the SGMLSpm Perl module must be used to run +this script. Use it like this: + +nsgmls some-docbook-document.sgml | sgmlspl docbook2man-spec.pl + +See man page or included DocBook documentation for details. + +=head1 DESCRIPTION + +This is a sgmlspl spec file that produces Unix-style +man pages from DocBook RefEntry markup. + +=head1 COPYRIGHT + +Copyright (C) 1998-2001 Steve Cheng + +Copyright (C) 1999 Thomas Lockhart + +This program is free software; you can redistribute it and/or modify it +under the terms of the GNU General Public License as published by the Free +Software Foundation; either version 2, or (at your option) any later +version. + +You should have received a copy of the GNU General Public License along with +this program; see the file COPYING. If not, please write to the Free +Software Foundation, 675 Mass Ave, Cambridge, MA 02139, USA. + +=cut + +# $Id: docbook2man-spec.pl,v 1.1.1.1 2001/09/06 18:37:06 stevecheng Exp $ + +use SGMLS; # Use the SGMLS package. +use SGMLS::Output; # Use stack-based output. +use SGMLS::Refs; + + +######################################################################## +# SGMLSPL script produced automatically by the script sgmlspl.pl +# +# Document Type: any, but processes only RefEntries +# Edited by: me :) +######################################################################## + + +$write_manpages = 0; +$blank_xrefs = 0; + +$default_sect = "1"; +$default_date = `date "+%d %B %Y"`; +$cite_numeral_only = 1; + +while (@ARGV) { + my $arg = shift @ARGV; + if ($arg eq "--section") { + $default_sect = shift @ARGV || die "$arg requires an argument\n"; + } elsif ($arg eq "--date") { + $default_date = shift @ARGV || die "$arg requires an argument\n"; + } elsif ($arg eq "--lowercase") { + $lowercase_names = 1; + } elsif ($arg eq "--preserve-case") { + $lowercase_names = 0; + } elsif ($arg eq "--cite-numeral-only") { + $cite_numeral_only = 1; + } elsif ($arg eq "--nocite-numeral-only") { + $cite_numeral_only = 0; + } elsif ($arg eq "--help") { + print "Usage: $0", + " [ --section