--- postgresql-8.1-8.1.23.orig/postgresql-8.1.23.tar.bz2.cdbs-config_list +++ postgresql-8.1-8.1.23/postgresql-8.1.23.tar.bz2.cdbs-config_list @@ -0,0 +1,4 @@ +postgresql-8.1.23/doc/src/sgml/config.sgml +postgresql-8.1.23/contrib/tsearch2/gendict/config.sh +postgresql-8.1.23/config/config.guess +postgresql-8.1.23/config/config.sub --- postgresql-8.1-8.1.23.orig/debian/postgresql-plpython-8.1.install +++ postgresql-8.1-8.1.23/debian/postgresql-plpython-8.1.install @@ -0,0 +1 @@ +usr/lib/postgresql/8.1/lib/plpython.so --- postgresql-8.1-8.1.23.orig/debian/postgresql-contrib-8.1.postinst +++ postgresql-8.1-8.1.23/debian/postgresql-contrib-8.1.postinst @@ -0,0 +1,11 @@ +#!/bin/sh -e + +VERSION=8.1 + +. /usr/share/postgresql-common/maintscripts-functions + +if [ "$1" = configure ]; then + configure_contrib_version $VERSION "$2" +fi + +#DEBHELPER# --- postgresql-8.1-8.1.23.orig/debian/libpq-dev.install +++ postgresql-8.1-8.1.23/debian/libpq-dev.install @@ -0,0 +1,16 @@ +usr/include/postgresql/internal/* +usr/include/postgresql/libpq-fe.h +usr/include/postgresql/libpq/libpq-fs.h +usr/include/postgresql/pg_config*.h +usr/include/postgresql/postgres_ext.h +usr/include/postgresql/8.1/server/catalog/pg_type.h /usr/include/postgresql/catalog +usr/include/postgresql/8.1/server/nodes/nodes.h /usr/include/postgresql/nodes +usr/include/postgresql/8.1/server/utils/{elog,errcodes,palloc}.h /usr/include/postgresql/utils +usr/include/postgresql/8.1/server/{c,pg_config,pg_config_manual,pg_config_os,port}.h /usr/include/postgresql/ +usr/include/postgresql/8.1/server/postgres{,_fe,_ext}.h /usr/include/postgresql/ +usr/lib/libpgport.a +usr/lib/libpq.a +usr/lib/libpq.so +usr/lib/postgresql/8.1/bin/pg_config +usr/share/postgresql/8.1/man/man1/pg_config.1 +usr/share/locale/*/LC_MESSAGES/pg_config-8.1.mo --- postgresql-8.1-8.1.23.orig/debian/postgresql-8.1.postinst +++ postgresql-8.1-8.1.23/debian/postgresql-8.1.postinst @@ -0,0 +1,18 @@ +#!/bin/sh -e + +VERSION=8.1 + + +if [ "$1" = configure ]; then + # replace timezone directory with symlink on upgrades + if ! [ -L /usr/share/postgresql/8.1/timezone ]; then + rmdir /usr/share/postgresql/8.1/timezone + ln -s ../../zoneinfo /usr/share/postgresql/8.1/timezone + fi + + . /usr/share/postgresql-common/maintscripts-functions + + configure_version $VERSION "$2" +fi + +#DEBHELPER# --- postgresql-8.1-8.1.23.orig/debian/postgresql-8.1.links +++ postgresql-8.1-8.1.23/debian/postgresql-8.1.links @@ -0,0 +1 @@ +/usr/share/doc/postgresql-common/README.Debian.gz /usr/share/doc/postgresql-8.1/README.Debian.gz --- postgresql-8.1-8.1.23.orig/debian/postgresql-doc-8.1.doc-base +++ postgresql-8.1-8.1.23/debian/postgresql-doc-8.1.doc-base @@ -0,0 +1,13 @@ +Document: postgresql-8.1 +Title: PostgreSQL 8.1 Documentation +Author: The PostgreSQL Global Development Group +Abstract: The documentation for the PostgreSQL database management system, + version 8.1. PostgreSQL is a sophisticated Object-Relational DBMS, supporting + almost all SQL constructs, including subselects, transactions, and + user-defined types and functions. +Section: Apps/Databases + +Format: HTML +Index: /usr/share/doc/postgresql-doc-8.1/html/index.html +Files: /usr/share/doc/postgresql-doc-8.1/html/* + --- postgresql-8.1-8.1.23.orig/debian/libpq-dev.manpages +++ postgresql-8.1-8.1.23/debian/libpq-dev.manpages @@ -0,0 +1 @@ +debian/tmp/usr/share/postgresql/8.1/man/man1/pg_config.1 --- postgresql-8.1-8.1.23.orig/debian/postgresql-8.1.postrm +++ postgresql-8.1-8.1.23/debian/postgresql-8.1.postrm @@ -0,0 +1,53 @@ +#!/bin/sh -e + +#DEBHELPER# + +VERSION=8.1 + +clean_dir() { + if [ -d "$1" -a ! -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 + if DATA=$(readlink -f /etc/postgresql/$VERSION/"$1"/pgdata); then + rm -rf "$DATA" /etc/postgresql/$VERSION/"$1"/pgdata + fi + + # remove log file + if LOG=$(readlink -f /etc/postgresql/$VERSION/"$1"/log); then + rm -rf "$LOG" /etc/postgresql/$VERSION/"$1"/log + fi + + # remove conffiles + for f in pg_hba.conf pg_ident.conf postgresql.conf start.conf; 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/pgdata" ] || 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.1-8.1.23.orig/debian/postgresql-server-dev-8.1.install +++ postgresql-8.1-8.1.23/debian/postgresql-server-dev-8.1.install @@ -0,0 +1,2 @@ +usr/include/postgresql/8.1/* +usr/lib/postgresql/8.1/lib/pgxs/* --- postgresql-8.1-8.1.23.orig/debian/postgresql-doc-8.1.install +++ postgresql-8.1-8.1.23/debian/postgresql-doc-8.1.install @@ -0,0 +1 @@ +usr/share/doc/postgresql-doc-8.1/html/* --- postgresql-8.1-8.1.23.orig/debian/postgresql-client-8.1.install +++ postgresql-8.1-8.1.23/debian/postgresql-client-8.1.install @@ -0,0 +1,32 @@ +usr/lib/postgresql/8.1/bin/clusterdb +usr/lib/postgresql/8.1/bin/pg_dumpall +usr/lib/postgresql/8.1/bin/pg_dump +usr/lib/postgresql/8.1/bin/createdb +usr/lib/postgresql/8.1/bin/createlang +usr/lib/postgresql/8.1/bin/createuser +usr/lib/postgresql/8.1/bin/dropdb +usr/lib/postgresql/8.1/bin/droplang +usr/lib/postgresql/8.1/bin/dropuser +usr/lib/postgresql/8.1/bin/reindexdb +usr/lib/postgresql/8.1/bin/pg_restore +usr/lib/postgresql/8.1/bin/psql +usr/lib/postgresql/8.1/bin/vacuumdb +usr/lib/postgresql/8.1/bin/vacuumlo +usr/share/postgresql/8.1/man/man1/pg_restore.1 +usr/share/postgresql/8.1/man/man1/psql.1 +usr/share/postgresql/8.1/man/man1/vacuumdb.1 +usr/share/postgresql/8.1/man/man1/clusterdb.1 +usr/share/postgresql/8.1/man/man1/pg_dump.1 +usr/share/postgresql/8.1/man/man1/pg_dumpall.1 +usr/share/postgresql/8.1/man/man1/createdb.1 +usr/share/postgresql/8.1/man/man1/createlang.1 +usr/share/postgresql/8.1/man/man1/createuser.1 +usr/share/postgresql/8.1/man/man1/dropdb.1 +usr/share/postgresql/8.1/man/man1/droplang.1 +usr/share/postgresql/8.1/man/man1/dropuser.1 +usr/share/postgresql/8.1/man/man1/reindexdb.1 +usr/share/postgresql/8.1/man/man7/*7 +usr/share/postgresql/8.1/psqlrc.sample +usr/share/locale/*/LC_MESSAGES/pg_dump-8.1.mo +usr/share/locale/*/LC_MESSAGES/psql-8.1.mo +usr/share/locale/*/LC_MESSAGES/pgscripts-8.1.mo --- postgresql-8.1-8.1.23.orig/debian/libecpg-compat2.install +++ postgresql-8.1-8.1.23/debian/libecpg-compat2.install @@ -0,0 +1 @@ +usr/lib/libecpg_compat.so.2* --- postgresql-8.1-8.1.23.orig/debian/postgresql-client-8.1.prerm +++ postgresql-8.1-8.1.23/debian/postgresql-client-8.1.prerm @@ -0,0 +1,10 @@ +#!/bin/sh -e + +#DEBHELPER# + +VERSION=8.1 + +if [ "$1" = remove ]; then + . /usr/share/postgresql-common/maintscripts-functions + remove_client_version $VERSION +fi --- postgresql-8.1-8.1.23.orig/debian/postgresql-contrib-8.1.prerm +++ postgresql-8.1-8.1.23/debian/postgresql-contrib-8.1.prerm @@ -0,0 +1,10 @@ +#!/bin/sh -e + +#DEBHELPER# + +VERSION=8.1 + +if [ "$1" = remove ]; then + . /usr/share/postgresql-common/maintscripts-functions + remove_contrib_version $VERSION +fi --- postgresql-8.1-8.1.23.orig/debian/postgresql-client-8.1.postinst +++ postgresql-8.1-8.1.23/debian/postgresql-client-8.1.postinst @@ -0,0 +1,11 @@ +#!/bin/sh -e + +VERSION=8.1 + +. /usr/share/postgresql-common/maintscripts-functions + +if [ "$1" = configure ]; then + configure_client_version $VERSION "$2" +fi + +#DEBHELPER# --- postgresql-8.1-8.1.23.orig/debian/compat +++ postgresql-8.1-8.1.23/debian/compat @@ -0,0 +1 @@ +4 --- postgresql-8.1-8.1.23.orig/debian/libpgtypes2.install +++ postgresql-8.1-8.1.23/debian/libpgtypes2.install @@ -0,0 +1 @@ +usr/lib/libpgtypes.so.2* --- postgresql-8.1-8.1.23.orig/debian/libecpg-dev.manpages +++ postgresql-8.1-8.1.23/debian/libecpg-dev.manpages @@ -0,0 +1 @@ +debian/tmp/usr/share/postgresql/8.1/man/man1/ecpg.1 --- postgresql-8.1-8.1.23.orig/debian/rules +++ postgresql-8.1-8.1.23/debian/rules @@ -0,0 +1,80 @@ +#!/usr/bin/make -f +TCL_VER := 8.4 +DEB_TAR_SRCDIR := postgresql-8.1.23 + +include /usr/share/cdbs/1/rules/tarball.mk +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 + +DEB_DH_INSTALL_SOURCEDIR=debian/tmp +DEB_CONFIGURE_EXTRA_FLAGS := --mandir=\$${prefix}/share/postgresql/8.1/man \ + --with-docdir=\$${prefix}/share/doc/postgresql-doc-8.1 \ + --datadir=\$${prefix}/share/postgresql/8.1 \ + --bindir=\$${prefix}/lib/postgresql/8.1/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-openssl \ + --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-pgport=5432 \ + $(ARCH_OPTS) \ + LDFLAGS='$(LDFLAGS)' + +DEB_DH_MAKESHLIBS_ARGS := -Xusr/lib/postgresql/8.1 +DEB_DH_INSTALLCHANGELOGS_ARGS := build-tree/postgresql-*/HISTORY +DEB_COMPRESS_EXCLUDE := .source .c + +common-post-build-arch:: + # generate POT files for translators + find build-tree -name nls.mk -exec sh -c "make -C \$$(dirname {}) init-po" \; + +common-post-build-indep:: + # build tutorial stuff + make -C build-tree/$(DEB_TAR_SRCDIR)/src/tutorial NO_PGXS=1 + +install/postgresql-doc-8.1:: + install build-tree/$(DEB_TAR_SRCDIR)/src/tutorial/*.c build-tree/$(DEB_TAR_SRCDIR)/src/tutorial/*.source build-tree/$(DEB_TAR_SRCDIR)/src/tutorial/Makefile build-tree/$(DEB_TAR_SRCDIR)/src/tutorial/README debian/$(cdbs_curpkg)/usr/share/doc/$(cdbs_curpkg)/tutorial + +binary-predeb/postgresql-8.1:: + # 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. + cd build-tree/$(DEB_TAR_SRCDIR) && \ + patch -p1 < ../../debian/disable-root-check.patch && \ + make + + # run testsuite +ifeq (, $(findstring nocheck, $(DEB_BUILD_OPTIONS))) + cd build-tree/$(DEB_TAR_SRCDIR); \ + if ! make check; 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; \ + fi +endif + + cd build-tree/$(DEB_TAR_SRCDIR) && \ + patch -Rp1 < ../../debian/disable-root-check.patch + + # compress manpages + find debian/postgresql-8.1/usr/share/postgresql/8.1/man -type f -exec gzip -9 '{}' \; + +binary-predeb/postgresql-client-8.1:: + find debian/postgresql-client-8.1/usr/share/postgresql/8.1/man -type f -exec gzip -9 '{}' \; --- postgresql-8.1-8.1.23.orig/debian/control +++ postgresql-8.1-8.1.23/debian/control @@ -0,0 +1,239 @@ +Source: postgresql-8.1 +Section: misc +Priority: optional +Maintainer: Martin Pitt +Uploaders: Oliver Elphick +Standards-Version: 3.7.2 +Build-Depends: debhelper (>= 4.1.46), cdbs, bison, perl (>= 5.8), libperl-dev, tk8.4-dev, flex, libreadline5-dev (>= 4.2), libssl-dev, zlib1g-dev | libz-dev, libpam0g-dev | libpam-dev, libxml2-dev, libkrb5-dev, libxslt1-dev, python-dev, gettext, bzip2 + +Package: postgresql-8.1 +Architecture: any +Section: misc +Depends: ${shlibs:Depends}, postgresql-client-8.1, locales, postgresql-common (>= 39) +Suggests: oidentd | ident-server +Conflicts: postgresql (<< 7.5) +Description: object-relational SQL database, version 8.1 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.1. 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.1 +Architecture: any +Section: misc +Depends: ${shlibs:Depends}, postgresql-client-common +Conflicts: postgresql (<< 7.5) +Suggests: postgresql-8.1, postgresql-doc-8.1 +Description: front-end programs for PostgreSQL 8.1 + 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.1. If you install + PostgreSQL 8.1 on a standalone machine, you need the server package + postgresql-8.1, 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.1 +Architecture: any +Section: libdevel +Depends: ${shlibs:Depends}, libpq-dev (>= 8.1) +Conflicts: pgxs +Replaces: pgxs +Description: development files for PostgreSQL 8.1 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.1 +Architecture: all +Section: doc +Suggests: doc-linux-html,pgdocs +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.1. The manual is in HTML format. See the + packages pgdocs-pdf and pgdocs-pdf-a4 for other printable formats. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-contrib-8.1 +Architecture: any +Section: misc +Depends: postgresql-8.1, ${shlibs:Depends}, postgresql-common (>= 39) +Recommends: libpg-perl (>= 1:2.0.1-1), 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.1. contrib often serves as a testbed for + features before they are adopted into PostgreSQL proper: + . + btree_gist - B-Tree indexing using GiST (Generalised Search Tree) + chkpass - Password type for storing and comparing encrypted passwords + cube - Type for n-dimensional "cubes" + dbf2pg - Inserts the contents of an xBase-style .dbf file into a + PostgreSQL table + dblink - Functions to return results from a remote database + dbmirror - Trigger-based databaase mirroring + earthdistance - Operator for computing the distance (in miles) between + two points on the earth's surface + fti - Full text indexing using triggers + fuzzystrmatch - Functions for fuzzy string comparison (including Soundex) + intagg - Integer aggregator/enumerator + intarray - RD-tree data structure using GiST index + isbn_issn - Type extensions for ISBN (books) and ISSN (serials) + lo - Large Object maintenance + ltree - data types, indexed access methods and queries for data + organized as a tree-like structures. + oid2name - Maps oids to table names + ora2pg - Conversion utility for Oracle database schemas + pg_buffercache - Real time queries on the shared buffer cache + pg_trgm - Determine the similarity of text based on trigram matching + pgbench - A simple program to run a benchmark test + pgcrypto - Cryptographic functions + pgstattuple - Returns the percentage of dead tuples in a table; this + indicates whether a vacuum is required. + seg - Type representing laboratory measurements as floating- + point intervals + 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. + tips - Micro HOWTOs + tsearch2 - Searchable text data type supporting indexed access + user_locks - User-level long-term locks + vacuumlo - Vacuum deleted large objects + xml2 - Manipulate XML documents in the database + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-plperl-8.1 +Architecture: any +Depends: ${shlibs:Depends}, postgresql-8.1 +Description: PL/Perl procedural language for PostgreSQL 8.1 + PL/Perl enables an SQL developer to write procedural language functions + for PostgreSQL 8.1 in Perl. You need this package if you have any + PostgreSQL 8.1 functions that use the languages plperl or plperlu. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-plpython-8.1 +Architecture: any +Depends: ${shlibs:Depends}, postgresql-8.1 +Description: PL/Python procedural language for PostgreSQL 8.1 + PL/Python enables an SQL developer to write procedural language functions + for PostgreSQL 8.1 in Python. You need this package if you have any + PostgreSQL 8.1 functions that use the languages plpython or plpythonu. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-pltcl-8.1 +Architecture: any +Depends: ${shlibs:Depends}, postgresql-8.1 +Description: PL/TCL procedural language for PostgreSQL 8.1 + PL/TCL enables an SQL developer to write procedural language functions + for PostgreSQL 8.1 in TCL. You need this package if you have any + PostgreSQL 8.1 functions that use the languages pltcl or pltclu. + . + PostgreSQL is an object-relational SQL database management system. + +Package: libpq-dev +Architecture: any +Section: libdevel +Depends: ${shlibs:Depends}, libpq4 (= ${Source-Version}), libssl-dev +Conflicts: postgresql-dev (<< 7.5) +Replaces: postgresql-dev +Suggests: postgresql-doc-8.1, libpqxx-dev, libpgeasy-dev, heimdal-dev +Description: header files for libpq4 (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: libpq4 +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 7.3 or later. + . + This package contains the run-time library, needed by packages using + libpq. + . + PostgreSQL is an object-relational SQL database management system. + +Package: libecpg5 +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-compat2, libpgtypes2 +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-compat2 +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: libpgtypes2 +Architecture: any +Section: libs +Depends: ${shlibs:Depends} +Description: shared library libpgtypes for PostgreSQL 8.1 + The libpgtypes shared library is used by programs built with ecpg. + (Embedded PostgreSQL for C). + . + PostgreSQL is an object-relational SQL database management system. + --- postgresql-8.1-8.1.23.orig/debian/libpq4.shlibs +++ postgresql-8.1-8.1.23/debian/libpq4.shlibs @@ -0,0 +1 @@ +libpq 4 libpq4 (>= 8.1.4) --- postgresql-8.1-8.1.23.orig/debian/postgresql-contrib-8.1.install +++ postgresql-8.1-8.1.23/debian/postgresql-contrib-8.1.install @@ -0,0 +1,37 @@ +usr/share/doc/postgresql-doc-8.1/contrib/* usr/share/doc/postgresql-contrib-8.1 +usr/share/postgresql/8.1/contrib/* +usr/lib/postgresql/8.1/bin/DBMirror.pl +usr/lib/postgresql/8.1/bin/clean_pending.pl +usr/lib/postgresql/8.1/bin/dbf2pg +usr/lib/postgresql/8.1/bin/fti.pl +usr/lib/postgresql/8.1/bin/oid2name +usr/lib/postgresql/8.1/bin/pgbench +usr/lib/postgresql/8.1/lib/_int.so +usr/lib/postgresql/8.1/lib/autoinc.so +usr/lib/postgresql/8.1/lib/btree_gist.so +usr/lib/postgresql/8.1/lib/chkpass.so +usr/lib/postgresql/8.1/lib/cube.so +usr/lib/postgresql/8.1/lib/dblink.so +usr/lib/postgresql/8.1/lib/earthdistance.so +usr/lib/postgresql/8.1/lib/fti.so +usr/lib/postgresql/8.1/lib/fuzzystrmatch.so +usr/lib/postgresql/8.1/lib/insert_username.so +usr/lib/postgresql/8.1/lib/int_aggregate.so +usr/lib/postgresql/8.1/lib/isbn_issn.so +usr/lib/postgresql/8.1/lib/lo.so +usr/lib/postgresql/8.1/lib/ltree.so +usr/lib/postgresql/8.1/lib/moddatetime.so +usr/lib/postgresql/8.1/bin/ora2pg.pl +usr/lib/postgresql/8.1/bin/Ora2Pg.pm usr/share/postgresql/8.1/contrib +usr/lib/postgresql/8.1/lib/pending.so +usr/lib/postgresql/8.1/lib/pg_trgm.so +usr/lib/postgresql/8.1/lib/pgcrypto.so +usr/lib/postgresql/8.1/lib/pgstattuple.so +usr/lib/postgresql/8.1/lib/refint.so +usr/lib/postgresql/8.1/lib/seg.so +usr/lib/postgresql/8.1/lib/tablefunc.so +usr/lib/postgresql/8.1/lib/timetravel.so +usr/lib/postgresql/8.1/lib/tsearch2.so +usr/lib/postgresql/8.1/lib/user_locks.so +usr/lib/postgresql/8.1/lib/pgxml.so +usr/lib/postgresql/8.1/lib/pg_buffercache.so --- postgresql-8.1-8.1.23.orig/debian/changelog +++ postgresql-8.1-8.1.23/debian/changelog @@ -0,0 +1,1271 @@ +postgresql-8.1 (8.1.23-0ubuntu0.6.06.1) dapper-security; urgency=low + + * Add 14-intarray_query_int_buffer_overrun.patch: + - Fix buffer overrun in "contrib/intarray"'s input function for the + query_int type. This bug is a security risk since the function's return + address could be overwritten. Patch backported from 8.2 (commit + e11349fdb). (CVE-2010-4015) (LP: #711318) + + -- Martin Pitt Tue, 01 Feb 2011 23:24:29 +0100 + +postgresql-8.1 (8.1.23-0ubuntu0.6.06) dapper-proposed; urgency=low + + * New upstream bug fix release (LP: #693157): + - Force the default wal_sync_method to be fdatasync on Linux. + The default on Linux has actually been fdatasync for many years, + but recent kernel changes caused PostgreSQL to choose open_datasync + instead. This choice did not result in any performance improvement, + and caused outright failures on certain filesystems, notably ext4 + with the data=journal mount option. + - Fix recovery from base backup when the starting checkpoint WAL + record is not in the same WAL segment as its redo point. + - Add support for detecting register-stack overrun on IA64. + The IA64 architecture has two hardware stacks. Full prevention of + stack-overrun failures requires checking both. + - Add a check for stack overflow in copyObject(). + Certain code paths could crash due to stack overflow given a + sufficiently complex query. + - Fix detection of page splits in temporary GiST indexes. + It is possible to have a "concurrent" page split in a temporary + index, if for example there is an open cursor scanning the index + when an insertion is done. GiST failed to detect this case and + hence could deliver wrong results when execution of the cursor + continued. + - Avoid memory leakage while "ANALYZE"'ing complex index expressions. + - Ensure an index that uses a whole-row Var still depends on its + table. + An index declared like create index i on t (foo(t.-)) would not + automatically get dropped when its table was dropped. + - Do not "inline" a SQL function with multiple OUT parameters. + This avoids a possible crash due to loss of information about the + expected result rowtype. + - Fix constant-folding of COALESCE() expressions. + The planner would sometimes attempt to evaluate sub-expressions + that in fact could never be reached, possibly leading to unexpected + errors. + - Add print functionality for InhRelation nodes. + This avoids a failure when debug_print_parse is enabled and certain + types of query are executed. + - Fix incorrect calculation of distance from a point to a horizontal + line segment. + This bug affected several different geometric distance-measurement + operators. + - Fix PL/pgSQL's handling of "simple" expressions to not fail in + recursion or error-recovery cases. + - Fix bug in "contrib/cube"'s GiST picksplit algorithm. + This could result in considerable inefficiency, though not actually + incorrect answers, in a GiST index on a cube column. If you have + such an index, consider "REINDEX"ing it after installing this + update. + - Don't emit "identifier will be truncated" notices in + "contrib/dblink" except when creating new connections. + - Fix potential coredump on missing public key in "contrib/pgcrypto". + - Fix memory leak in "contrib/xml2"'s XPath query functions. + + -- Martin Pitt Tue, 21 Dec 2010 21:40:48 +0100 + +postgresql-8.1 (8.1.22-0ubuntu0.6.06) dapper-security; urgency=low + + * New upstream security/bug fix release: (LP: #655293) + - Use a separate interpreter for each calling SQL userid in PL/Perl + and PL/Tcl. + This change prevents security problems that can be caused by + subverting Perl or Tcl code that will be executed later in the same + session under another SQL user identity (for example, within a + SECURITY DEFINER function). Most scripting languages offer numerous + ways that that might be done, such as redefining standard functions + or operators called by the target function. Without this change, + any SQL user with Perl or Tcl language usage rights can do + essentially anything with the SQL privileges of the target + function's owner. + The cost of this change is that intentional communication among + Perl and Tcl functions becomes more difficult. To provide an escape + hatch, PL/PerlU and PL/TclU functions continue to use only one + interpreter per session. This is not considered a security issue + since all such functions execute at the trust level of a database + superuser already. + It is likely that third-party procedural languages that claim to + offer trusted execution have similar security issues. We advise + contacting the authors of any PL you are depending on for + security-critical purposes. + Our thanks to Tim Bunce for pointing out this issue + (CVE-2010-3433). + - Prevent possible crashes in pg_get_expr() by disallowing it from + being called with an argument that is not one of the system catalog + columns it's intended to be used with. + - Fix "cannot handle unplanned sub-select" error. + This occurred when a sub-select contains a join alias reference + that expands into an expression containing another sub-select. + - Prevent show_session_authorization() from crashing within + autovacuum processes. + - Defend against functions returning setof record where not all the + returned rows are actually of the same rowtype. + - Fix possible failure when hashing a pass-by-reference function + result. + - Take care to fsync the contents of lockfiles (both "postmaster.pid" + and the socket lockfile) while writing them. + This omission could result in corrupted lockfile contents if the + machine crashes shortly after postmaster start. That could in turn + prevent subsequent attempts to start the postmaster from + succeeding, until the lockfile is manually removed. + - Avoid recursion while assigning XIDs to heavily-nested + subtransactions. + The original coding could result in a crash if there was limited + stack space. + - Fix log_line_prefix's %i escape, which could produce junk early in + backend startup. + - Fix possible data corruption in "ALTER TABLE ... SET TABLESPACE" + when archiving is enabled. + - Allow "CREATE DATABASE" and "ALTER DATABASE ... SET TABLESPACE" to + be interrupted by query-cancel. + - In PL/Python, defend against null pointer results from + PyCObject_AsVoidPtr and PyCObject_FromVoidPtr. + - Improve "contrib/dblink"'s handling of tables containing dropped + columns. + - Fix connection leak after "duplicate connection name" errors in + "contrib/dblink". + - Fix "contrib/dblink" to handle connection names longer than 62 + bytes correctly. + - Update build infrastructure and documentation to reflect the source + code repository's move from CVS to Git (Magnus Hagander and others) + + -- Martin Pitt Wed, 06 Oct 2010 10:04:24 +0200 + +postgresql-8.1 (8.1.21-0ubuntu0.6.06) dapper-security; urgency=low + + * New upstream security/bug fix release: + - Enforce restrictions in plperl using an opmask applied to the whole + interpreter, instead of using "Safe.pm". + Recent developments have convinced us that "Safe.pm" is too + insecure to rely on for making plperl trustable. This change + removes use of "Safe.pm" altogether, in favor of using a separate + interpreter with an opcode mask that is always applied. Pleasant + side effects of the change include that it is now possible to use + Perl's strict pragma in a natural way in plperl, and that Perl's $a + and $b variables work as expected in sort routines, and that + function compilation is significantly faster. (CVE-2010-1169) + - Prevent PL/Tcl from executing untrustworthy code from pltcl_modules. + PL/Tcl's feature for autoloading Tcl code from a database table + could be exploited for trojan-horse attacks, because there was no + restriction on who could create or insert into that table. This + change disables the feature unless pltcl_modules is owned by a + superuser. (However, the permissions on the table are not checked, + so installations that really need a less-than-secure modules table + can still grant suitable privileges to trusted non-superusers.) + Also, prevent loading code into the unrestricted "normal" Tcl + interpreter unless we are really going to execute a pltclu + function. (CVE-2010-1170) + - Do not allow an unprivileged user to reset superuser-only parameter + settings. + Previously, if an unprivileged user ran ALTER USER ... RESET ALL + for himself, or ALTER DATABASE ... RESET ALL for a database he + owns, this would remove all special parameter settings for the user + or database, even ones that are only supposed to be changeable by a + superuser. Now, the "ALTER" will only remove the parameters that + the user has permission to change. + - Avoid possible crash during backend shutdown if shutdown occurs + when a CONTEXT addition would be made to log entries. + In some cases the context-printing function would fail because the + current transaction had already been rolled back when it came time + to print a log message. + - Update pl/perl's "ppport.h" for modern Perl versions. + - Fix assorted memory leaks in pl/python. + - Prevent infinite recursion in psql when expanding a variable that + refers to itself. + - Ensure that "contrib/pgstattuple" functions respond to cancel + interrupts promptly. + + -- Martin Pitt Sat, 15 May 2010 12:57:33 +0200 + +postgresql-8.1 (8.1.20-0ubuntu0.6.06) dapper-proposed; urgency=low + + * New upstream bug fix release: (LP: #557408) + - Add new configuration parameter ssl_renegotiation_limit to control + how often we do session key renegotiation for an SSL connection. + This can be set to zero to disable renegotiation completely, which + may be required if a broken SSL library is used. In particular, + some vendors are shipping stopgap patches for CVE-2009-3555 that + cause renegotiation attempts to fail. + - Fix possible crashes when trying to recover from a failure in + subtransaction start. + - Fix server memory leak associated with use of savepoints and a + client encoding different from server's encoding. + - Make substring() for bit types treat any negative length as meaning + "all the rest of the string". + The previous coding treated only -1 that way, and would produce an + invalid result value for other negative values, possibly leading to + a crash (CVE-2010-0442). + - Fix integer-to-bit-string conversions to handle the first + fractional byte correctly when the output bit width is wider than + the given integer by something other than a multiple of 8 bits. + - Fix some cases of pathologically slow regular expression matching. + - Fix the STOP WAL LOCATION entry in backup history files to report + the next WAL segment's name when the end location is exactly at a + segment boundary. + - Fix some more cases of temporary-file leakage. + This corrects a problem introduced in the previous minor release. + One case that failed is when a plpgsql function returning set is + called within another function's exception handler. + - When reading "pg_hba.conf" and related files, do not treat + @something as a file inclusion request if the @ appears inside + quote marks; also, never treat @ by itself as a file inclusion + request. + This prevents erratic behavior if a role or database name starts + with @. If you need to include a file whose path name contains + spaces, you can still do so, but you must write @"/path to/file" + rather than putting the quotes around the whole construct. + - Prevent infinite loop on some platforms if a directory is named as + an inclusion target in "pg_hba.conf" and related files. + - Fix psql's numericlocale option to not format strings it shouldn't + in latex and troff output formats. + - Fix plpgsql failure in one case where a composite column is set to + NULL. + - Add volatile markings in PL/Python to avoid possible + compiler-specific misbehavior. + - Prevent crash in "contrib/dblink" when too many key columns are + specified to a dblink_build_sql_- function. + - Fix assorted crashes in "contrib/xml2" caused by sloppy memory + management. + + -- Martin Pitt Wed, 07 Apr 2010 19:25:03 +0200 + +postgresql-8.1 (8.1.19-0ubuntu0.6.06) dapper-security; urgency=low + + * New upstream bug fix/security release: (LP: #496923) + - Protect against indirect security threats caused by index functions + changing session-local state. This change prevents allegedly-immutable + index functions from possibly subverting a superuser's session + (CVE-2009-4136). + - Reject SSL certificates containing an embedded null byte in the + common name (CN) field. This prevents unintended matching of a + certificate to a server or client name during SSL validation + (CVE-2009-4034). + - Fix possible crash during backend-startup-time cache initialization. + - Prevent signals from interrupting VACUUM at unsafe times. + - Fix possible crash due to integer overflow in hash table size + calculation. + - Fix very rare crash in inet/cidr comparisons. + - Ensure that shared tuple-level locks held by prepared transactions + are not ignored. + - Fix premature drop of temporary files used for a cursor that is + accessed within a subtransaction. + - Fix PAM password processing to be more robust. The previous code is + known to fail with the combination of the Linux pam_krb5 PAM module with + Microsoft Active Directory as the domain controller. It might have + problems elsewhere too, since it was making unjustified assumptions about + what arguments the PAM stack would pass to it. + - Fix processing of ownership dependencies during CREATE OR REPLACE + FUNCTION. + - Ensure that Perl arrays are properly converted to PostgreSQL arrays + when returned by a set-returning PL/Perl function. + This worked correctly already for non-set-returning functions. + - Fix rare crash in exception processing in PL/Python. + - Make the postmaster ignore any application_name parameter in + connection request packets, to improve compatibility with future + libpq versions. + + -- Martin Pitt Tue, 15 Dec 2009 16:01:10 +0100 + +postgresql-8.1 (8.1.18-0ubuntu0.6.06) dapper-security; urgency=low + + * New upstream bug fix/security release: (LP: #430544) + - 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. (See CVE-2007-6600) + - Fix handling of sub-SELECTs appearing in the arguments of an + outer-level aggregate function. + - Fix hash calculation for data type interval. + This corrects wrong results for hash joins on interval values. It + also changes the contents of hash indexes on interval columns. If + you have any such indexes, you must "REINDEX" them after updating. + - Treat to_char(..., 'TH') as an uppercase ordinal suffix with + 'HH'/'HH12' + It was previously handled as 'th' (lowercase). + - Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million + and integer datetimes are in use. + - Fix calculation of distance between a point and a line segment. + This led to incorrect results from a number of geometric operators. + - Fix money data type to work in locales where currency amounts have + no fractional digits, e.g. Japan. + - Properly round datetime input like + 00:12:57.9999999999999999999999999999 + - Fix poor choice of page split point in GiST R-tree operator classes + - Fix portability issues in plperl initialization + - Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is + empty + - 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 + + -- Martin Pitt Wed, 16 Sep 2009 08:30:31 +0000 + +postgresql-8.1 (8.1.17-0ubuntu0.6.06) dapper-proposed; urgency=low + + * New upstream bug fix release 8.1.17: (LP: #344688) + - Prevent error recursion crashes when encoding conversion fails. + This change extends fixes made in the last two minor releases for + related failure scenarios. The previous fixes were narrowly + tailored for the original problem reports, but we have now + recognized that *any* error thrown by an encoding conversion + function could potentially lead to infinite recursion while trying + to report the error. The solution therefore is to disable + translation and encoding conversion and report the plain-ASCII form + of any error message, if we find we have gotten into a recursive + error reporting situation. + - Disallow "CREATE CONVERSION" with the wrong encodings for the + specified conversion function. This prevents one possible scenario for + encoding conversion failure. The previous change is a backstop to guard + against other kinds of failures in the same area. + - Fix core dump when to_char() is given format codes that are + inappropriate for the type of the data argument. + - Fix decompilation of CASE WHEN with an implicit coercion. + - Fix possible misassignment of the owner of a TOAST table's rowtype. + If "CLUSTER" or a rewriting variant of "ALTER TABLE" were executed + by someone other than the table owner, the pg_type entry for the + table's TOAST table would end up marked as owned by that someone. + This caused no immediate problems, since the permissions on the + TOAST rowtype aren't examined by any ordinary database operation. + However, it could lead to unexpected failures if one later tried to + drop the role that issued the command (in 8.1 or 8.2), or "owner of + data type appears to be invalid" warnings from pg_dump after having + done so (in 8.3). + - Clean up PL/pgSQL error status variables fully at block exit. + This is not a problem for PL/pgSQL itself, but the omission could + cause the PL/pgSQL Debugger to crash while examining the state of a + function. + - Add MUST (Mauritius Island Summer Time) to the default list of + known timezone abbreviations. + + -- Martin Pitt Wed, 25 Mar 2009 09:17:17 +0100 + +postgresql-8.1 (8.1.16-0ubuntu0.6.06) dapper-proposed; urgency=low + + * New upstream bugfix release 8.1.16: (LP: #326372) + - Fix rare crash in autovacuum. + - Improve handling of URLs in headline() function. + - Improve handling of overlength headlines in headline() function. + - Prevent possible Assert failure or misconversion if an encoding + conversion is created with the wrong conversion function for the + specified pair of encodings. + - Avoid unnecessary locking of small tables in "VACUUM". + - Ensure that the contents of a holdable cursor don't depend on the + contents of TOAST tables. Previously, large field values in a + cursor result might be represented as TOAST pointers, which + would fail if the referenced table got dropped before the cursor + is read, or if the large value is deleted and then vacuumed + away. This cannot happen with an ordinary cursor, but it could + with a cursor that is held past its creating transaction. + - Fix uninitialized variables in "contrib/tsearch2"'s get_covers() + function. + - Make all documentation reference pgsql-bugs and/or pgsql-hackers as + appropriate, instead of the now-decommissioned pgsql-ports and + pgsql-patches mailing lists. + + -- Martin Pitt Fri, 06 Feb 2009 23:21:07 +0100 + +postgresql-8.1 (8.1.15-0ubuntu0.6.06) dapper-proposed; urgency=low + + * New upstream bugfix release 8.1.15: (LP: #293758) + - Fix GiST index corruption due to marking the wrong index entry + "dead" after a deletion. This would result in index searches failing to + find rows they should have found. + - Fix backend crash when the client encoding cannot represent a + localized error message. + - Fix possible crash when deeply nested functions are invoked from a + trigger. + - Fix mis-expansion of rule queries when a sub-SELECT appears in a + function call in FROM, a multi-row VALUES list, or a RETURNING list. + The usual symptom of this problem is an "unrecognized node type" + error. + - Ensure an error is reported when a newly-defined PL/pgSQL trigger + function is invoked as a normal function. + - Prevent possible collision of relfilenode numbers when moving a + table to another tablespace with "ALTER SET TABLESPACE". + The command tried to re-use the existing filename, instead of + picking one that is known unused in the destination directory. + - Fix incorrect tsearch2 headline generation when single query item + matches first word of text. + - Fix improper display of fractional seconds in interval values when + using a non-ISO datestyle in an "--enable-integer-datetimes" build. + - Ensure SPI_getvalue and SPI_getbinval behave correctly when the + passed tuple and tuple descriptor have different numbers of columns. + This situation is normal when a table has had columns added or + removed, but these two functions didn't handle it properly. The + only likely consequence is an incorrect error indication. + - Fix ecpg's parsing of "CREATE ROLE". + - Fix recent breakage of pg_ctl restart. + * New upstream bugfix release 8.1.14: + - Widen local lock counters from 32 to 64 bits. This responds to reports + that the counters could overflow in sufficiently long transactions, + leading to unexpected "lock is already held" errors. + - Fix possible duplicate output of tuples during a GiST index scan. + - Add checks in executor startup to ensure that the tuples produced + by an "INSERT" or "UPDATE" will match the target table's current + rowtype. "ALTER COLUMN TYPE", followed by re-use of a previously cached + plan, could produce this type of situation. The check protects + against data corruption and/or crashes that could ensue. + - Fix AT TIME ZONE to first try to interpret its timezone argument as + a timezone abbreviation, and only try it as a full timezone name if + that fails, rather than the other way around as formerly. The timestamp + input functions have always resolved ambiguous zone names in this order. + Making AT TIME ZONE do so as well improves consistency, and fixes a + compatibility bug introduced in 8.1: in ambiguous cases we now behave + the same as 8.0 and before did, since in the older versions AT TIME ZONE + accepted -only* abbreviations. + - Fix datetime input functions to correctly detect integer overflow + when running on a 64-bit platform. + - Improve performance of writing very long log messages to syslog. + - Fix bug in backwards scanning of a cursor on a SELECT DISTINCT ON + query. + - Fix planner bug with nested sub-select expressions. If the outer + sub-select has no direct dependency on the parent query, but the inner + one does, the outer value might not get recalculated for new parent + query rows. + - Fix planner to estimate that GROUP BY expressions yielding boolean + results always result in two groups, regardless of the expressions' + contents. This is very substantially more accurate than the regular + GROUP BY estimate for certain boolean tests like "col" IS NULL. + - Fix PL/PgSQL to not fail when a FOR loop's target variable is a + record containing composite-type fields. + - Improve pg_dump and pg_restore's error reporting after failure to + send a SQL command. + - Fix pg_ctl to properly preserve postmaster command-line arguments + across a restart. + * 03-gettext-domains.patch: Unfuzz for new upstream version. + + -- Martin Pitt Tue, 04 Nov 2008 21:20:52 +0100 + +postgresql-8.1 (8.1.13-0ubuntu0.6.06) dapper-proposed; urgency=low + + * New upstream bugfix release (please note that 8.1.12 was never released, + due to the discovery of another major bug): + - Make "ALTER AGGREGATE ... OWNER TO" update pg_shdepend. + This oversight could lead to problems if the aggregate was later + involved in a "DROP OWNED" or "REASSIGN OWNED" operation. + - Fix "ALTER TABLE ADD COLUMN ... PRIMARY KEY" so that the new column + is correctly checked to see if it's been initialized to all + non-nulls. Previous versions neglected to check this requirement at + all. + - Fix possible "CREATE TABLE" failure when inheriting the "same" + constraint from multiple parent relations that inherited that + constraint from a common ancestor. + - Fix conversions between ISO-8859-5 and other encodings to handle + Cyrillic "Yo" characters (e and E with two dots). + - Fix a few datatype input functions that were allowing unused bytes + in their results to contain uninitialized, unpredictable values. + This could lead to failures in which two apparently identical + literal values were not seen as equal, resulting in the parser + complaining about unmatched ORDER BY and DISTINCT expressions. + - Fix a corner case in regular-expression substring matching. + - Fix incorrect result from ecpg's PGTYPEStimestamp_sub() function. + - Fix core dump in "contrib/xml2"'s xpath_table() function when the + input query returns a NULL value. + - Fix longstanding "LISTEN"/"NOTIFY" race condition. + In rare cases a session that had just executed a "LISTEN" might not + get a notification, even though one would be expected because the + concurrent transaction executing "NOTIFY" was observed to commit + later. + A side effect of the fix is that a transaction that has executed a + not-yet-committed "LISTEN" command will not see any row in + pg_listener for the "LISTEN", should it choose to look; formerly it + would have. This behavior was never documented one way or the + other, but it is possible that some applications depend on the old + behavior. + - Disallow "LISTEN" and "UNLISTEN" within a prepared transaction. + This was formerly allowed but trying to do it had various + unpleasant consequences, notably that the originating backend could + not exit as long as an "UNLISTEN" remained uncommitted. + - Fix rare crash when an error occurs during a query using a hash + index. + - Fix input of datetime values for February 29 in years BC. + The former coding was mistaken about which years were leap years. + - Fix "unrecognized node type" error in some variants of "ALTER + OWNER". + - Fix pg_ctl to correctly extract the postmaster's port number from + command-line options. + Previously, pg_ctl start -w could try to contact the postmaster on + the wrong port, leading to bogus reports of startup failure. + - Fix display of constant expressions in ORDER BY and GROUP BY. + An explictly casted constant would be shown incorrectly. This could + for example lead to corruption of a view definition during dump and + reload. + - Fix libpq to handle NOTICE messages correctly during COPY OUT. + This failure has only been observed to occur when a user-defined + datatype's output routine issues a NOTICE, but there is no + guarantee it couldn't happen due to other causes. + (LP: #238587) + + -- Martin Pitt Mon, 09 Jun 2008 19:09:25 +0200 + +postgresql-8.1 (8.1.11-0ubuntu0.6.06.1) dapper-security; urgency=low + + * New upstream security/bugfix release: + - Prevent functions in indexes from executing with the privileges of + the user running "VACUUM", "ANALYZE", etc. "SET ROLE" is now forbidden + within a SECURITY DEFINER context. [CVE-2007-6600] + - Suitably crafted regular-expression patterns could cause crashes, + infinite or near-infinite looping, and/or massive memory + consumption, all of which pose denial-of-service hazards for + applications that accept regex search patterns from untrustworthy + sources. [CVE-2007-4769, CVE-2007-4772, CVE-2007-6067] + - Require non-superusers who use "/contrib/dblink" to use only + password authentication, as a security measure. + The fix that appeared for this in 8.2.5 was incomplete, as it + plugged the hole for only some "dblink" functions. [CVE-2007-6601, + CVE-2007-3278] + - Fix planner failure in some cases of WHERE false AND var IN (SELECT + ...). + - Preserve the tablespace and storage parameters of indexes that are + rebuilt by "ALTER TABLE ... ALTER COLUMN TYPE". + - Make archive recovery always start a new WAL timeline, rather than + only when a recovery stop time was used. This avoids a corner-case risk + of trying to overwrite an existing archived copy of the last WAL + segment, and seems simpler and cleaner than the original definition. + - Make "VACUUM" not use all of maintenance_work_mem when the table is + too small for it to be useful. + - Fix potential crash in translate() when using a multibyte database + encoding. + - Fix overflow in extract(epoch from interval) for intervals + exceeding 68 years. + - Fix PL/Perl to not fail when a UTF-8 regular expression is used in + a trusted function. + - Fix PL/Python to not crash on long exception messages. + - Fix pg_dump to correctly handle inheritance child tables that have + default expressions different from their parent's. + - Fix libpq crash when PGPASSFILE refers to a file that is not a + plain file. + - ecpg parser fixes. + - Make "contrib/tablefunc"'s crosstab() handle NULL rowid as a + category in its own right, rather than crashing. + - Fix tsvector and tsquery output routines to escape backslashes + correctly. + - Fix crash of to_tsvector() on huge input strings. + * Use the timezone database from the system tzdata instead of shipping our + own. + - debian/patches/04-timezone-symlinks.patch: Drop previous + hardlink-to-symlink patch to zic, since that is irrelevant now. Replace + the patch with a Makefile change that just symlinks /usr/share/zoneinfo + to where postgresql previously installed its own tzdata copy. + - debian/control: Add locales dependency (which contains tzdata in + dapper). + - debian/postgresql-8.1.install: Install the 'timezone' symlink, not the + files in the dereferenced directory. + - debian/postgresql-8.1.postinst: Replace the timezone directory with the + symlink on upgrades, since dpkg does not do that automatically. Without + this, we'd end up with an empty timezone directory. + + -- Martin Pitt Sat, 05 Jan 2008 19:26:49 +0100 + +postgresql-8.1 (8.1.10-0ubuntu0.6.06.1) dapper-proposed; urgency=low + + * New upstream bugfix release: + - Require non-superusers who use "/contrib/dblink" to use only + password authentication, as a security measure. + [CVE-2007-3278, CVE-2007-3280] + - Make "CREATE DOMAIN ... DEFAULT NULL" work properly. + - Allow the interval data type to accept input consisting only of + milliseconds or microseconds. + - Speed up rtree index insertion. + - Fix excessive logging of SSL error messages. + - Fix logging so that log messages are never interleaved when using + the syslogger process. + - Fix crash when log_min_error_statement logging runs out of memory. + - Fix incorrect handling of some foreign-key corner cases. + - Prevent "REINDEX" and "CLUSTER" from failing due to attempting to + process temporary tables of other sessions. + - Update the time zone database rules, particularly New Zealand's + upcoming changes. + + -- Martin Pitt Wed, 19 Sep 2007 10:47:22 +0200 + +postgresql-8.1 (8.1.9-0ubuntu0.6.06) dapper-security; urgency=low + + * New upstream security/bugfix release: + - Support explicit placement of the temporary-table schema within + search_path, and disable searching it for functions and operators. + This is needed to allow a security-definer function to set a truly + secure value of search_path. Without it, an unprivileged SQL user + can use temporary objects to execute code with the privileges of + the security-definer function (CVE-2007-2138). See "CREATE + FUNCTION" for more information. + - "/contrib/tsearch2" crash fixes. + - Require "COMMIT PREPARED" to be executed in the same database as + the transaction was prepared in. + - Fix potential-data-corruption bug in how "VACUUM FULL" handles + "UPDATE" chains. + - Planner fixes, including improving outer join and bitmap scan + selection logic. + - Fix PANIC during enlargement of a hash index (bug introduced in + 8.1.6). + - Fix POSIX-style timezone specs to follow new USA DST rules. + + -- Martin Pitt Mon, 23 Apr 2007 09:44:15 +0200 + +postgresql-8.1 (8.1.8-0ubuntu6.06.1) dapper-security; urgency=low + + * No-change upload, previous upload got lost in a ssh disconnect. + + -- Martin Pitt Fri, 9 Feb 2007 17:48:55 +0100 + +postgresql-8.1 (8.1.8-0ubuntu6.06) dapper-security; urgency=low + + * Upgraded to new upstream microrelease: + - Fix another overzealous type check. + - Two handfuls of non-security, but important bug fixes. + * Remove the following patches (these were backported from the 8.1.x upstrem + releases): + - 00upstream-disable-update-aggregates.patch + - 00upstream-duration-logging-crash.patch + - 00upstream-max-utf8-wchar-len.patch + - 00upstream-sql-fun-typecheck.patch + - 00upstream-table-plan-consistency.patch + - 00upstream-unknown-array-coerce.patch + - 00upstream-zzz-sql-fun-typecheck-regression.patch + + -- Martin Pitt Fri, 9 Feb 2007 08:59:45 +0100 + +postgresql-8.1 (8.1.4-0ubuntu1.3) dapper-security; urgency=low + + * Add debian/patches/00upstream-zzz-sql-fun-typecheck-regression.patch: Fix + overzealous type checks in some cases. Closes: LP#83505 + + -- Martin Pitt Tue, 6 Feb 2007 18:59:38 +0100 + +postgresql-8.1 (8.1.4-0ubuntu1.2) dapper-security; urgency=low + + * SECURITY UPDATE: Read out arbitrary memory locations from the server, + local DoS. + * Add debian/patches/00upstream-sql-fun-typecheck.patch: + - Repair insufficiently careful type checking for SQL-language functions. + Not only can one trivially crash the backend, but with appropriate + misuse of pass-by-reference datatypes it is possible to read out + arbitrary locations in the server process's memory, which could allow + retrieving database content the user should not be able to see. + - Discovered by Jeff Trout. + - Patch backported from 8.1.7 from CVS: + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/functions.c.diff?r1=1.98.2.2;r2=1.98.2.3 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c.diff?r1=1.201.2.1;r2=1.201.2.2 + - CVE-2007-0555 + * Add debian/patches/00upstream-table-plan-consistency.patch: + - Check that a table is still compatible with a previously made query + plan. Use of ALTER COLUMN TYPE creates a hazard for cached query plans: + they could contain vars that claim a column has a different type than it + now has. Not only can one trivially crash the backend, but with + appropriate misuse of pass-by-reference datatypes it is possible to read + out arbitrary locations in the server process's memory, which could allow + retrieving database content the user should not be able to see. + - Discovered by Jeff Trout. + - Patch backported from 8.1.7 from CVS: + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c.diff?r1=1.174.2.3;r2=1.174.2.4 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execQual.c.diff?r1=1.183.2.4;r2=1.183.2.5 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execScan.c.diff?r1=1.37.2.1;r2=1.37.2.2 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execUtils.c.diff?r1=1.126.2.3;r2=1.126.2.4 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeAgg.c.diff?r1=1.135.2.1;r2=1.135.2.2 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeGroup.c.diff?r1=1.62;r2=1.62.2.1 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeHashjoin.c.diff?r1=1.75.2.3;r2=1.75.2.4 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeMergejoin.c.diff?r1=1.75.2.2;r2=1.75.2.3 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeNestloop.c.diff?r1=1.39.2.1;r2=1.39.2.2 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeResult.c.diff?r1=1.32.2.1;r2=1.32.2.2 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeSubplan.c.diff?r1=1.70.2.1;r2=1.70.2.2 + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/executor.h.diff?r1=1.120.2.2;r2=1.120.2.3 + - CVE-2007-0556 + * Add debian/patches/00upstream-max-utf8-wchar-len.patch: + - Update various string functions to support the maximum UTF-8 sequence + length for 4-byte character set to prevent buffer overflows. + - Patch backported from 8.1.7 from CVS: + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mb/wchar.c.diff?r1=1.47.2.4;r2=1.47.2.5 + + -- Martin Pitt Mon, 5 Feb 2007 09:31:44 +0100 + +postgresql-8.1 (8.1.4-0ubuntu1.1) dapper-security; urgency=low + + * SECURITY UPDATE: Local DoS. + * Add debian/patches/00upstream-disable-update-aggregates.patch: + - Disallow aggregate functions in UPDATE commands (unless within a + sub-SELECT). It is disallowed by the SQL spec and causes crashes. + - Patch backported from 8.1.5: + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/analyze.c.diff?r1=1.326.2.1&r2=1.326.2.2 + - CVE-2006-5540 + * Add debian/patches/00upstream-duration-logging-crash.patch: + - Fix crash in duration logging for a V3-protocol Execute message + when what's being executed is a COMMIT or ROLLBACK. + - Patch backported from 8.1.5: + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/postgres.c.diff?r1=1.468.2.5&r2=1.468.2.6 + - CVE-2006-5542 + * Add debian/patches/00upstream-unknown-array-coerce.patch: + - Repair incorrect check for coercion of unknown literal to ANYARRAY, + which could cause a backend crash. + - Patch backported from 8.1.5: + http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_coerce.c.diff?r1=2.132.2.3&r2=2.132.2.4 + - CVE-2006-5541 + + -- Martin Pitt Mon, 23 Oct 2006 18:21:40 +0200 + +postgresql-8.1 (8.1.4-0ubuntu1) dapper-security; urgency=medium + + * SECURITY UPDATE: Remote arbitrary SQL injection. + * This is based on Debian's 8.1.4-1 plus the shlibs fix from bzr head. + * New upstream security and bug fix release: + - The server now rejects invalidly-encoded multibyte characters in all + cases to defend against SQL-injection attacks. [CVE-2006-2313] + - Reject unsafe uses of \' in string literals (for client encodings that + allow SQL injection with this, like SJIS, BIG5, GBK, GB18030, or UHC). A + new configuration parameter backslash_quote is available to adjust this + behavior when needed. [CVE-2006-2314] + - Modify libpq's string-escaping routines to be aware of encoding + considerations and standard_conforming_strings + This fixes libpq-using applications for the security issues + described in CVE-2006-2313 and CVE-2006-2314, and also + future-proofs them against the planned changeover to SQL-standard + string literal syntax. Applications that use multiple PostgreSQL + connections concurrently should migrate to PQescapeStringConn() and + PQescapeByteaConn() to ensure that escaping is done correctly for + the settings in use in each database connection. Applications that + do string escaping "by hand" should be modified to rely on library + routines instead. + - Various bug fixes, see upstream changelog for details. + * Remove debian/patches/12-krb5-multiusers.patch: Fixed upstream. + * debian/postgresql-8.1.init: Add a comment to point out that environment + variables need to be set in the 'environment' file, not in the init + script. + * debian/postgresql-8.1.init, debian/postgresql-8.1.postinst: Do not fail if + init.d-functions/maintscripts-functions are not present, which happens if + postgresql-{8.1,common} are removed, but not purged. Closes: #362488 + * Bump Standards-Version to 3.7.2. + * Add debian/libpq4.shlibs and bump it to >= 8.1.4, to respect the + introduction of PQescapeStringConn() and PQescapeByteaConn(). + * debian/postgresql-8.1.postrm, clean_dir(): Do not use rmdir's + --ignore-fail-on-nonempty, since that still falls apart when the + directory is a mountpoint. Just ignore errors. + + -- Martin Pitt Thu, 1 Jun 2006 22:38:19 +0200 + +postgresql-8.1 (8.1.3-4) unstable; urgency=low + + * debian/rules: + - Put --as-needed into LDFLAGS instead of CFLAGS to avoid warnings when + building extension modules. Closes: #360759 + - Fix a bashism. + * debian/control: Suggest oidentd | ident-server (oidentd prefered since it + works with IPv6). Closes: #359193 + * libecpg-dev: Move manpage to /usr/share/man/man1 where it belongs to. + Closes: #360817 + * debian/rules: Ship the tutorial's Makefile and ship the SQL *.source files + (not the generated *.sql files) to get the correct path to the built + libraries. Closes: #360469 + * Add debian/patches/13-tutorial-README.patch: Remove confusing note about + make and point out that p-server-dev-8.1 is required for building the + tutorial. + * debian/postgresql-contrib-8.1.install, 50-contrib-oracle-enable.patch: + Move Ora2Pg.pm to /usr/share/postgresql/8.1 and adapt the library search + path in ora2pg.pl accordingly. Closes: #360818 + + -- Martin Pitt Mon, 10 Apr 2006 22:43:11 +0200 + +postgresql-8.1 (8.1.3-3) unstable; urgency=low + + * debian/postgresql-8.1.init: Use shell 'sh -e' instead of bash. + * debian/postgresql-contrib-8.1.install: Ship ora2pg.pl and Ora2Pg.pm. + * debian/control: Updated contrib package description. Closes: #355172 + * debian/rules: Don't special-case HPPA for --enable-thread-safety-force; + the current kernel seems to cope with threads quite well, so that the + configure check does not hang any more. Closes: #315440 + * debian/control: Build server packages on mips and mipsel again, even if + they do not work. No need to block testing migration forever (the + ftp-masters seem reluctant to remove the mips binaries, see #344487), and + the bug is in binutils, not PostgreSQL itself (see #357603). + + -- Martin Pitt Sat, 1 Apr 2006 22:13:03 +0200 + +postgresql-8.1 (8.1.3-2) unstable; urgency=low + + * Re-enable 'do not run as root' check from upstream: + - Move debian/patches/08-disable-root-check.patch to + debian/disable-root-check.patch. + - debian/rules: Move test suite to binary/predeb and apply + disable-root-check.patch manually right before calling the test suite. + Unapply debian/disable-root-check.patch after executing the + test suite to not break subsequent package builds. + - With this, the test suite can happily run as (fake)root during package + build without disabling the check in the actual packages. + * postgresql-doc-8.1: Ship tutorial C and SQL files. + (https://launchpad.net/bugs/30233) + * debian/control, postgresql-client-8.1: Depend on postgresql-client-common + instead of postgresql-common. + + -- Martin Pitt Sat, 18 Mar 2006 15:21:27 +0100 + +postgresql-8.1 (8.1.3-1) unstable; urgency=low + + * New upstream security and bug fix release: + - Fix bug that allowed any logged-in user to "SET ROLE" to any other + database user id (CVE-2006-0553). + - See upstream changelog for detailled changes. + * Remove debian/patches/80-cvs-pg_restore-COPY.patch: Upstream now. + * debian/rules: Use --as-needed linker option to avoid excessive + library dependencies. + * debian/control: Remove unnecessary dependencies from PL/Python and PL/Tcl + packages. + + -- Martin Pitt Tue, 14 Feb 2006 17:46:31 +0100 + +postgresql-8.1 (8.1.2-2) unstable; urgency=low + + * debian/patches/09-relax-sslkey-permscheck.patch: Do not check for any + particular group if the SSL key is group readable, to allow sharing a + common SSL certificate with other server processes. + * debian/control: Add ${shlibs:Depends} to packages which need it. + Closes: #348066 + * debian/control, libecpg5: Remove obsolete Provides/Conflicts to ecpg. + * Add debian/patches/80-cvs-pg_restore-COPY.patch: + - Fix pg_restore to properly discard COPY data when trying to continue + after an error in a COPY statement. Formerly it thought the COPY data + was SQL commands, and got quite confused. + - Patch from Stephen Frost, taken from upstream CVS. + * Add debian/patches/12-krb5-multiusers.patch: + - Fix krb5 credential handling in libpq for multiple connections with + different users: Don't keep credentials in global variables, but pass + them around in a new krb5_info struct. + - Patch from Stephen Frost, proposed to be adopted upstream. + + -- Martin Pitt Mon, 6 Feb 2006 21:07:31 +0100 + +postgresql-8.1 (8.1.2-1) unstable; urgency=medium + + * New upstream bugfix release: + - Fix bug introduced in 8.0 that could allow ReadBuffer to return an + already-used page as new, potentially causing loss of recently-committed + data. + - Fix for protocol-level Describe messages issued outside a + transaction or in a failed transaction. + - Fix character string comparison for locales that consider different + character combinations as equal, such as Hungarian. + This might require "REINDEX" to fix existing indexes on textual + columns. + - Set locale environment variables during postmaster startup to + ensure that plperl won't change the locale later. This fixes a problem + that occurred if the postmaster was started + with environment variables specifying a different locale than what + initdb had been told. Under these conditions, any use of plperl was + likely to lead to corrupt indexes. You may need "REINDEX" to fix + existing indexes on textual columns if this has happened to you. + (postgresql-common checks and aborts on this condition.) + - Allow more flexible relocation of installation directories. + Previous releases supported relocation only if all installation + directory paths were the same except for the last component. + This makes the test suite work with Debian's directory structure, so + that the horology test can find the timezones again and pass. + - Prevent crashes caused by the use of ISO-8859-5 and ISO-8859-9 + encodings. + - Fix longstanding bug in strpos() and regular expression handling in + certain rarely used Asian multi-byte character sets. + - Fix bug where COPY CSV mode considered any \. to terminate the copy + data. The new code requires \. to appear alone on a line, as per + documentation. + - Make COPY CSV mode quote a literal data value of \. to ensure it + cannot be interpreted as the end-of-data marker. + - Various fixes for functions returning RECORDs. + - Fix processing of "postgresql.conf" so a final line with no newline + is processed properly. + - Fix bug in "/contrib/pgcrypto" gen_salt, which caused it not to use + all available salt space for MD5 and XDES algorithms. Salts for + Blowfish and standard DES are unaffected. + - Fix autovacuum crash when processing expression indexes. + - Fix "/contrib/dblink" to throw an error, rather than crashing, when + the number of columns specified is different from what's actually + returned by the query. + * Remove debian/patches/12-readline-prompt-ignore.patch: Adopted upstream. + * Bump postgresql-common dependencies to >= 39. This will ensure more + robust upgrades and other bug fixes. + + -- Martin Pitt Mon, 9 Jan 2006 18:34:31 +0100 + +postgresql-8.1 (8.1.1-2) unstable; urgency=low + + * Do not build postgresql-8.1, p-contrib-8.1, and the PL/ packages on mips + and mipsel, since the postmaster just SIGBUSes on these architectures and + nobody seems to be able to fix that. + * Add debian/patches/12-readline-prompt-ignore.patch: Do not prepend a + '\001' before the 'prompt ignore begin/end' readline commands; this is a + bash quirk, not a readline feature. Thanks to Aaron Schrab. + Closes: #343616 + + -- Martin Pitt Thu, 22 Dec 2005 19:13:21 +0100 + +postgresql-8.1 (8.1.1-1) unstable; urgency=low + + * New upstream bug fix release. + * Remove debian/patches/80_cvs_crash_deform_tuple.patch, upstream now. + * debian/postgresql-8.1.postrm: Also clean start.conf if purging without + pg_dropcluster. + * debian/postgresql-8.1.postrm: Check if a /etc/postgresql/8.1 subdirectory + is really a cluster directory before trying to remove it. Closes: #339810 + * Ship upstream changelog. + + -- Martin Pitt Mon, 12 Dec 2005 17:27:57 +0100 + +postgresql-8.1 (8.1.0-3) unstable; urgency=low + + * debian/rules: Remove superfluous R include path. + * debian/control: Version the libpq-dev dependency of -server-dev-8.1 to + avoid horrible breakage. + * Add debian/patches/80_cvs_crash_deform_tuple.patch: + - Fix crash in tuple deformator (stolen from CVS head). + - Closes: #339527 + * Add debian/patches/52-contrib-dbase-enable-iconv.patch: + - Enable iconv support for 'dbf2pg' contrib module. + - Closes: #338645 + + -- Martin Pitt Sun, 20 Nov 2005 17:01:53 +0100 + +postgresql-8.1 (8.1.0-2) unstable; urgency=low + + * Do not install pg_config and its mo files into postgresql-server-dev-8.1 + any more, since libpq-dev now ships it. Closes: #338231 + * debian/control: Clean up contrib description. Closes: #338308 + + -- Martin Pitt Wed, 9 Nov 2005 20:29:16 -0500 + +postgresql-8.1 (8.1.0-1) unstable; urgency=low + + * Final 8.1.0 upstream release, first unstable upload. + * Build client libraries (-8.0 does not build them any more). + * Add debian/patches/11-server-includedir.patch: Change server include + directory to /usr/include/postgresql/8.1/server since we do want to + keep apart server include files. + + -- Martin Pitt Sat, 5 Nov 2005 18:57:00 -0500 + +postgresql-8.1 (8.0+8.1rc1-1) experimental; urgency=low + + * Upgrade to 8.1rc1 release. + + -- Martin Pitt Mon, 31 Oct 2005 17:43:19 -0500 + +postgresql-8.1 (8.0+8.1beta4-2) experimental; urgency=low + + * Clean up the installation path ./configure arguments. + - debian/rules: Use default libdir /usr/lib. + - Add debian/patches/10-pkglibdir.patch: Set pkglibdir to + /usr/lib/postgresql/8.1/lib instead of /usr/lib/postgresql. + + -- Martin Pitt Wed, 26 Oct 2005 20:45:02 +0100 + +postgresql-8.1 (8.0+8.1beta4-1) experimental; urgency=low + + * Upgrade to 8.1beta4 release. + * Adopt patches to new upstream version: + - 09-relax-sslkey-permscheck.patch + * debian/postgresql-8.1.postrm: clean_dir(): Ensure that directory is not a + symbolic link before attempting to rmdir it. Closes: #333867 + * debian/rules: Remove obsolete --disable-spinlocks build option for mips. + + -- Martin Pitt Mon, 24 Oct 2005 16:59:53 +0200 + +postgresql-8.1 (8.0+8.1beta3-1) experimental; urgency=low + + * Upgrade to 8.1beta3 release. + * Drop debian/patches/81-beta2.patch: beta2->beta3 changes are too big to be + sensibly stuffed into a patch. + * Adopt patches to new upstream version: + - 03-gettext-domains.patch + * Remove patches which are upstream now: + - 52-contrib-dbf2pg-errorcheck.patch + - 53-contrib-dbf2pg-textfield + * debian/patches/09-relax-sslkey-permscheck.patch: Use effective rather than + real group id for checking the private SSL certificate permissions. It + does not make any practical difference, but is more consistent. + * Rename patch 01-top-makefile.patch to 01-build-contrib.patch to give a + better idea of what it does. + + -- Martin Pitt Thu, 13 Oct 2005 18:32:33 +0200 + +postgresql-8.1 (8.0+8.1beta-4) experimental; urgency=low + + * Add debian/patches/09-relax-sslkey-permscheck.patch: + - Relax security check on private SSL key file: The file is also + considered safe if it has owner and/or group "root", and if it is + group-readable (unless the group is something other than root or the + database owner group). + - See bug #327901. + + -- Martin Pitt Wed, 21 Sep 2005 22:52:39 +0200 + +postgresql-8.1 (8.0+8.1beta-3) experimental; urgency=low + + * Add debian/patches/81-beta2.patch: Upgrade to 8.1beta2 release. + * Remove debian/patches/80-s_lock.h-m68k.patch: Included upstream now. + + -- Martin Pitt Mon, 19 Sep 2005 08:31:22 +0200 + +postgresql-8.1 (8.0+8.1beta-2) experimental; urgency=low + + * debian/postgresql-8.1.postrm: Do not remove an empty /var/log/postgresql, + postgresql-common now cares for it to not break log rotation. (See + #325330) + * Remove debian/postgresql-server-dev-8.1.manpages: Do not install the + manpage, since it belongs to libpq-dev (which is currently built by + postgresql-8.0). Closes: #327379 + * debian/postgresql-server-dev-8.1.install: Ship pg_config. + * Build-depend on libpq-dev to pull in libpq4 dependencies for binary + packages. This hack is necessary as long as we build libpq from + postgresql-8.0. Closes: #327765 + + -- Martin Pitt Tue, 13 Sep 2005 22:04:54 +0200 + +postgresql-8.1 (8.0+8.1beta-1) experimental; urgency=low + + * First public beta version. + + -- Martin Pitt Fri, 26 Aug 2005 09:00:47 +0200 + +postgresql-8.1 (8.0+8.1alpha-1) experimental; urgency=low + + * New upstream snapshot release. The first beta is close to be released, and + I want to be prepared for that. + * Package based on postgresql-8.0 8.0.3-13; don't build client libraries yet + until 8.1 final is released. + + -- Martin Pitt Wed, 24 Aug 2005 08:34:00 +0200 + +postgresql-8.0 (8.0.3-13) unstable; urgency=low + + * debian/control: Fix libpq4 description, it is compatible with servers + starting from 7.3. + * Move back client include files to /usr/include/postgresql/ for now to + not render all client packages unbuildable which have not yet converted + to pg_config: + - debian/rules: Configure with include dir /usr/include/postgresql. + - debian/libecpg-dev.install, debian/libpq-dev.install: Install files from + and to /usr/include/postgresql + - Add debian/patches/13_server_includedir.patch: Change server include + directory back to /usr/include/postgresql/8.0/server since we do want to + keep apart server include files. + - Closes: #322085 + * Drop obsolete xml contrib module, build and ship xml2 instead: + - Remove debian/patches/51-contrib-xml-enable.patch + - Add debian/patches/51-contrib-xml2-enable.patch + - debian/control: Add build dependency libxslt1-dev. + - debian/postgresql-contrib-8.0.install: Ship pgxml.so, drop pgxml_dom.so. + - Closes: #322777 + * Add debian/patches/14-mips-gcc4.patch: + - Add a proper test-and-set function for mips and mipsel. Thanks to Thiemo + Seufer for the patch and Aurelien Jarno for his help. This now also + works with gcc 4. + * debian/rules: Remove the --disable-spinlocks option for mips again, now + that we have a proper patch for that. + + -- Martin Pitt Sat, 20 Aug 2005 17:34:01 +0200 + +postgresql-8.0 (8.0.3-12) unstable; urgency=low + + * debian/rules: + - Robustify log output in case of a failed test suite; also print out + regression.diffs if it fails. Closes: #319218 + - Don't run the test suite if DEB_BUILD_OPTIONS contains "nocheck". + * Add debian/check_installed_files to check for upstream installed files + which are not shipped in any deb. + * debian/postgresql-contrib-8.0.install: Ship pgxml_dom.so. Closes: #318922 + + -- Martin Pitt Sun, 24 Jul 2005 17:35:56 +0200 + +postgresql-8.0 (8.0.3-11) unstable; urgency=low + + * Add debian/patches/12-disable-root-check.patch: Disable "am I root" test + in initdb and postmaster to be able to run the test suite at build time. + This check is already done in pg_createcluster. + * debian/rules: Remove all the chown/setuid crack and simply call "make + check" now; print the log files if the test fails. + * debian/patches/10-testsuite-params.patch: Disable authentication in the + test suite db since ident authentication does not work with fakeroot. + + -- Martin Pitt Fri, 15 Jul 2005 13:31:51 +0300 + +postgresql-8.0 (8.0.3-10) unstable; urgency=low + + * debian/rules: If the test suite fails, don't let the build fail but rather + cat the log files. Once the test suite calling works reliably, the + previous behaviour can be restored. + + -- Martin Pitt Thu, 14 Jul 2005 14:19:30 +0300 + +postgresql-8.0 (8.0.3-9) unstable; urgency=low + + * Bump Standards-Version to 3.6.2. + * debian/rules: Use start-stop-daemon instead of su to call the test suite + since su requires a terminal. + * debian/rules: Disable spinlocks on mips and mipsel for now since they + FTBFS with gcc-4.0. + + -- Martin Pitt Wed, 13 Jul 2005 22:22:59 +0300 + +postgresql-8.0 (8.0.3-8) unstable; urgency=low + + * postgresql-client-8.0: Now suggest postgresql-8.0; clarified the + description wrt the server package (see #313247). + * Fix README.Debian symlink. + * Add debian/patches/10-testsuite-params.patch: Use /tmp as the socket + directory when running the test suite. + * debian/rules: Call the test suite when building the package. Since + creating databases as root is not permitted, do this as "nobody" if run by + root (as on the buildds); don't do it at all if run with fakeroot. + + -- Martin Pitt Tue, 12 Jul 2005 19:10:03 +0300 + +postgresql-8.0 (8.0.3-7) unstable; urgency=low + + * Removed some redundant configure options which cdbs applies anyway. + * configure with --enable-thread-safety-force on HPPA since the configure + check triggers a kernel bug on the buildd. (See #315440) + * debian/postgresql-8.0.init: autovac-* functions in postgresql-common were + renamed to autovac_* to comply to POSIX shell standard (see #315551). + Adaped dependencies. + + -- Martin Pitt Sun, 26 Jun 2005 14:23:32 +0200 + +postgresql-8.0 (8.0.3-6) unstable; urgency=low + + * Added debian/postgresql-8.0.links: Symlink README.Debian from + postgresql-common. + * Added debian/patches/08-timezone-inttimestamps.patch (stolen from CVS + head): Fix integer timestamps in time zone handling. + Closes: #249417, #311533. + * debian/rules: Fix POT file generation. + * Added debian/patches/09-libpq-defaultsocketdir.patch: + - Set default socket directory for libpq to /var/run/postgresql. + Closes: #313507, #313602 + * Adjusted packages to follow upstream library SONAME change in 8.0.3: + libecpg4 -> libecpg5, libecpg-compat1 -> libecpg-compat2, + libpgtypes1 -> libpgtypes2. Closes: #313452, #313453, #313454 + + -- Martin Pitt Tue, 14 Jun 2005 19:58:10 +0200 + +postgresql-8.0 (8.0.3-5) unstable; urgency=low + + * debian/rules: Generate POT files to help translators. + * Added debian/libpq-dev.manpages: Install pg_wrapper(1) manpage. + Closes: #311671 + * debian/control: Restrict libpq-dev conflict to postgresql-dev to + versions << 7.5. Closes: #312827 + + -- Martin Pitt Fri, 10 Jun 2005 19:01:20 +0200 + +postgresql-8.0 (8.0.3-4) unstable; urgency=low + + * First unstable upload. + * debian/control: Now build with libreadline5-dev instead of version 4. + + -- Martin Pitt Tue, 7 Jun 2005 12:15:43 +0200 + +postgresql-8.0 (8.0.3-3) experimental; urgency=low + + * Added libpq4 dependency to libpq-dev. + * postgresql-contrib-8.0.install: Correct paths to install missing shared + files and documentation. (Closes: #311553) + * libpq-dev.install: Install some more header files from server/ which are + required by client libraries. + + -- Martin Pitt Mon, 6 Jun 2005 12:24:57 +0200 + +postgresql-8.0 (8.0.3-2) experimental; urgency=low + + * Added CAN numbers to previous changelog entries. + * debian/patches/07-postgresql.conf.patch: Enable listen_addresses = '*' by + default. + * debian/control, libpq-dev: Conflict to and replace postgresql-dev. + + -- Martin Pitt Tue, 31 May 2005 11:09:48 +0200 + +postgresql-8.0 (8.0.3-1) experimental; urgency=low + + * New upstream release: + - Prevent calling conversion functions by users. [CAN-2005-1409] + - Prevent calling tsearch2 functions by users. [CAN-2005-1410] + * debian/libpq-dev.{install,links}: Install pg_config into + /usr/lib/postgresql/8.0/bin to make it print correct paths, and install a + symlink into /usr/bin instead. Closes: #305200 + * debian/rules: Change include dir configure option to + /usr/include/postgresql/8.0, so that different versions of + postgresql-server-dev- do not conflict with each other. Since + applications using the libpq-dev are supposed to use pg_config, this + should not break them either. + + -- Martin Pitt Thu, 12 May 2005 23:37:56 +0200 + +postgresql-8.0 (8.0.2-1) experimental; urgency=low + + * New upstream release: + - Removed debian/patches/02-libpq-soname.patch, upstream adopted SONAME + change to libpq4. + * Ship "reindexdb" in -contrib. + * Added debian/patches/02_pager.patch: Use /usr/bin/pager as default pager + in psql. Closes: #304459 + * Added debian/postgresql-doc-8.0.doc-base: Register doc package in + doc-base. + + -- Martin Pitt Tue, 19 Apr 2005 21:19:50 +1000 + +postgresql-8.0 (8.0.1-4) experimental; urgency=low + + * Ship pg_config in libpq-dev instead of postgresql-8.0; added + proper package conflict. Closes: #303257 + * Install pg_config in /usr/bin instead of 8.0-specific bin dir. + Closes: #302368 + * debian/postgresql-8.0.init: Added autovacuum functions. + + -- Martin Pitt Tue, 5 Apr 2005 23:15:31 +0200 + +postgresql-8.0 (8.0.1-3) experimental; urgency=low + + * Dropped pgxs package, the Makefiles are now part of postgresql-server-dev. + * -contrib: Only recommend, not depend on libpg-perl and libdbd-pg-perl. + * Renamed packages pg-pl*-8.0 to postgresql-pl*-8.0 for consistency. + * Added debian/patches/07-postgresql.conf.patch: + - Patch for Debian changes to the default configuration. + - Enable stats_row_level to allow pg_autovacuum to work. + + -- Martin Pitt Sat, 2 Apr 2005 18:21:57 +0200 + +postgresql-8.0 (8.0.1-2) experimental; urgency=low + + * Changed dependency of pg-pltcl-8.0 from libtcl8.4 to tcl8.4 + * Now depend on postgresql-common >= 3 which provides more maintainer script + functions. + * Compress manpages. + + -- Martin Pitt Sun, 20 Mar 2005 21:23:10 +0100 + +postgresql-8.0 (8.0.1-1) experimental; urgency=low + + * New upstream release. Closes: #274043, #291350 + - Ignores shell backticks with invalid meta-commands. Closes: #285844 + - Fixes uninitialized error strings when connecting to a server which is + down. Closes: #264603, #277757 + - configure script supports GNU/Hurd and GNU/k*BSD. Closes: #262081 + - Fixes comma splices in HTML documentation. Closes: #243781 + - Now upper() and lower() work also for Unicode characters. + Closes: #139389, #290118, #290399 + - New configuration variable max_stack_depth which prevents DoS situations + due to infinite recursion. Closes: #239811 + - Reportedly works with Turkish locale. Closes: #305886 + - This version is not vulnerable against the following security issues: + . Load arbitrary shared libs, execute startup function [CAN-2005-0227] + . Execute functions with aggregate wrapper [CAN-2005-0244] + . Buffer overflow and 64-bit issues in contrib/intagg [CAN-2005-0246] + . Buffer overflows in the PL/PGSQL parser in gram.y [CAN-2005-0247] + . Insecure temporary files in make_oidjoins_check [CAN-2004-0977] + * Splitted development package into libpq-dev and postgresql-server-dev. + Closes: #280417 + * Splitted libecpg4 into libecpg4, libecpg-compat1 and libpgtypes1. + * Old libpgtcl package does not exist any more. The PL/TCL procedural + language is now shipped in pg-pltcl8.0, the TCL client library is not + shipped by PostgreSQL any more. Closes: #280418 + * Now use /var/lib/postgresql/ as (default) data directory. Closes: #285929 + + -- Martin Pitt Sun, 20 Feb 2005 19:17:17 +0100 + --- postgresql-8.1-8.1.23.orig/debian/disable-root-check.patch +++ postgresql-8.1-8.1.23/debian/disable-root-check.patch @@ -0,0 +1,36 @@ +diff -ruN postgresql-8.1.3-old/src/backend/main/main.c postgresql-8.1.3/src/backend/main/main.c +--- postgresql-8.1.3-old/src/backend/main/main.c 2005-07-15 14:04:23.000000000 +0300 ++++ postgresql-8.1.3/src/backend/main/main.c 2005-07-15 14:04:33.000000000 +0300 +@@ -204,7 +204,7 @@ + strcmp(argv[1], "-V") == 0))) + { + #ifndef WIN32 +-#ifndef __BEOS__ ++#if 0 + + /* + * Make sure we are not running as root. +diff -ruN postgresql-8.1.3-old/src/bin/initdb/initdb.c postgresql-8.1.3/src/bin/initdb/initdb.c +--- postgresql-8.1.3-old/src/bin/initdb/initdb.c 2005-07-15 14:04:23.000000000 +0300 ++++ postgresql-8.1.3/src/bin/initdb/initdb.c 2005-07-15 14:04:33.000000000 +0300 +@@ -627,7 +627,7 @@ + + pw = getpwuid(geteuid()); + +-#ifndef __BEOS__ /* no root check on BEOS */ ++#if 0 + + if (geteuid() == 0) /* 0 is root's uid */ + { +diff -ruN postgresql-8.1.3-old/src/bin/pg_ctl/pg_ctl.c postgresql-8.1.3/src/bin/pg_ctl/pg_ctl.c +--- postgresql-8.1.3-old/src/bin/pg_ctl/pg_ctl.c 2005-07-15 14:04:23.000000000 +0300 ++++ postgresql-8.1.3/src/bin/pg_ctl/pg_ctl.c 2005-07-15 14:08:38.100000000 +0300 +@@ -1319,7 +1319,7 @@ + * Disallow running as root, to forestall any possible security holes. + */ + #ifndef WIN32 +-#ifndef __BEOS__ /* no root check on BEOS */ ++#if 0 + if (geteuid() == 0) + { + write_stderr(_("%s: cannot be run as root\n" --- postgresql-8.1-8.1.23.orig/debian/postgresql-pltcl-8.1.install +++ postgresql-8.1-8.1.23/debian/postgresql-pltcl-8.1.install @@ -0,0 +1,3 @@ +usr/lib/postgresql/8.1/lib/pltcl.so +usr/lib/postgresql/8.1/bin/pltcl_* +usr/share/postgresql/8.1/unknown.pltcl --- postgresql-8.1-8.1.23.orig/debian/libecpg-dev.install +++ postgresql-8.1-8.1.23/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.1/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.1-8.1.23.orig/debian/postgresql-8.1.init +++ postgresql-8.1-8.1.23/debian/postgresql-8.1.init @@ -0,0 +1,44 @@ +#!/bin/sh -e + +# Setting environment variables for the postmaster here does not work; please +# set them in /etc/postgresql/8.1//environment instead. + +[ -r /usr/share/postgresql-common/init.d-functions ] || exit 0 + +. /usr/share/postgresql-common/init.d-functions + +VERSION=8.1 + +case "$1" in + start) + start $VERSION + ;; + stop) + stop "$VERSION" + ;; + restart) + restart "$VERSION" + ;; + force-reload | reload) + reload $VERSION + ;; + status) + status $VERSION + ;; + autovac-start) + autovac_start $VERSION + ;; + autovac-stop) + autovac_stop $VERSION + ;; + autovac-restart) + autovac_restart $VERSION + ;; + *) + echo "Usage: $0 {start|stop|restart|reload|force-reload|status|autovac-start|autovac-stop|autovac-restart}" + exit 1 + ;; +esac + +exit 0 + --- postgresql-8.1-8.1.23.orig/debian/libpq-dev.links +++ postgresql-8.1-8.1.23/debian/libpq-dev.links @@ -0,0 +1 @@ +/usr/lib/postgresql/8.1/bin/pg_config /usr/bin/pg_config --- postgresql-8.1-8.1.23.orig/debian/libpq4.install +++ postgresql-8.1-8.1.23/debian/libpq4.install @@ -0,0 +1,2 @@ +usr/lib/libpq.so.4* +usr/share/locale/*/LC_MESSAGES/libpq4.mo --- postgresql-8.1-8.1.23.orig/debian/postgresql-plperl-8.1.install +++ postgresql-8.1-8.1.23/debian/postgresql-plperl-8.1.install @@ -0,0 +1 @@ +usr/lib/postgresql/8.1/lib/plperl.so --- postgresql-8.1-8.1.23.orig/debian/postgresql-8.1.prerm +++ postgresql-8.1-8.1.23/debian/postgresql-8.1.prerm @@ -0,0 +1,11 @@ +#!/bin/sh -e + +VERSION=8.1 + +#DEBHELPER# + +if [ "$1" = remove ]; then + . /usr/share/postgresql-common/maintscripts-functions + remove_version $VERSION +fi + --- postgresql-8.1-8.1.23.orig/debian/postgresql-doc-8.1.dirs +++ postgresql-8.1-8.1.23/debian/postgresql-doc-8.1.dirs @@ -0,0 +1 @@ +/usr/share/doc/postgresql-doc-8.1/tutorial --- postgresql-8.1-8.1.23.orig/debian/copyright +++ postgresql-8.1-8.1.23/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.1-8.1.23.orig/debian/postgresql-8.1.install +++ postgresql-8.1-8.1.23/debian/postgresql-8.1.install @@ -0,0 +1,27 @@ +usr/lib/postgresql/8.1/bin/initdb +usr/lib/postgresql/8.1/bin/ipcclean +usr/lib/postgresql/8.1/bin/pg_controldata +usr/lib/postgresql/8.1/bin/pg_ctl +usr/lib/postgresql/8.1/bin/pg_resetxlog +usr/lib/postgresql/8.1/bin/postgres +usr/lib/postgresql/8.1/bin/postmaster +usr/lib/postgresql/8.1/lib/*_and_*.so +usr/lib/postgresql/8.1/lib/plpgsql.so +usr/share/locale/*/LC_MESSAGES/initdb-8.1.mo +usr/share/locale/*/LC_MESSAGES/pg_controldata-8.1.mo +usr/share/locale/*/LC_MESSAGES/pg_ctl-8.1.mo +usr/share/locale/*/LC_MESSAGES/pg_resetxlog-8.1.mo +usr/share/locale/*/LC_MESSAGES/postgres-8.1.mo +usr/share/postgresql/8.1/man/man1/initdb.1 +usr/share/postgresql/8.1/man/man1/ipcclean.1 +usr/share/postgresql/8.1/man/man1/pg_controldata.1 +usr/share/postgresql/8.1/man/man1/pg_ctl.1 +usr/share/postgresql/8.1/man/man1/pg_resetxlog.1 +usr/share/postgresql/8.1/man/man1/postgres.1 +usr/share/postgresql/8.1/man/man1/postmaster.1 +usr/share/postgresql/8.1/timezone +usr/share/postgresql/8.1/*.sql +usr/share/postgresql/8.1/*.conf.sample +usr/share/postgresql/8.1/postgres.bki +usr/share/postgresql/8.1/postgres.description +usr/share/postgresql/8.1/sql_features.txt --- postgresql-8.1-8.1.23.orig/debian/libecpg5.install +++ postgresql-8.1-8.1.23/debian/libecpg5.install @@ -0,0 +1 @@ +usr/lib/libecpg.so.5* --- postgresql-8.1-8.1.23.orig/debian/patches/01-build-contrib.patch +++ postgresql-8.1-8.1.23/debian/patches/01-build-contrib.patch @@ -0,0 +1,37 @@ +diff -ruN postgresql-8.1.0rc2-old/GNUmakefile.in postgresql-8.1.0rc2/GNUmakefile.in +--- postgresql-8.1.0rc2-old/GNUmakefile.in 2004-10-06 10:49:58.100000000 +0200 ++++ postgresql-8.1.0rc2/GNUmakefile.in 2004-11-20 23:16:40.505472992 +0200 +@@ -4,6 +4,8 @@ + # $PostgreSQL: pgsql/GNUmakefile.in,v 1.41 2004/10/06 08:49:58 momjian Exp $ + # + ++# For Debian, we also build contrib ++ + subdir = + top_builddir = . + include $(top_builddir)/src/Makefile.global +@@ -12,21 +14,22 @@ + $(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 distprep: + $(MAKE) -C doc $@ + $(MAKE) -C src $@ + $(MAKE) -C config $@ ++ $(MAKE) -C contrib $@ + +-# clean, distclean, etc should apply to contrib too, even though +-# it's not built by default + clean: + $(MAKE) -C doc $@ + $(MAKE) -C contrib $@ --- postgresql-8.1-8.1.23.orig/debian/patches/10-pkglibdir.patch +++ postgresql-8.1-8.1.23/debian/patches/10-pkglibdir.patch @@ -0,0 +1,12 @@ +diff -ruN postgresql-8.1beta4-old/src/Makefile.global.in postgresql-8.1beta4/src/Makefile.global.in +--- postgresql-8.1beta4-old/src/Makefile.global.in 2005-09-27 18:39:32.000000000 +0100 ++++ postgresql-8.1beta4/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.1/lib + endif + endif + --- postgresql-8.1-8.1.23.orig/debian/patches/11-server-includedir.patch +++ postgresql-8.1-8.1.23/debian/patches/11-server-includedir.patch @@ -0,0 +1,12 @@ +diff -ruN postgresql-8.1.0-old/src/Makefile.global.in postgresql-8.1.0/src/Makefile.global.in +--- postgresql-8.1.0-old/src/Makefile.global.in 2005-11-05 18:54:55.000000000 -0500 ++++ postgresql-8.1.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.1/server + includedir_internal = $(pkgincludedir)/internal + pgxsdir = $(pkglibdir)/pgxs + --- postgresql-8.1-8.1.23.orig/debian/patches/14-intarray_query_int_buffer_overrun.patch +++ postgresql-8.1-8.1.23/debian/patches/14-intarray_query_int_buffer_overrun.patch @@ -0,0 +1,77 @@ +commit e11349fdbae7295b91699a70a791c093fc6d254e +Author: Tom Lane +Date: Thu Jan 27 17:42:00 2011 -0500 + + Prevent buffer overrun while parsing an integer in a "query_int" value. + + contrib/intarray's gettoken() uses a fixed-size buffer to collect an + integer's digits, and did not guard against overrunning the buffer. + This is at least a backend crash risk, and in principle might allow + arbitrary code execution. The code didn't check for overflow of the + integer value either, which while not presenting a crash risk was still + bad. + + Thanks to Apple Inc's security team for reporting this issue and supplying + the fix. + + Security: CVE-2010-4015 + +diff --git a/contrib/intarray/_int_bool.c b/contrib/intarray/_int_bool.c +index 64c8e00..209c4d9 100644 +--- a/contrib/intarray/_int_bool.c ++++ b/contrib/intarray/_int_bool.c +@@ -55,24 +55,25 @@ typedef struct + static int4 + gettoken(WORKSTATE * state, int4 *val) + { +- char nnn[16], +- *curnnn; ++ char nnn[16]; ++ int innn; + + *val = 0; /* default result */ + +- curnnn = nnn; ++ innn = 0; + while (1) + { ++ if (innn >= sizeof(nnn)) ++ return ERR; /* buffer overrun => syntax error */ + switch (state->state) + { + case WAITOPERAND: +- curnnn = nnn; ++ innn = 0; + if ((*(state->buf) >= '0' && *(state->buf) <= '9') || + *(state->buf) == '-') + { + state->state = WAITENDOPERAND; +- *curnnn = *(state->buf); +- curnnn++; ++ nnn[innn++] = *(state->buf); + } + else if (*(state->buf) == '!') + { +@@ -92,13 +93,18 @@ gettoken(WORKSTATE * state, int4 *val) + case WAITENDOPERAND: + if (*(state->buf) >= '0' && *(state->buf) <= '9') + { +- *curnnn = *(state->buf); +- curnnn++; ++ nnn[innn++] = *(state->buf); + } + else + { +- *curnnn = '\0'; +- *val = (int4) atoi(nnn); ++ long lval; ++ ++ nnn[innn] = '\0'; ++ errno = 0; ++ lval = strtol(nnn, NULL, 0); ++ *val = (int4) lval; ++ if (errno != 0 || (long) *val != lval) ++ return ERR; + state->state = WAITOPERATOR; + return (state->count && *(state->buf) == '\0') + ? ERR : VAL; --- postgresql-8.1-8.1.23.orig/debian/patches/06-libpq-defaultsocketdir.patch +++ postgresql-8.1-8.1.23/debian/patches/06-libpq-defaultsocketdir.patch @@ -0,0 +1,12 @@ +diff -ruN postgresql-8.1.3-old/src/include/pg_config_manual.h postgresql-8.1.3/src/include/pg_config_manual.h +--- postgresql-8.1.3-old/src/include/pg_config_manual.h 2004-09-10 16:27:37.000000000 +0200 ++++ postgresql-8.1.3/src/include/pg_config_manual.h 2005-06-14 19:21:28.100000000 +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.1-8.1.23.orig/debian/patches/04-timezone-symlinks.patch +++ postgresql-8.1-8.1.23/debian/patches/04-timezone-symlinks.patch @@ -0,0 +1,12 @@ +diff -Nur -x '*.orig' -x '*~' postgresql-8.1-8.1.10/build-tree/postgresql-8.1.10/src/timezone/Makefile postgresql-8.1-8.1.10.new/build-tree/postgresql-8.1.10/src/timezone/Makefile +--- postgresql-8.1.10/src/timezone/Makefile 2007-03-14 18:38:22.000000000 +0100 ++++ postgresql-8.1.10/src/timezone/Makefile 2008-01-04 13:30:24.000000000 +0100 +@@ -38,7 +38,7 @@ + $(CC) $(CFLAGS) $(ZICOBJS) $(LDFLAGS) $(LIBS) -o $@$(X) + + install: all installdirs +- ./zic -d $(DESTDIR)$(datadir)/timezone -p $(POSIXRULES) $(TZDATAFILES) ++ ln -s /usr/share/zoneinfo '$(DESTDIR)$(datadir)/timezone' + + installdirs: + $(mkinstalldirs) $(DESTDIR)$(datadir) --- postgresql-8.1-8.1.23.orig/debian/patches/52-contrib-dbase-enable-iconv.patch +++ postgresql-8.1-8.1.23/debian/patches/52-contrib-dbase-enable-iconv.patch @@ -0,0 +1,12 @@ +diff -ruN postgresql-8.1.0-old/contrib/dbase/Makefile postgresql-8.1.0/contrib/dbase/Makefile +--- postgresql-8.1.0-old/contrib/dbase/Makefile 2005-09-27 19:13:01.000000000 +0200 ++++ postgresql-8.1.0/contrib/dbase/Makefile 2005-11-20 16:28:57.000000000 +0100 +@@ -6,7 +6,7 @@ + PG_LIBS = $(libpq_pgport) + + # Uncomment this to provide charset translation +-#PG_CPPFLAGS += -DHAVE_ICONV_H ++PG_CPPFLAGS += -DHAVE_ICONV_H + # You might need to uncomment this too, if libiconv is a separate + # library on your platform + #PG_LIBS += -liconv --- postgresql-8.1-8.1.23.orig/debian/patches/02-pager.patch +++ postgresql-8.1-8.1.23/debian/patches/02-pager.patch @@ -0,0 +1,12 @@ +diff -ruN postgresql-8.1.2-old/src/bin/psql/print.h postgresql-8.1.2/src/bin/psql/print.h +--- postgresql-8.1.2-old/src/bin/psql/print.h 2005-01-01 16:43:08.100000000 +1100 ++++ postgresql-8.1.2/src/bin/psql/print.h 2005-04-19 20:40:08.166917424 +1000 +@@ -81,7 +81,7 @@ + void printQuery(const PGresult *result, const printQueryOpt *opt, FILE *fout); + + #ifndef __CYGWIN__ +-#define DEFAULT_PAGER "more" ++#define DEFAULT_PAGER "/usr/bin/pager" + #else + #define DEFAULT_PAGER "less" + #endif --- postgresql-8.1-8.1.23.orig/debian/patches/13-tutorial-README.patch +++ postgresql-8.1-8.1.23/debian/patches/13-tutorial-README.patch @@ -0,0 +1,13 @@ +diff -ruN postgresql-8.1.3-old/src/tutorial/README postgresql-8.1.3/src/tutorial/README +--- postgresql-8.1.3-old/src/tutorial/README 2001-10-26 22:45:33.000000000 +0200 ++++ postgresql-8.1.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.1 to be installed. + + Then, run psql with the -s (single-step) flag: + % psql -s --- postgresql-8.1-8.1.23.orig/debian/patches/05-check-rlimits-nofile.patch +++ postgresql-8.1-8.1.23/debian/patches/05-check-rlimits-nofile.patch @@ -0,0 +1,33 @@ +diff -ruN postgresql-snapshot-old/src/backend/storage/file/fd.c postgresql-snapshot/src/backend/storage/file/fd.c +--- postgresql-snapshot-old/src/backend/storage/file/fd.c 2005-08-08 05:11:49.000000000 +0200 ++++ postgresql-snapshot/src/backend/storage/file/fd.c 2005-08-22 19:21:42.000000000 +0200 +@@ -51,6 +51,7 @@ + #include "storage/fd.h" + #include "storage/ipc.h" + ++#include + + /* + * We must leave some file descriptors free for system(), the dynamic loader, +@@ -343,15 +344,21 @@ + int used = 0; + int highestfd = 0; + int j; ++ struct rlimit rlim; + + size = 1024; + fd = (int *) palloc(size * sizeof(int)); ++ getrlimit(RLIMIT_NOFILE, &rlim); + + /* dup until failure or probe limit reached */ + for (;;) + { + int thisfd; + ++ /* Don't go beyond RLIMIT_NOFILE */ ++ if (highestfd >= rlim.rlim_cur - 1) ++ break; ++ + thisfd = dup(0); + if (thisfd < 0) + { --- postgresql-8.1-8.1.23.orig/debian/patches/50-contrib-oracle-enable.patch +++ postgresql-8.1-8.1.23/debian/patches/50-contrib-oracle-enable.patch @@ -0,0 +1,45 @@ +diff -ruN postgresql-8.1.3-old/contrib/Makefile postgresql-8.1.3/contrib/Makefile +--- postgresql-8.1.3-old/contrib/Makefile 2005-09-02 00:02:44.000000000 +0200 ++++ postgresql-8.1.3/contrib/Makefile 2006-04-10 22:41:29.000000000 +0200 +@@ -20,6 +20,7 @@ + lo \ + ltree \ + oid2name \ ++ oracle \ + pg_buffercache \ + pg_trgm \ + pgbench \ +@@ -37,7 +38,6 @@ + # adddepend \ (does not have a makefile) + # mSQL-interface \ (requires msql installed) + # mac \ (does not have a makefile) +-# oracle \ (does not have a makefile) + # start-scripts \ (does not have a makefile) + # xml2 \ (requires libxml installed) + +diff -ruN postgresql-8.1.3-old/contrib/oracle/Makefile postgresql-8.1.3/contrib/oracle/Makefile +--- postgresql-8.1.3-old/contrib/oracle/Makefile 1970-01-01 01:00:00.000000000 +0100 ++++ postgresql-8.1.3/contrib/oracle/Makefile 2006-04-10 22:41:29.000000000 +0200 +@@ -0,0 +1,11 @@ ++# oracle conversion Perl scripts ++ ++subdir = contrib/oracle ++top_builddir = ../.. ++include $(top_builddir)/src/Makefile.global ++ ++MODULES = ++SCRIPTS = Ora2Pg.pm ora2pg.pl ++DOCS = README.ora2pg ++ ++include $(top_srcdir)/contrib/contrib-global.mk +diff -ruN postgresql-8.1.3-old/contrib/oracle/ora2pg.pl postgresql-8.1.3/contrib/oracle/ora2pg.pl +--- postgresql-8.1.3-old/contrib/oracle/ora2pg.pl 2003-01-07 23:17:14.000000000 +0100 ++++ postgresql-8.1.3/contrib/oracle/ora2pg.pl 2006-04-10 22:42:04.000000000 +0200 +@@ -17,6 +17,7 @@ + + use strict; + ++use lib '/usr/share/postgresql/8.1/contrib'; + use Ora2Pg; + + # Initialyze the database connection --- postgresql-8.1-8.1.23.orig/debian/patches/03-gettext-domains.patch +++ postgresql-8.1-8.1.23/debian/patches/03-gettext-domains.patch @@ -0,0 +1,340 @@ +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/backend/main/main.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/backend/main/main.c +--- postgresql-8.1.15/src/backend/main/main.c 2006-02-01 01:32:05.000000000 +0100 ++++ postgresql-8.1.15/src/backend/main/main.c 2008-11-04 21:19:41.000000000 +0100 +@@ -152,7 +152,7 @@ + * error messages to be localized. + */ + +- set_pglocale_pgservice(argv[0], "postgres"); ++ set_pglocale_pgservice(argv[0], "postgres-8.1"); + + #ifdef WIN32 + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/backend/nls.mk postgresql-8.1.new/build-tree/postgresql-8.1.15/src/backend/nls.mk +--- postgresql-8.1.15/src/backend/nls.mk 2008-10-27 20:37:42.000000000 +0100 ++++ postgresql-8.1.15/src/backend/nls.mk 2008-11-04 21:20:13.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/backend/nls.mk,v 1.20.2.1 2008/10/27 19:37:42 tgl Exp $ +-CATALOG_NAME := postgres ++CATALOG_NAME := postgres-8.1 + AVAIL_LANGUAGES := af cs de es fr hr hu it ko nb pt_BR ro ru sk sl sv tr zh_CN zh_TW + GETTEXT_FILES := + gettext-files + GETTEXT_TRIGGERS:= _ errmsg errdetail errhint errcontext write_stderr yyerror +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/initdb/initdb.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/initdb/initdb.c +--- postgresql-8.1.15/src/bin/initdb/initdb.c 2006-05-27 20:07:22.000000000 +0200 ++++ postgresql-8.1.15/src/bin/initdb/initdb.c 2008-11-04 21:19:41.000000000 +0100 +@@ -2232,7 +2232,7 @@ + }; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "initdb"); ++ set_pglocale_pgservice(argv[0], "initdb-8.1"); + + if (argc > 1) + { +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/initdb/nls.mk postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/initdb/nls.mk +--- postgresql-8.1.15/src/bin/initdb/nls.mk 2005-01-09 18:38:18.000000000 +0100 ++++ postgresql-8.1.15/src/bin/initdb/nls.mk 2008-11-04 21:19:41.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/initdb/nls.mk,v 1.18 2005/01/09 17:38:18 petere Exp $ +-CATALOG_NAME := initdb ++CATALOG_NAME := initdb-8.1 + AVAIL_LANGUAGES := cs de es fr it ko pl pt_BR ro ru sk sl sv tr zh_CN zh_TW + GETTEXT_FILES := initdb.c ../../port/dirmod.c ../../port/exec.c + GETTEXT_TRIGGERS:= _ simple_prompt +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_config/nls.mk postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_config/nls.mk +--- postgresql-8.1.15/src/bin/pg_config/nls.mk 2005-01-09 18:38:19.000000000 +0100 ++++ postgresql-8.1.15/src/bin/pg_config/nls.mk 2008-11-04 21:19:41.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/pg_config/nls.mk,v 1.15 2005/01/09 17:38:19 petere Exp $ +-CATALOG_NAME := pg_config ++CATALOG_NAME := pg_config-8.1 + AVAIL_LANGUAGES := cs de es fr ko pl pt_BR ro ru sl sv tr zh_CN zh_TW + GETTEXT_FILES := pg_config.c ../../port/exec.c + GETTEXT_TRIGGERS:= _ +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_config/pg_config.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_config/pg_config.c +--- postgresql-8.1.15/src/bin/pg_config/pg_config.c 2006-06-07 14:19:37.000000000 +0200 ++++ postgresql-8.1.15/src/bin/pg_config/pg_config.c 2008-11-04 21:19:41.000000000 +0100 +@@ -451,7 +451,7 @@ + int j; + int ret; + +- set_pglocale_pgservice(argv[0], "pg_config"); ++ set_pglocale_pgservice(argv[0], "pg_config-8.1"); + + progname = get_progname(argv[0]); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_controldata/nls.mk postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_controldata/nls.mk +--- postgresql-8.1.15/src/bin/pg_controldata/nls.mk 2005-01-14 09:57:05.000000000 +0100 ++++ postgresql-8.1.15/src/bin/pg_controldata/nls.mk 2008-11-04 21:19:41.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/pg_controldata/nls.mk,v 1.16 2005/01/14 08:57:05 petere Exp $ +-CATALOG_NAME := pg_controldata ++CATALOG_NAME := pg_controldata-8.1 + AVAIL_LANGUAGES := cs de es fa fr hu it ko nb pl pt_BR ro ru sk sl sv tr zh_CN zh_TW + GETTEXT_FILES := pg_controldata.c + GETTEXT_TRIGGERS:= _ +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_controldata/pg_controldata.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_controldata/pg_controldata.c +--- postgresql-8.1.15/src/bin/pg_controldata/pg_controldata.c 2005-10-15 04:49:37.000000000 +0200 ++++ postgresql-8.1.15/src/bin/pg_controldata/pg_controldata.c 2008-11-04 21:19:41.000000000 +0100 +@@ -73,7 +73,7 @@ + char *strftime_fmt = "%c"; + const char *progname; + +- set_pglocale_pgservice(argv[0], "pg_controldata"); ++ set_pglocale_pgservice(argv[0], "pg_controldata-8.1"); + + progname = get_progname(argv[0]); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_ctl/nls.mk postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_ctl/nls.mk +--- postgresql-8.1.15/src/bin/pg_ctl/nls.mk 2004-12-16 12:27:41.000000000 +0100 ++++ postgresql-8.1.15/src/bin/pg_ctl/nls.mk 2008-11-04 21:19:41.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/pg_ctl/nls.mk,v 1.15 2004/12/16 11:27:41 petere Exp $ +-CATALOG_NAME := pg_ctl ++CATALOG_NAME := pg_ctl-8.1 + AVAIL_LANGUAGES := cs de es fr ko pt_BR ro ru sk sl sv tr zh_CN zh_TW + GETTEXT_FILES := pg_ctl.c ../../port/exec.c + GETTEXT_TRIGGERS:= _ simple_prompt +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_ctl/pg_ctl.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_ctl/pg_ctl.c +--- postgresql-8.1.15/src/bin/pg_ctl/pg_ctl.c 2008-09-30 15:14:21.000000000 +0200 ++++ postgresql-8.1.15/src/bin/pg_ctl/pg_ctl.c 2008-11-04 21:19:41.000000000 +0100 +@@ -1324,7 +1324,7 @@ + #endif + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pg_ctl"); ++ set_pglocale_pgservice(argv[0], "pg_ctl-8.1"); + + /* + * save argv[0] so do_start() can look for the postmaster if necessary. we +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_dump/nls.mk postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_dump/nls.mk +--- postgresql-8.1.15/src/bin/pg_dump/nls.mk 2005-01-25 18:32:00.000000000 +0100 ++++ postgresql-8.1.15/src/bin/pg_dump/nls.mk 2008-11-04 21:19:41.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/pg_dump/nls.mk,v 1.19 2005/01/25 17:32:00 petere Exp $ +-CATALOG_NAME := pg_dump ++CATALOG_NAME := pg_dump-8.1 + AVAIL_LANGUAGES := cs de es fr it ko nb pt_BR ro ru sk sl sv tr zh_CN zh_TW + GETTEXT_FILES := pg_dump.c common.c pg_backup_archiver.c pg_backup_custom.c \ + pg_backup_db.c pg_backup_files.c pg_backup_null.c \ +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_dump/pg_dumpall.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_dump/pg_dumpall.c +--- postgresql-8.1.15/src/bin/pg_dump/pg_dumpall.c 2007-05-15 22:20:29.000000000 +0200 ++++ postgresql-8.1.15/src/bin/pg_dump/pg_dumpall.c 2008-11-04 21:19:41.000000000 +0100 +@@ -120,7 +120,7 @@ + + int optindex; + +- set_pglocale_pgservice(argv[0], "pg_dump"); ++ set_pglocale_pgservice(argv[0], "pg_dump-8.1"); + + progname = get_progname(argv[0]); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_dump/pg_dump.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_dump/pg_dump.c +--- postgresql-8.1.15/src/bin/pg_dump/pg_dump.c 2006-06-09 21:46:17.000000000 +0200 ++++ postgresql-8.1.15/src/bin/pg_dump/pg_dump.c 2008-11-04 21:19:41.000000000 +0100 +@@ -250,7 +250,7 @@ + }; + int optindex; + +- set_pglocale_pgservice(argv[0], "pg_dump"); ++ set_pglocale_pgservice(argv[0], "pg_dump-8.1"); + + g_verbose = false; + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_dump/pg_restore.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_dump/pg_restore.c +--- postgresql-8.1.15/src/bin/pg_dump/pg_restore.c 2006-04-13 00:19:01.000000000 +0200 ++++ postgresql-8.1.15/src/bin/pg_dump/pg_restore.c 2008-11-04 21:19:41.000000000 +0100 +@@ -122,7 +122,7 @@ + {NULL, 0, NULL, 0} + }; + +- set_pglocale_pgservice(argv[0], "pg_dump"); ++ set_pglocale_pgservice(argv[0], "pg_dump-8.1"); + + opts = NewRestoreOptions(); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_resetxlog/nls.mk postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_resetxlog/nls.mk +--- postgresql-8.1.15/src/bin/pg_resetxlog/nls.mk 2004-12-16 12:27:42.000000000 +0100 ++++ postgresql-8.1.15/src/bin/pg_resetxlog/nls.mk 2008-11-04 21:19:41.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/pg_resetxlog/nls.mk,v 1.17 2004/12/16 11:27:42 petere Exp $ +-CATALOG_NAME := pg_resetxlog ++CATALOG_NAME := pg_resetxlog-8.1 + AVAIL_LANGUAGES := cs de es fr hu it ko nb pt_BR ro ru sk sl sv tr zh_CN zh_TW + GETTEXT_FILES := pg_resetxlog.c + GETTEXT_TRIGGERS:= _ +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/pg_resetxlog/pg_resetxlog.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/pg_resetxlog/pg_resetxlog.c +--- postgresql-8.1.15/src/bin/pg_resetxlog/pg_resetxlog.c 2005-10-15 04:49:40.000000000 +0200 ++++ postgresql-8.1.15/src/bin/pg_resetxlog/pg_resetxlog.c 2008-11-04 21:19:41.000000000 +0100 +@@ -85,7 +85,7 @@ + int fd; + char path[MAXPGPATH]; + +- set_pglocale_pgservice(argv[0], "pg_resetxlog"); ++ set_pglocale_pgservice(argv[0], "pg_resetxlog-8.1"); + + progname = get_progname(argv[0]); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/psql/nls.mk postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/psql/nls.mk +--- postgresql-8.1.15/src/bin/psql/nls.mk 2004-12-13 17:30:48.000000000 +0100 ++++ postgresql-8.1.15/src/bin/psql/nls.mk 2008-11-04 21:19:41.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/psql/nls.mk,v 1.21 2004/12/13 16:30:48 petere Exp $ +-CATALOG_NAME := psql ++CATALOG_NAME := psql-8.1 + AVAIL_LANGUAGES := cs de es fa fr hu it ko nb pt_BR ro ru sk sl sv tr zh_CN zh_TW + GETTEXT_FILES := command.c common.c copy.c help.c input.c large_obj.c \ + mainloop.c print.c startup.c describe.c sql_help.h \ +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/psql/startup.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/psql/startup.c +--- postgresql-8.1.15/src/bin/psql/startup.c 2005-11-22 19:23:27.000000000 +0100 ++++ postgresql-8.1.15/src/bin/psql/startup.c 2008-11-04 21:19:41.000000000 +0100 +@@ -110,7 +110,7 @@ + char *password_prompt = NULL; + bool need_pass; + +- set_pglocale_pgservice(argv[0], "psql"); ++ set_pglocale_pgservice(argv[0], "psql-8.1"); + + if (argc > 1) + { +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/scripts/clusterdb.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/scripts/clusterdb.c +--- postgresql-8.1.15/src/bin/scripts/clusterdb.c 2005-06-21 06:02:33.000000000 +0200 ++++ postgresql-8.1.15/src/bin/scripts/clusterdb.c 2008-11-04 21:19:41.000000000 +0100 +@@ -56,7 +56,7 @@ + char *table = NULL; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.1"); + + handle_help_version_opts(argc, argv, "clusterdb", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/scripts/createdb.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/scripts/createdb.c +--- postgresql-8.1.15/src/bin/scripts/createdb.c 2005-06-21 06:02:33.000000000 +0200 ++++ postgresql-8.1.15/src/bin/scripts/createdb.c 2008-11-04 21:19:41.000000000 +0100 +@@ -60,7 +60,7 @@ + PGresult *result; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.1"); + + handle_help_version_opts(argc, argv, "createdb", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/scripts/createlang.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/scripts/createlang.c +--- postgresql-8.1.15/src/bin/scripts/createlang.c 2005-10-15 04:49:41.000000000 +0200 ++++ postgresql-8.1.15/src/bin/scripts/createlang.c 2008-11-04 21:19:41.000000000 +0100 +@@ -53,7 +53,7 @@ + PGresult *result; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.1"); + + handle_help_version_opts(argc, argv, "createlang", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/scripts/createuser.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/scripts/createuser.c +--- postgresql-8.1.15/src/bin/scripts/createuser.c 2005-10-15 04:49:41.000000000 +0200 ++++ postgresql-8.1.15/src/bin/scripts/createuser.c 2008-11-04 21:19:41.000000000 +0100 +@@ -75,7 +75,7 @@ + PGresult *result; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.1"); + + handle_help_version_opts(argc, argv, "createuser", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/scripts/dropdb.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/scripts/dropdb.c +--- postgresql-8.1.15/src/bin/scripts/dropdb.c 2005-06-21 06:02:33.000000000 +0200 ++++ postgresql-8.1.15/src/bin/scripts/dropdb.c 2008-11-04 21:19:41.000000000 +0100 +@@ -51,7 +51,7 @@ + PGresult *result; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.1"); + + handle_help_version_opts(argc, argv, "dropdb", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/scripts/droplang.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/scripts/droplang.c +--- postgresql-8.1.15/src/bin/scripts/droplang.c 2005-10-15 04:49:41.000000000 +0200 ++++ postgresql-8.1.15/src/bin/scripts/droplang.c 2008-11-04 21:19:41.000000000 +0100 +@@ -63,7 +63,7 @@ + PGresult *result; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.1"); + + handle_help_version_opts(argc, argv, "droplang", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/scripts/dropuser.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/scripts/dropuser.c +--- postgresql-8.1.15/src/bin/scripts/dropuser.c 2005-09-30 09:58:01.000000000 +0200 ++++ postgresql-8.1.15/src/bin/scripts/dropuser.c 2008-11-04 21:19:41.000000000 +0100 +@@ -51,7 +51,7 @@ + PGresult *result; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.1"); + + handle_help_version_opts(argc, argv, "dropuser", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/scripts/nls.mk postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/scripts/nls.mk +--- postgresql-8.1.15/src/bin/scripts/nls.mk 2005-07-29 17:13:11.000000000 +0200 ++++ postgresql-8.1.15/src/bin/scripts/nls.mk 2008-11-04 21:19:41.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/scripts/nls.mk,v 1.19 2005/07/29 15:13:11 momjian Exp $ +-CATALOG_NAME := pgscripts ++CATALOG_NAME := pgscripts-8.1 + AVAIL_LANGUAGES := cs de es fr it ko pt_BR ro ru sk sl sv tr zh_CN zh_TW + GETTEXT_FILES := createdb.c createlang.c createuser.c \ + dropdb.c droplang.c dropuser.c \ +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/scripts/reindexdb.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/scripts/reindexdb.c +--- postgresql-8.1.15/src/bin/scripts/reindexdb.c 2005-10-15 04:49:41.000000000 +0200 ++++ postgresql-8.1.15/src/bin/scripts/reindexdb.c 2008-11-04 21:19:41.000000000 +0100 +@@ -65,7 +65,7 @@ + const char *index = NULL; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.1"); + + handle_help_version_opts(argc, argv, "reindexdb", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/bin/scripts/vacuumdb.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/bin/scripts/vacuumdb.c +--- postgresql-8.1.15/src/bin/scripts/vacuumdb.c 2005-06-21 06:02:33.000000000 +0200 ++++ postgresql-8.1.15/src/bin/scripts/vacuumdb.c 2008-11-04 21:19:41.000000000 +0100 +@@ -64,7 +64,7 @@ + bool verbose = false; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.1"); + + handle_help_version_opts(argc, argv, "vacuumdb", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/interfaces/libpq/fe-misc.c postgresql-8.1.new/build-tree/postgresql-8.1.15/src/interfaces/libpq/fe-misc.c +--- postgresql-8.1.15/src/interfaces/libpq/fe-misc.c 2005-11-22 19:23:30.000000000 +0100 ++++ postgresql-8.1.15/src/interfaces/libpq/fe-misc.c 2008-11-04 21:19:41.000000000 +0100 +@@ -1141,7 +1141,7 @@ + ldir = getenv("PGLOCALEDIR"); + if (!ldir) + ldir = LOCALEDIR; +- bindtextdomain("libpq", ldir); ++ bindtextdomain("libpq4", ldir); + #ifdef WIN32 + SetLastError(save_errno); + #else +diff -Nur -x '*.orig' -x '*~' postgresql-8.1/build-tree/postgresql-8.1.15/src/interfaces/libpq/nls.mk postgresql-8.1.new/build-tree/postgresql-8.1.15/src/interfaces/libpq/nls.mk +--- postgresql-8.1.15/src/interfaces/libpq/nls.mk 2005-01-14 09:57:06.000000000 +0100 ++++ postgresql-8.1.15/src/interfaces/libpq/nls.mk 2008-11-04 21:19:41.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/interfaces/libpq/nls.mk,v 1.20 2005/01/14 08:57:06 petere Exp $ +-CATALOG_NAME := libpq ++CATALOG_NAME := libpq4 + AVAIL_LANGUAGES := af cs de es fr hr it ko nb pl pt_BR ru sk sl sv tr zh_CN zh_TW + GETTEXT_FILES := fe-auth.c fe-connect.c fe-exec.c fe-lobj.c fe-misc.c fe-protocol2.c fe-protocol3.c fe-secure.c + GETTEXT_TRIGGERS:= libpq_gettext pqInternalNotice:2 --- postgresql-8.1-8.1.23.orig/debian/patches/09-relax-sslkey-permscheck.patch +++ postgresql-8.1-8.1.23/debian/patches/09-relax-sslkey-permscheck.patch @@ -0,0 +1,22 @@ +diff -ruN postgresql-8.1beta4-old/src/backend/libpq/be-secure.c postgresql-8.1beta4/src/backend/libpq/be-secure.c +--- postgresql-8.1beta4-old/src/backend/libpq/be-secure.c 2005-10-15 04:49:17.000000000 +0200 ++++ postgresql-8.1beta4/src/backend/libpq/be-secure.c 2005-10-24 16:38:20.000000000 +0200 +@@ -753,13 +753,15 @@ + * permission check in postmaster.c) + */ + #if !defined(WIN32) && !defined(__CYGWIN__) +- if (!S_ISREG(buf.st_mode) || (buf.st_mode & (S_IRWXG | S_IRWXO)) || +- buf.st_uid != geteuid()) ++ 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("unsafe permissions on private key file \"%s\"", + SERVER_PRIVATE_KEY_FILE), +- errdetail("File must be owned by the database user and must have no permissions for \"group\" or \"other\"."))); ++ 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.1-8.1.23.orig/debian/patches/07-testsuite-params.patch +++ postgresql-8.1-8.1.23/debian/patches/07-testsuite-params.patch @@ -0,0 +1,13 @@ +diff -ruN postgresql-8.1.3-old/src/test/regress/pg_regress.sh postgresql-8.1.3/src/test/regress/pg_regress.sh +--- postgresql-8.1.3-old/src/test/regress/pg_regress.sh 2005-01-15 06:15:51.000000000 +0200 ++++ postgresql-8.1.3/src/test/regress/pg_regress.sh 2005-07-15 13:28:38.100000000 +0300 +@@ -5,6 +5,9 @@ + : ${TMPDIR=/tmp} + TMPFILE=$TMPDIR/pg_regress.$$ + ++postmaster_options="-c unix_socket_directory=/tmp" ++psql_options='-h /tmp' ++ + help="\ + PostgreSQL regression test driver + --- postgresql-8.1-8.1.23.orig/debian/patches/51-contrib-xml2-enable.patch +++ postgresql-8.1-8.1.23/debian/patches/51-contrib-xml2-enable.patch @@ -0,0 +1,13 @@ +diff -ruN postgresql-8.1.3-old/contrib/Makefile postgresql-8.1.3/contrib/Makefile +--- postgresql-8.1.3-old/contrib/Makefile 2005-08-15 23:07:03.000000000 +0200 ++++ postgresql-8.1.3/contrib/Makefile 2005-08-15 23:07:51.000000000 +0200 +@@ -41,7 +41,8 @@ + tsearch \ + tsearch2 \ + userlock \ +- vacuumlo ++ vacuumlo \ ++ xml2 + + # Missing: + # adddepend \ (does not have a makefile)