--- postgresql-8.2-8.2.3.orig/postgresql-8.2.3.tar.bz2.cdbs-config_list
+++ postgresql-8.2-8.2.3/postgresql-8.2.3.tar.bz2.cdbs-config_list
@@ -0,0 +1,5 @@
+postgresql-8.2.3/src/tools/msvc/config.pl
+postgresql-8.2.3/contrib/tsearch2/gendict/config.sh
+postgresql-8.2.3/config/config.guess
+postgresql-8.2.3/config/config.sub
+postgresql-8.2.3/doc/src/sgml/config.sgml
--- postgresql-8.2-8.2.3.orig/debian/libpq-dev.links
+++ postgresql-8.2-8.2.3/debian/libpq-dev.links
@@ -0,0 +1 @@
+/usr/lib/postgresql/8.2/bin/pg_config /usr/bin/pg_config
--- postgresql-8.2-8.2.3.orig/debian/libpgtypes2.install
+++ postgresql-8.2-8.2.3/debian/libpgtypes2.install
@@ -0,0 +1 @@
+usr/lib/libpgtypes.so.2*
--- postgresql-8.2-8.2.3.orig/debian/control
+++ postgresql-8.2-8.2.3/debian/control
@@ -0,0 +1,234 @@
+Source: postgresql-8.2
+Section: misc
+Priority: optional
+Maintainer: Martin Pitt <mpitt@debian.org>
+Standards-Version: 3.7.2
+XS-Python-Version: current
+Build-Depends: debhelper (>= 5.0.37.2), cdbs (>= 0.4.43), 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, python-central (>= 0.5), gettext, bzip2
+
+Package: libpq-dev
+Architecture: any
+Section: libdevel
+Depends: ${shlibs:Depends}, libpq5 (= ${Source-Version}), libssl-dev, libkrb5-dev, comerr-dev
+Conflicts: postgresql-dev (<< 7.5)
+Replaces: postgresql-dev
+Suggests: postgresql-doc-8.2
+Description: header files for libpq5 (PostgreSQL library)
+ Header files and static library for compiling C programs to link
+ with the libpq library in order to communicate with a PostgreSQL
+ database backend.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: libpq5
+Architecture: any
+Section: libs
+Depends: ${shlibs:Depends}
+Description: PostgreSQL C client library
+ libpq is a C library that enables user programs to communicate with
+ the PostgreSQL database server.  The server can be on another machine
+ and accessed through TCP/IP.  This version of libpq is compatible
+ with servers from PostgreSQL 8.2 or later.
+ .
+ This package contains the run-time library, needed by packages using
+ libpq.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: 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.2
+ The libpgtypes shared library is used by programs built with ecpg.
+ (Embedded PostgreSQL for C).
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-8.2
+Architecture: any
+Section: misc
+Depends: ${shlibs:Depends}, postgresql-client-8.2, postgresql-common (>= 63), tzdata
+Suggests: oidentd | ident-server
+Conflicts: postgresql (<< 7.5)
+Description: object-relational SQL database, version 8.2 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.2. 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.2
+Architecture: any
+Section: misc
+Depends: ${shlibs:Depends}, postgresql-client-common
+Conflicts: postgresql (<< 7.5)
+Suggests: postgresql-8.2, postgresql-doc-8.2
+Provides: postgresql-client
+Description: front-end programs for PostgreSQL 8.2
+ 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.2. If you install
+ PostgreSQL 8.2 on a standalone machine, you need the server package
+ postgresql-8.2, 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.2
+Architecture: any
+Section: libdevel
+Depends: ${shlibs:Depends}, libpq-dev (>= 8.2~beta)
+Conflicts: pgxs
+Replaces: pgxs
+Description: development files for PostgreSQL 8.2 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.2
+Architecture: all
+Section: doc
+Conflicts: postgresql-doc (<< 7.5)
+Description: documentation for the PostgreSQL database management system
+ This package contains all README files, user manual, and examples for
+ PostgreSQL 8.2. The manual is in HTML format.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-contrib-8.2
+Architecture: any
+Section: misc
+Depends: postgresql-8.2, ${shlibs:Depends}, postgresql-common (>= 39)
+Recommends: libdbd-pg-perl
+Conflicts: postgresql-contrib (<< 7.5)
+Replaces: postgresql-client-8.2 (<< 8.2~beta1-2)
+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.2.  contrib often serves as a testbed for
+ features before they are adopted into PostgreSQL proper:
+ .
+  adminpack      - File and log manipulation routines, used by pgAdmin
+  btree_gist     - B-Tree indexing using GiST (Generalised Search Tree)
+  chkpass        - An auto-encrypted password datatype
+  cube           - Multidimensional-cube datatype (GiST indexing example)
+  dblink         - Functions to return results from a remote database
+  earthdistance  - Operator for computing the distance (in miles) between
+                   two points on the earth's surface
+  fuzzystrmatch  - Levenshtein, metaphone, and soundex fuzzy string matching
+  intagg         - Integer aggregator/enumerator
+  intarray       - Index support for arrays of int4, using GiST
+  isn            - type extensions for ISBN, ISSN, ISMN, EAN13 product numbers
+  lo             - Large Object maintenance
+  ltree          - Tree-like data structures
+  oid2name       - Maps OIDs to table names
+  pg_buffercache - Real time queries on the shared buffer cache
+  pg_freespacemap- Displays the contents of the free space map (FSM)
+  pg_trgm        - Determine the similarity of text based on trigram matching
+  pgbench        - TPC-B like benchmark
+  pgcrypto       - Cryptographic functions
+  pgrowlocks     - A function to return row locking information
+  pgstattuple    - Returns the percentage of dead tuples in a table; this
+                   indicates whether a vacuum is required.
+  seg            - Confidence-interval datatype (GiST indexing example)
+  spi            - PostgreSQL Server Programming Interface; 4 examples of
+                   its use:
+                   autoinc    - A function for implementing AUTOINCREMENT/
+                                IDENTITY
+                   insert_username - function for inserting user names
+                   moddatetime - Update modification timestamps
+                   refint     - Functions for implementing referential
+                                integrity (foreign keys).  Note that this is
+                                now superseded by built-in referential
+                                integrity.
+                   timetravel - Re-implements in user code the time travel
+                                feature that was removed in 6.3.
+  tsearch2       - Full-text-index support using GiST
+  vacuumlo       - Remove orphaned large objects
+  xml2           - Manipulate XML documents in the database
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-plperl-8.2
+Architecture: any
+Depends: ${shlibs:Depends}, postgresql-8.2, perl
+Description: PL/Perl procedural language for PostgreSQL 8.2
+ PL/Perl enables an SQL developer to write procedural language functions
+ for PostgreSQL 8.2 in Perl.  You need this package if you have any
+ PostgreSQL 8.2 functions that use the languages plperl or plperlu.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-plpython-8.2
+Architecture: any
+Depends: ${shlibs:Depends}, postgresql-8.2
+XB-Python-Version: ${python:Versions}
+Description: PL/Python procedural language for PostgreSQL 8.2
+ PL/Python enables an SQL developer to write procedural language functions
+ for PostgreSQL 8.2 in Python.  You need this package if you have any
+ PostgreSQL 8.2 functions that use the languages plpython or plpythonu.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
+Package: postgresql-pltcl-8.2
+Architecture: any
+Depends: ${shlibs:Depends}, postgresql-8.2
+Description: PL/Tcl procedural language for PostgreSQL 8.2
+ PL/Tcl enables an SQL developer to write procedural language functions
+ for PostgreSQL 8.2 in Tcl.  You need this package if you have any
+ PostgreSQL 8.2 functions that use the languages pltcl or pltclu.
+ .
+ PostgreSQL is an object-relational SQL database management system.
+
--- postgresql-8.2-8.2.3.orig/debian/postgresql-client-8.2.install
+++ postgresql-8.2-8.2.3/debian/postgresql-client-8.2.install
@@ -0,0 +1,31 @@
+usr/lib/postgresql/8.2/bin/clusterdb
+usr/lib/postgresql/8.2/bin/pg_dumpall
+usr/lib/postgresql/8.2/bin/pg_dump
+usr/lib/postgresql/8.2/bin/createdb
+usr/lib/postgresql/8.2/bin/createlang
+usr/lib/postgresql/8.2/bin/createuser
+usr/lib/postgresql/8.2/bin/dropdb
+usr/lib/postgresql/8.2/bin/droplang
+usr/lib/postgresql/8.2/bin/dropuser
+usr/lib/postgresql/8.2/bin/reindexdb
+usr/lib/postgresql/8.2/bin/pg_restore
+usr/lib/postgresql/8.2/bin/psql
+usr/lib/postgresql/8.2/bin/vacuumdb
+usr/share/postgresql/8.2/man/man1/pg_restore.1
+usr/share/postgresql/8.2/man/man1/psql.1
+usr/share/postgresql/8.2/man/man1/vacuumdb.1
+usr/share/postgresql/8.2/man/man1/clusterdb.1
+usr/share/postgresql/8.2/man/man1/pg_dump.1
+usr/share/postgresql/8.2/man/man1/pg_dumpall.1
+usr/share/postgresql/8.2/man/man1/createdb.1
+usr/share/postgresql/8.2/man/man1/createlang.1
+usr/share/postgresql/8.2/man/man1/createuser.1
+usr/share/postgresql/8.2/man/man1/dropdb.1
+usr/share/postgresql/8.2/man/man1/droplang.1
+usr/share/postgresql/8.2/man/man1/dropuser.1
+usr/share/postgresql/8.2/man/man1/reindexdb.1
+usr/share/postgresql/8.2/man/man7/*7
+usr/share/postgresql/8.2/psqlrc.sample
+usr/share/locale/*/LC_MESSAGES/pg_dump-8.2.mo
+usr/share/locale/*/LC_MESSAGES/psql-8.2.mo
+usr/share/locale/*/LC_MESSAGES/pgscripts-8.2.mo
--- postgresql-8.2-8.2.3.orig/debian/postgresql-8.2.postrm
+++ postgresql-8.2-8.2.3/debian/postgresql-8.2.postrm
@@ -0,0 +1,53 @@
+#!/bin/sh -e
+
+#DEBHELPER#
+
+VERSION=8.2
+
+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.2-8.2.3.orig/debian/postgresql-client-8.2.postinst
+++ postgresql-8.2-8.2.3/debian/postgresql-client-8.2.postinst
@@ -0,0 +1,11 @@
+#!/bin/sh -e
+
+VERSION=8.2
+
+. /usr/share/postgresql-common/maintscripts-functions
+
+if [ "$1" = configure ]; then
+    configure_client_version $VERSION "$2"
+fi
+
+#DEBHELPER#
--- postgresql-8.2-8.2.3.orig/debian/rules
+++ postgresql-8.2-8.2.3/debian/rules
@@ -0,0 +1,89 @@
+#!/usr/bin/make	-f 
+TCL_VER := 8.4
+DEB_TAR_SRCDIR:=postgresql-8.2.3
+
+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
+CFLAGS+= -fPIC
+
+DEB_DH_INSTALL_SOURCEDIR=debian/tmp
+DEB_CONFIGURE_EXTRA_FLAGS := --mandir=\$${prefix}/share/postgresql/8.2/man \
+                    --with-docdir=\$${prefix}/share/doc/postgresql-doc-8.2 \
+		    --datadir=\$${prefix}/share/postgresql/8.2 \
+                    --bindir=\$${prefix}/lib/postgresql/8.2/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) \
+		    CFLAGS='$(CFLAGS)' \
+		    LDFLAGS='$(LDFLAGS)'
+
+DEB_DH_MAKESHLIBS_ARGS := -Xusr/lib/postgresql/8.2
+DEB_DH_INSTALLCHANGELOGS_ARGS := build-tree/postgresql-*/HISTORY
+DEB_COMPRESS_EXCLUDE := .source .c
+DEB_DH_INSTALLINIT_ARGS := -u'defaults 19'
+
+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.2::
+	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.2::
+	# 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; \
+	    exit 1; \
+	fi
+endif
+
+	cd build-tree/$(DEB_TAR_SRCDIR) && \
+	patch -Rp1 < ../../debian/disable-root-check.patch 
+
+	# compress manpages
+	find debian/postgresql-8.2/usr/share/postgresql/8.2/man -type f -exec gzip -9 '{}' \;
+
+binary-predeb/postgresql-client-8.2::
+	find debian/postgresql-client-8.2/usr/share/postgresql/8.2/man -type f -exec gzip -9 '{}' \;
+
+binary-install/postgresql-plpython-8.2::
+	dh_pycentral -p$(cdbs_curpkg)
+	dh_python -p$(cdbs_curpkg) usr/lib/postgresql/8.2/lib
+
--- postgresql-8.2-8.2.3.orig/debian/watch
+++ postgresql-8.2-8.2.3/debian/watch
@@ -0,0 +1,2 @@
+version=3
+ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/source/v(8\.2.*)/postgresql-(8\.2\.\d+)\.tar\.bz2
--- postgresql-8.2-8.2.3.orig/debian/postgresql-client-8.2.prerm
+++ postgresql-8.2-8.2.3/debian/postgresql-client-8.2.prerm
@@ -0,0 +1,10 @@
+#!/bin/sh -e
+
+#DEBHELPER#
+
+VERSION=8.2
+
+if [ "$1" = remove ]; then
+    . /usr/share/postgresql-common/maintscripts-functions
+    remove_client_version $VERSION
+fi
--- postgresql-8.2-8.2.3.orig/debian/postgresql-server-dev-8.2.install
+++ postgresql-8.2-8.2.3/debian/postgresql-server-dev-8.2.install
@@ -0,0 +1,2 @@
+usr/include/postgresql/8.2/*
+usr/lib/postgresql/8.2/lib/pgxs/*
--- postgresql-8.2-8.2.3.orig/debian/changelog
+++ postgresql-8.2-8.2.3/debian/changelog
@@ -0,0 +1,789 @@
+postgresql-8.2 (8.2.3-2) experimental; urgency=low
+
+  * debian/control: Add Perl dependency to p-8.2-plperl, to ensure that
+    creating plperl functions works (as opposed to plperlu, which only needs
+    libperl). (see bug #412135)
+  * debian/control: Do not mention nor suggest 'pgdocs' any more in p-doc's
+    description since pgdocs is only available for 7.4. (see bug #405097)
+  * debian/patches/04-timezone-symlinks.patch:
+    - Use the timezone database from the system tzdata instead of shipping our
+      own. Towards a single authoritative time zone database in Debian and
+      Ubuntu... :) (LP: #41159)
+    - Drop previous hardlink-to-symlink patch to zic, since that is irrelevant
+      now.
+    - debian/control: Add tzdata dependency.
+  * Add debian/patches/12-vacuum-cycle-hang.patch: Properly release our
+    semaphore lock before erroring out wit elog() to prevent deadlocks on
+    vacuum errors. Thanks to Heikki Linnakangas!
+  * debian/rules: Have a test suite failure fail the build again. Let's ignore
+    the old kernels on the Debian mips[el] buildds for now.
+
+ -- Martin Pitt <mpitt@debian.org>  Fri, 30 Mar 2007 19:02:04 +0200
+
+postgresql-8.2 (8.2.3-1) experimental; urgency=low
+
+  * New upstream bug fix release to fix regressions in 8.2.2:
+    - Remove overly-restrictive check for type length in constraints and
+      functional indexes.
+    - Fix optimization so MIN/MAX in subqueries can again use indexes.
+
+ -- Martin Pitt <mpitt@debian.org>  Thu,  8 Feb 2007 17:13:08 +0100
+
+postgresql-8.2 (8.2.2-1) experimental; urgency=low
+
+  * New upstream security and bug fix release:
+    - Fix security vulnerabilities that allowed connected users to
+      read backend memory.
+      The vulnerabilities involve suppressing the normal check that a SQL
+      function returns the data type it's declared to, and changing the
+      data type of a table column (CVE-2007-0555, CVE-2007-0556). These
+      errors can easily be exploited to cause a backend crash, and in
+      principle might be used to read database content that the user
+      should not be able to access.
+    - Fix not-so-rare-anymore bug wherein btree index page splits could
+      fail due to choosing an infeasible split point.
+    - Properly handle to_char('CC') for years ending in 00.
+      Year 2000 is in the twentieth century, not the twenty-first.
+    - "/contrib/tsearch2" localization improvements.
+    - Fix incorrect permission check in information_schema.key_column_usage
+      view.
+      The symptom is "relation with OID nnnnn does not exist" errors. To
+      get this fix without using "initdb", use "CREATE OR REPLACE VIEW"
+      to install the corrected definition found in
+      "share/information_schema.sql". Note you will need to do this in
+      each database.
+    - Improve "VACUUM" performance for databases with many tables.
+    - Fix for rare Assert() crash triggered by UNION.
+    - Fix potentially incorrect results from index searches using ROW
+      inequality conditions.
+    - Tighten security of multi-byte character processing for UTF8
+      sequences over three bytes long.
+    - Fix possible crashes when an already-in-use PL/pgSQL function is
+      updated.
+    - Improve PL/pgSQL handling of domain types.
+    - Fix possible errors in processing PL/pgSQL exception blocks.
+  * debian/control: postgresql-client-8.2 provides postgresql-client. This
+    avoids breaking all the reverse dependencies to p-c when the transitional
+    package gets removed. Closes: #400648
+
+ -- Martin Pitt <mpitt@debian.org>  Sun,  4 Feb 2007 20:38:09 +0100
+
+postgresql-8.2 (8.2.1-2) experimental; urgency=low
+
+  * debian/libpq-dev.install: Install missing pg_trace.h.
+  * debian/control: Remove -contrib's libpg-perl recommendation, nothing in
+    -contrib uses it any more. Thanks to Peter Eisentraut for spotting this.
+    Closes: #408070
+  * debian/control: Update -contrib package description for 8.2. 
+    Closes: #408072
+
+ -- Martin Pitt <mpitt@debian.org>  Mon, 29 Jan 2007 16:55:45 +0100
+
+postgresql-8.2 (8.2.1-1) experimental; urgency=low
+
+  * New upstream bugfix release:
+    - Fix crash with SELECT ... LIMIT ALL (also LIMIT NULL).
+    - "Several /contrib/tsearch2" fixes (Teodor)
+    - Fix planner mistakes for outer join queries.
+    - Fix several problems in queries involving sub-SELECTs.
+    - Fix potential crash in SPI during subtransaction abort.
+      This affects all PL functions since they all use SPI.
+    - Improve build speed of PDF documentation.
+    - Re-add JST (Japan) timezone abbreviation.
+    - Improve optimization decisions related to index scans.
+    - Have psql print multi-byte combining characters as before, rather
+      than output as \u.
+    - Improve index usage of regular expressions that use parentheses.
+      This improves psql \d performance also.
+    - Make pg_dumpall assume that databases have public CONNECT
+      privilege, when dumping from a pre-8.2 server.
+      This preserves the previous behavior that anyone can connect to a
+      database if allowed by "pg_hba.conf".
+
+ -- Martin Pitt <mpitt@debian.org>  Mon,  8 Jan 2007 18:04:34 +0100
+
+postgresql-8.2 (8.2-1) experimental; urgency=low
+
+  * 8.2 final release.
+  * debian/control: Fix spelling of 'Tcl'. (See #401191)
+  * Added a watch file.
+
+ -- Martin Pitt <mpitt@debian.org>  Sun,  3 Dec 2006 17:57:43 +0100
+
+postgresql-8.2 (8.2~rc1-1) experimental; urgency=low
+
+  * Release candidate 1.
+
+ -- Martin Pitt <mpitt@debian.org>  Sun, 26 Nov 2006 15:59:11 +0100
+
+postgresql-8.2 (8.2~beta3-1) experimental; urgency=low
+
+  * New upstream beta release.
+
+ -- Martin Pitt <mpitt@debian.org>  Sat, 11 Nov 2006 11:52:23 -0800
+
+postgresql-8.2 (8.2~beta2-1) experimental; urgency=low
+
+  * New upstream beta release.
+    - Documents ~/.pgpass file in psql(1). Closes: #308535
+    - Document long --format values in pg_dump(1). Closes: #308827
+    - Does not output &apos; any more in HTML mode. Closes: #353200
+  * debian/patches/{03-gettext-domains.patch,11-pg_regress-socketpath.patch}:
+    Adapted to new upstream version.
+
+ -- Martin Pitt <mpitt@debian.org>  Sun, 29 Oct 2006 17:25:02 +0100
+
+postgresql-8.2 (8.2~beta1-2) experimental; urgency=low
+
+  * Move vacuumlo from -client to -contrib, since it is a contributed script.
+    Add appropriate Replaces:.
+  * debian/control: Fix libpq-dev dependency of -server-dev-8.2.
+    Closes: #393148
+
+ -- Martin Pitt <mpitt@debian.org>  Sun, 15 Oct 2006 17:40:06 +0200
+
+postgresql-8.2 (8.2~beta1-1) experimental; urgency=low
+
+  * First public beta release of 8.2, packaging based on current 8.1 tree.
+  * Major improvements and changes (see HISTORY for details):
+    - Improved sort performance with lower memory usage.
+    - More efficient locking with better concurency.
+    - New FILLFACTOR support for tables and indexes.
+    - Many query optimization improvements.
+    - More efficient vacuuming.
+    - Warm standby server enhancements.
+    - Monitoring, logging, and performance tuning additions.
+    - Query enhancements including RETURNING values, multi-VALUES,
+    - support, and self-joins for DELETE.
+    - More control over creating/dropping objects and inheritance.
+    - Index creation without blocking INSERT/UPDATE/DELETE.
+    - COPY TO support for SELECT statements.
+    - Array and aggregate improvements, including SQL:2003 statistical
+    - functions.
+    - Many /contrib improvements.
+
+ -- Martin Pitt <mpitt@debian.org>  Wed, 27 Sep 2006 20:38:06 +0200
+
+postgresql-8.1 (8.1.4-6) unstable; urgency=low
+
+  * debian/control: Drop heimdal-dev suggestion of libpq-dev. Closes: #379848
+  * debian/libpq-dev.install: Ship pg_wchar.h. Closes: #380047
+  * Transition for private python extension in p-plpython-8.1:
+    - debian/control:
+      + Bump cdbs/debhelper build dependency versions.
+      + Add {XS,XB}-Python-Version attributes.
+    - debian/compat: Use compat level 5.
+    - Add debian/pycompat: Use compat level 2.
+    - debian/rules: Call dh_pycentral and dh_python for p-plpython-8.1.
+    - Closes: #380898
+  * debian/control: Change the order of records so that the libraries come
+    first. With that, postgresql-client-8.1 and friends pick up the correct
+    shlibs. Closes: #381211
+
+ -- Martin Pitt <mpitt@debian.org>  Sun,  6 Aug 2006 12:31:37 +0200
+
+postgresql-8.1 (8.1.4-5) unstable; urgency=low
+
+  * debian/rules: Install init script at priority 19, since Apache and web
+    applications usually reside on priority 20, but often require a running
+    database. This follows a recent change in the MySQL package, thanks to
+    Christian Hammers for pointing this out. Closes: #379276
+  * Add debian/patches/12-pg_restore-ignore-failing-tables.patch:
+    - pg_restore: Add option -X no-data-for-failed-tables to ignore TABLE DATA
+      objects if the corresponding TABLE could not be created. Necessary for
+      fixing #351571.
+
+ -- Martin Pitt <mpitt@debian.org>  Sun, 23 Jul 2006 10:34:55 +0200
+
+postgresql-8.1 (8.1.4-4) unstable; urgency=low
+
+  * debian/rules: Use -fPIC instead of -fpic to avoid FTBFS on sparc and m68k
+    (and maybe avoid the ICE on arm).
+  * debian/postgresql-8.1.init: Add LSB magic comment header (provide both
+    postgresql-8.1 and a generic postgresql service). Closes: #377882
+
+ -- Martin Pitt <mpitt@debian.org>  Tue, 11 Jul 2006 22:28:07 +0200
+
+postgresql-8.1 (8.1.4-3) unstable; urgency=low
+
+  * debian/control: Add missing comerr-dev and libkrb5-dev dependencies to
+    libpq-dev. Closes: #371158
+  * Add debian/patches/54-contrib-dbmirror-quoteparsing.patch: Fix parsing of
+    quotes escaped as '' in PendingData table. Closes: #375743
+  * Add debian/patches/55-contrib-admin.patch:
+    - Add the 'admin81' contrib module and build it. This provides
+      instrumentation functions for use with PgAdmin 3 and similar.
+    - http://www.postgresql.org/ftp/pgadmin3/release/v1.4.2/adminpacks/
+    - Closes: #354731
+  * debian/rules: Build with -fpic everywhere to improve the proactive
+    security effectivity of address space layout randomization. This has no
+    measurable performance impact on at least i386, amd64, and powerpc.  
+
+ -- Martin Pitt <mpitt@debian.org>  Fri,  7 Jul 2006 21:28:45 +0200
+
+postgresql-8.1 (8.1.4-2) unstable; urgency=medium
+
+  * 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 <mpitt@debian.org>  Fri,  2 Jun 2006 00:44:26 +0200
+
+postgresql-8.1 (8.1.4-1) unstable; urgency=medium
+
+  * 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.
+
+ -- Martin Pitt <mpitt@debian.org>  Mon, 22 May 2006 10:33:20 +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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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-<version> 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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  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 <mpitt@debian.org>  Sun, 20 Feb 2005 19:17:17 +0100
+
--- postgresql-8.2-8.2.3.orig/debian/libecpg-dev.install
+++ postgresql-8.2-8.2.3/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.2/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.2-8.2.3.orig/debian/libecpg-dev.manpages
+++ postgresql-8.2-8.2.3/debian/libecpg-dev.manpages
@@ -0,0 +1 @@
+debian/tmp/usr/share/postgresql/8.2/man/man1/ecpg.1
--- postgresql-8.2-8.2.3.orig/debian/postgresql-doc-8.2.install
+++ postgresql-8.2-8.2.3/debian/postgresql-doc-8.2.install
@@ -0,0 +1 @@
+usr/share/doc/postgresql-doc-8.2/html/*
--- postgresql-8.2-8.2.3.orig/debian/postgresql-contrib-8.2.prerm
+++ postgresql-8.2-8.2.3/debian/postgresql-contrib-8.2.prerm
@@ -0,0 +1,10 @@
+#!/bin/sh -e
+
+#DEBHELPER#
+
+VERSION=8.2
+
+if [ "$1" = remove ]; then
+    . /usr/share/postgresql-common/maintscripts-functions
+    remove_contrib_version $VERSION
+fi
--- postgresql-8.2-8.2.3.orig/debian/libpq-dev.manpages
+++ postgresql-8.2-8.2.3/debian/libpq-dev.manpages
@@ -0,0 +1 @@
+debian/tmp/usr/share/postgresql/8.2/man/man1/pg_config.1
--- postgresql-8.2-8.2.3.orig/debian/postgresql-plperl-8.2.install
+++ postgresql-8.2-8.2.3/debian/postgresql-plperl-8.2.install
@@ -0,0 +1 @@
+usr/lib/postgresql/8.2/lib/plperl.so
--- postgresql-8.2-8.2.3.orig/debian/libecpg-compat2.install
+++ postgresql-8.2-8.2.3/debian/libecpg-compat2.install
@@ -0,0 +1 @@
+usr/lib/libecpg_compat.so.2*
--- postgresql-8.2-8.2.3.orig/debian/compat
+++ postgresql-8.2-8.2.3/debian/compat
@@ -0,0 +1 @@
+5
--- postgresql-8.2-8.2.3.orig/debian/libpq5.install
+++ postgresql-8.2-8.2.3/debian/libpq5.install
@@ -0,0 +1,2 @@
+usr/lib/libpq.so.5*
+usr/share/locale/*/LC_MESSAGES/libpq5.mo
--- postgresql-8.2-8.2.3.orig/debian/postgresql-plpython-8.2.install
+++ postgresql-8.2-8.2.3/debian/postgresql-plpython-8.2.install
@@ -0,0 +1 @@
+usr/lib/postgresql/8.2/lib/plpython.so
--- postgresql-8.2-8.2.3.orig/debian/postgresql-pltcl-8.2.install
+++ postgresql-8.2-8.2.3/debian/postgresql-pltcl-8.2.install
@@ -0,0 +1,3 @@
+usr/lib/postgresql/8.2/lib/pltcl.so
+usr/lib/postgresql/8.2/bin/pltcl_*
+usr/share/postgresql/8.2/unknown.pltcl
--- postgresql-8.2-8.2.3.orig/debian/disable-root-check.patch
+++ postgresql-8.2-8.2.3/debian/disable-root-check.patch
@@ -0,0 +1,36 @@
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta1/src/backend/main/main.c postgresql-8.2.new/build-tree/postgresql-8.2beta1/src/backend/main/main.c
+--- postgresql-8.2beta1/src/backend/main/main.c	2006-09-26 00:50:41.000000000 +0200
++++ postgresql-8.2beta1/src/backend/main/main.c	2006-09-26 00:51:43.000000000 +0200
+@@ -326,7 +326,7 @@
+ check_root(const char *progname)
+ {
+ #ifndef WIN32
+-	if (geteuid() == 0)
++	if (0 && geteuid() == 0)
+ 	{
+ 		write_stderr("\"root\" execution of the PostgreSQL server is not permitted.\n"
+ 					 "The server must be started under an unprivileged user ID to prevent\n"
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta1/src/bin/initdb/initdb.c postgresql-8.2.new/build-tree/postgresql-8.2beta1/src/bin/initdb/initdb.c
+--- postgresql-8.2beta1/src/bin/initdb/initdb.c	2006-09-26 00:50:41.000000000 +0200
++++ postgresql-8.2beta1/src/bin/initdb/initdb.c	2006-09-26 00:52:09.000000000 +0200
+@@ -636,7 +636,7 @@
+ 
+ 	pw = getpwuid(geteuid());
+ 
+-	if (geteuid() == 0)			/* 0 is root's uid */
++	if (0 && geteuid() == 0)		/* 0 is root's uid */
+ 	{
+ 		fprintf(stderr,
+ 				_("%s: cannot be run as root\n"
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta1/src/bin/pg_ctl/pg_ctl.c postgresql-8.2.new/build-tree/postgresql-8.2beta1/src/bin/pg_ctl/pg_ctl.c
+--- postgresql-8.2beta1/src/bin/pg_ctl/pg_ctl.c	2006-09-26 00:50:41.000000000 +0200
++++ postgresql-8.2beta1/src/bin/pg_ctl/pg_ctl.c	2006-09-26 00:52:23.000000000 +0200
+@@ -1517,7 +1517,7 @@
+ 	 * Disallow running as root, to forestall any possible security holes.
+ 	 */
+ #ifndef WIN32
+-	if (geteuid() == 0)
++	if (0 && geteuid() == 0)
+ 	{
+ 		write_stderr(_("%s: cannot be run as root\n"
+ 					   "Please log in (using, e.g., \"su\") as the "
--- postgresql-8.2-8.2.3.orig/debian/postgresql-8.2.links
+++ postgresql-8.2-8.2.3/debian/postgresql-8.2.links
@@ -0,0 +1 @@
+/usr/share/doc/postgresql-common/README.Debian.gz /usr/share/doc/postgresql-8.2/README.Debian.gz
--- postgresql-8.2-8.2.3.orig/debian/postgresql-8.2.prerm
+++ postgresql-8.2-8.2.3/debian/postgresql-8.2.prerm
@@ -0,0 +1,11 @@
+#!/bin/sh -e
+
+VERSION=8.2
+
+#DEBHELPER#
+
+if [ "$1" = remove ]; then
+    . /usr/share/postgresql-common/maintscripts-functions
+    remove_version $VERSION
+fi
+
--- postgresql-8.2-8.2.3.orig/debian/postgresql-8.2.postinst
+++ postgresql-8.2-8.2.3/debian/postgresql-8.2.postinst
@@ -0,0 +1,12 @@
+#!/bin/sh -e
+
+VERSION=8.2
+
+
+if [ "$1" = configure ]; then
+    . /usr/share/postgresql-common/maintscripts-functions
+
+    configure_version $VERSION "$2"
+fi
+
+#DEBHELPER#
--- postgresql-8.2-8.2.3.orig/debian/libecpg5.install
+++ postgresql-8.2-8.2.3/debian/libecpg5.install
@@ -0,0 +1 @@
+usr/lib/libecpg.so.5*
--- postgresql-8.2-8.2.3.orig/debian/pycompat
+++ postgresql-8.2-8.2.3/debian/pycompat
@@ -0,0 +1 @@
+2
--- postgresql-8.2-8.2.3.orig/debian/libpq-dev.install
+++ postgresql-8.2-8.2.3/debian/libpq-dev.install
@@ -0,0 +1,17 @@
+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.2/server/catalog/pg_type.h /usr/include/postgresql/catalog
+usr/include/postgresql/8.2/server/nodes/nodes.h /usr/include/postgresql/nodes
+usr/include/postgresql/8.2/server/utils/{elog,errcodes,palloc}.h /usr/include/postgresql/utils
+usr/include/postgresql/8.2/server/{c,pg_config,pg_config_manual,pg_config_os,port,pg_trace}.h /usr/include/postgresql/
+usr/include/postgresql/8.2/server/postgres{,_fe,_ext}.h /usr/include/postgresql/
+usr/include/postgresql/8.2/server/mb/pg_wchar.h /usr/include/postgresql/mb
+usr/lib/libpgport.a
+usr/lib/libpq.a
+usr/lib/libpq.so
+usr/lib/postgresql/8.2/bin/pg_config
+usr/share/postgresql/8.2/man/man1/pg_config.1
+usr/share/locale/*/LC_MESSAGES/pg_config-8.2.mo
--- postgresql-8.2-8.2.3.orig/debian/postgresql-8.2.install
+++ postgresql-8.2-8.2.3/debian/postgresql-8.2.install
@@ -0,0 +1,29 @@
+usr/lib/postgresql/8.2/bin/initdb
+usr/lib/postgresql/8.2/bin/ipcclean
+usr/lib/postgresql/8.2/bin/pg_controldata
+usr/lib/postgresql/8.2/bin/pg_ctl
+usr/lib/postgresql/8.2/bin/pg_resetxlog
+usr/lib/postgresql/8.2/bin/postgres
+usr/lib/postgresql/8.2/bin/postmaster
+usr/lib/postgresql/8.2/lib/*_and_*.so
+usr/lib/postgresql/8.2/lib/plpgsql.so
+usr/share/locale/*/LC_MESSAGES/initdb-8.2.mo
+usr/share/locale/*/LC_MESSAGES/pg_controldata-8.2.mo
+usr/share/locale/*/LC_MESSAGES/pg_ctl-8.2.mo
+usr/share/locale/*/LC_MESSAGES/pg_resetxlog-8.2.mo
+usr/share/locale/*/LC_MESSAGES/postgres-8.2.mo
+usr/share/postgresql/8.2/man/man1/initdb.1
+usr/share/postgresql/8.2/man/man1/ipcclean.1
+usr/share/postgresql/8.2/man/man1/pg_controldata.1
+usr/share/postgresql/8.2/man/man1/pg_ctl.1
+usr/share/postgresql/8.2/man/man1/pg_resetxlog.1
+usr/share/postgresql/8.2/man/man1/postgres.1
+usr/share/postgresql/8.2/man/man1/postmaster.1
+usr/share/postgresql/8.2/timezone/*
+usr/share/postgresql/8.2/timezonesets/*
+usr/share/postgresql/8.2/*.sql
+usr/share/postgresql/8.2/*.conf.sample
+usr/share/postgresql/8.2/postgres.bki
+usr/share/postgresql/8.2/postgres.description
+usr/share/postgresql/8.2/postgres.shdescription
+usr/share/postgresql/8.2/sql_features.txt
--- postgresql-8.2-8.2.3.orig/debian/patches/04-timezone-symlinks.patch
+++ postgresql-8.2-8.2.3/debian/patches/04-timezone-symlinks.patch
@@ -0,0 +1,12 @@
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2.3/src/timezone/Makefile postgresql-8.2.new/build-tree/postgresql-8.2.3/src/timezone/Makefile
+--- postgresql-8.2.3/src/timezone/Makefile	2006-07-25 05:51:22.000000000 +0200
++++ postgresql-8.2.3/src/timezone/Makefile	2007-03-30 18:52:54.000000000 +0200
+@@ -34,7 +34,7 @@
+ 	$(CC) $(CFLAGS) $(ZICOBJS) $(LDFLAGS) $(LIBS) -o $@$(X)
+ 
+ install: all installdirs
+-	./zic -d '$(DESTDIR)$(datadir)/timezone' $(TZDATAFILES)
++	ln -s /usr/share/zoneinfo '$(DESTDIR)$(datadir)/timezone'
+ 	$(MAKE) -C tznames $@
+ 
+ installdirs:
--- postgresql-8.2-8.2.3.orig/debian/patches/06-libpq-defaultsocketdir.patch
+++ postgresql-8.2-8.2.3/debian/patches/06-libpq-defaultsocketdir.patch
@@ -0,0 +1,12 @@
+diff -ruN postgresql-8.2.3-old/src/include/pg_config_manual.h postgresql-8.2.3/src/include/pg_config_manual.h
+--- postgresql-8.2.3-old/src/include/pg_config_manual.h	2004-09-10 16:27:37.000000000 +0200
++++ postgresql-8.2.3/src/include/pg_config_manual.h	2005-06-14 19:21:28.200000000 +0200
+@@ -160,7 +160,7 @@
+  * here's where to twiddle it.  You can also override this at runtime
+  * with the postmaster's -k switch.
+  */
+-#define DEFAULT_PGSOCKET_DIR  "/tmp"
++#define DEFAULT_PGSOCKET_DIR  "/var/run/postgresql"
+ 
+ /*
+  * The random() function is expected to yield values between 0 and
--- postgresql-8.2-8.2.3.orig/debian/patches/07-relax-sslkey-permscheck.patch
+++ postgresql-8.2-8.2.3/debian/patches/07-relax-sslkey-permscheck.patch
@@ -0,0 +1,22 @@
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta1/src/backend/libpq/be-secure.c postgresql-8.2.new/build-tree/postgresql-8.2beta1/src/backend/libpq/be-secure.c
+--- postgresql-8.2beta1/src/backend/libpq/be-secure.c	2006-09-04 16:57:27.000000000 +0200
++++ postgresql-8.2beta1/src/backend/libpq/be-secure.c	2006-09-25 19:24:13.000000000 +0200
+@@ -751,13 +751,15 @@
+ 		 * directory permission check in postmaster.c)
+ 		 */
+ #if !defined(WIN32) && !defined(__CYGWIN__)
+-		if (!S_ISREG(buf.st_mode) || (buf.st_mode & (S_IRWXG | S_IRWXO)) ||
+-			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.2-8.2.3.orig/debian/patches/10-tutorial-README.patch
+++ postgresql-8.2-8.2.3/debian/patches/10-tutorial-README.patch
@@ -0,0 +1,13 @@
+diff -ruN postgresql-8.2.3-old/src/tutorial/README postgresql-8.2.3/src/tutorial/README
+--- postgresql-8.2.3-old/src/tutorial/README	2001-10-26 22:45:33.000000000 +0200
++++ postgresql-8.2.3/src/tutorial/README	2006-04-10 22:17:29.000000000 +0200
+@@ -1,8 +1,7 @@
+ This directory contains SQL tutorial scripts.  To look at them, first do a
+ 	% make
+ to compile all the scripts and C files for the user-defined functions
+-and types.  (make needs to be GNU make --- it may be named something
+-different on your system, often gmake)
++and types. This requires postgresql-server-dev-8.2 to be installed.
+ 
+ Then, run psql with the -s (single-step) flag:
+ 	% psql -s
--- postgresql-8.2-8.2.3.orig/debian/patches/05-check-rlimits-nofile.patch
+++ postgresql-8.2-8.2.3/debian/patches/05-check-rlimits-nofile.patch
@@ -0,0 +1,33 @@
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta1/src/backend/storage/file/fd.c postgresql-8.2.new/build-tree/postgresql-8.2beta1/src/backend/storage/file/fd.c
+--- postgresql-8.2beta1/src/backend/storage/file/fd.c	2006-08-24 05:15:43.000000000 +0200
++++ postgresql-8.2beta1/src/backend/storage/file/fd.c	2006-09-25 19:19:51.000000000 +0200
+@@ -51,6 +51,7 @@
+ #include "storage/fd.h"
+ #include "storage/ipc.h"
+ 
++#include <sys/resource.h>
+ 
+ /*
+  * We must leave some file descriptors free for system(), the dynamic loader,
+@@ -345,15 +346,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.2-8.2.3.orig/debian/patches/12-vacuum-cycle-hang.patch
+++ postgresql-8.2-8.2.3/debian/patches/12-vacuum-cycle-hang.patch
@@ -0,0 +1,36 @@
+Index: src/backend/access/nbtree/nbtutils.c
+===================================================================
+RCS file: /home/hlinnaka/pgcvsrepository/pgsql/src/backend/access/nbtree/nbtutils.c,v
+retrieving revision 1.79
+diff -c -r1.79 nbtutils.c
+*** src/backend/access/nbtree/nbtutils.c	4 Oct 2006 00:29:49 -0000	1.79
+--- src/backend/access/nbtree/nbtutils.c	30 Mar 2007 07:55:36 -0000
+***************
+*** 998,1016 ****
+--- 998,1023 ----
+  		vac = &btvacinfo->vacuums[i];
+  		if (vac->relid.relId == rel->rd_lockInfo.lockRelId.relId &&
+  			vac->relid.dbId == rel->rd_lockInfo.lockRelId.dbId)
++ 		{
++ 			LWLockRelease(BtreeVacuumLock);
+  			elog(ERROR, "multiple active vacuums for index \"%s\"",
+  				 RelationGetRelationName(rel));
++ 		}
+  	}
+  
+  	/* OK, add an entry */
+  	if (btvacinfo->num_vacuums >= btvacinfo->max_vacuums)
++ 	{
++ 		LWLockRelease(BtreeVacuumLock);
+  		elog(ERROR, "out of btvacinfo slots");
++ 	}
+  	vac = &btvacinfo->vacuums[btvacinfo->num_vacuums];
+  	vac->relid = rel->rd_lockInfo.lockRelId;
+  	vac->cycleid = result;
+  	btvacinfo->num_vacuums++;
+  
+  	LWLockRelease(BtreeVacuumLock);
++ 
+  	return result;
+  }
+  
--- postgresql-8.2-8.2.3.orig/debian/patches/11-pg_regress-socketpath.patch
+++ postgresql-8.2-8.2.3/debian/patches/11-pg_regress-socketpath.patch
@@ -0,0 +1,39 @@
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/test/regress/pg_regress.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/test/regress/pg_regress.c
+--- postgresql-8.2beta2/src/test/regress/pg_regress.c	2006-10-04 02:30:14.000000000 +0200
++++ postgresql-8.2beta2/src/test/regress/pg_regress.c	2006-10-27 09:08:40.000000000 +0200
+@@ -599,7 +599,7 @@
+ 
+ 	/* And now we can build and execute the shell command */
+ 	snprintf(psql_cmd, sizeof(psql_cmd),
+-			 SYSTEMQUOTE "\"%s%spsql\" -X -c \"%s\" \"%s\"" SYSTEMQUOTE,
++			 SYSTEMQUOTE "\"%s%spsql\" -h /tmp -X -c \"%s\" \"%s\"" SYSTEMQUOTE,
+ 			 psqldir ? psqldir : "",
+ 			 psqldir ? "/" : "",
+ 			 query_escaped,
+@@ -701,7 +701,7 @@
+ 			 outputdir, testname);
+ 
+ 	snprintf(psql_cmd, sizeof(psql_cmd),
+-			 SYSTEMQUOTE "\"%s%spsql\" -X -a -q -d \"%s\" < \"%s\" > \"%s\" 2>&1" SYSTEMQUOTE,
++			 SYSTEMQUOTE "\"%s%spsql\" -h /tmp -X -a -q -d \"%s\" < \"%s\" > \"%s\" 2>&1" SYSTEMQUOTE,
+ 			 psqldir ? psqldir : "",
+ 			 psqldir ? "/" : "",
+ 			 dbname,
+@@ -1515,7 +1515,7 @@
+ 		 */
+ 		header(_("starting postmaster"));
+ 		snprintf(buf, sizeof(buf),
+-				 SYSTEMQUOTE "\"%s/postgres\" -D \"%s/data\" -F%s -c \"listen_addresses=%s\" > \"%s/log/postmaster.log\" 2>&1" SYSTEMQUOTE,
++				 SYSTEMQUOTE "\"%s/postgres\" -D \"%s/data\" -k /tmp -F%s -c \"listen_addresses=%s\" > \"%s/log/postmaster.log\" 2>&1" SYSTEMQUOTE,
+ 				 bindir, temp_install,
+ 				 debug ? " -d 5" : "",
+ 				 hostname ? hostname : "",
+@@ -1534,7 +1534,7 @@
+ 		 * forever, however.
+ 		 */
+ 		snprintf(buf, sizeof(buf),
+-				 SYSTEMQUOTE "\"%s/psql\" -X postgres <%s 2>%s" SYSTEMQUOTE,
++				 SYSTEMQUOTE "\"%s/psql\" -h /tmp -X postgres <%s 2>%s" SYSTEMQUOTE,
+ 				 bindir, DEVNULL, DEVNULL);
+ 		for (i = 0; i < 60; i++)
+ 		{
--- postgresql-8.2-8.2.3.orig/debian/patches/03-gettext-domains.patch
+++ postgresql-8.2-8.2.3/debian/patches/03-gettext-domains.patch
@@ -0,0 +1,340 @@
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/backend/main/main.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/backend/main/main.c
+--- postgresql-8.2beta2/src/backend/main/main.c	2006-10-04 02:29:53.000000000 +0200
++++ postgresql-8.2beta2/src/backend/main/main.c	2006-10-27 09:06:22.000000000 +0200
+@@ -87,7 +87,7 @@
+ 	 * error messages to be localized.
+ 	 */
+ 
+-	set_pglocale_pgservice(argv[0], "postgres");
++	set_pglocale_pgservice(argv[0], "postgres-8.2");
+ 
+ #ifdef WIN32
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/backend/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/backend/nls.mk
+--- postgresql-8.2beta2/src/backend/nls.mk	2005-10-04 13:14:03.000000000 +0200
++++ postgresql-8.2beta2/src/backend/nls.mk	2006-10-27 09:06:22.000000000 +0200
+@@ -1,5 +1,5 @@
+ # $PostgreSQL: pgsql/src/backend/nls.mk,v 1.20 2005/10/04 11:14:03 petere Exp $
+-CATALOG_NAME	:= postgres
++CATALOG_NAME	:= postgres-8.2
+ 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
+ # you can add "elog:2" and "errmsg_internal" to this list if you want to
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/initdb/initdb.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/initdb/initdb.c
+--- postgresql-8.2beta2/src/bin/initdb/initdb.c	2006-10-04 20:58:08.000000000 +0200
++++ postgresql-8.2beta2/src/bin/initdb/initdb.c	2006-10-27 09:06:22.000000000 +0200
+@@ -2422,7 +2422,7 @@
+ 	};
+ 
+ 	progname = get_progname(argv[0]);
+-	set_pglocale_pgservice(argv[0], "initdb");
++	set_pglocale_pgservice(argv[0], "initdb-8.2");
+ 
+ 	if (argc > 1)
+ 	{
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/initdb/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/initdb/nls.mk
+--- postgresql-8.2beta2/src/bin/initdb/nls.mk	2005-01-09 18:38:18.000000000 +0100
++++ postgresql-8.2beta2/src/bin/initdb/nls.mk	2006-10-27 09:06:22.000000000 +0200
+@@ -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.2
+ 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 postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_config/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_config/nls.mk
+--- postgresql-8.2beta2/src/bin/pg_config/nls.mk	2006-10-21 23:03:01.000000000 +0200
++++ postgresql-8.2beta2/src/bin/pg_config/nls.mk	2006-10-27 09:06:44.000000000 +0200
+@@ -1,5 +1,5 @@
+ # $PostgreSQL: pgsql/src/bin/pg_config/nls.mk,v 1.16 2006/10/21 21:03:01 petere Exp $
+-CATALOG_NAME	:= pg_config
++CATALOG_NAME	:= pg_config-8.2
+ AVAIL_LANGUAGES	:= cs de es fr ko nb pl pt_BR ro ru sl sv tr zh_CN zh_TW
+ GETTEXT_FILES	:= pg_config.c ../../port/exec.c
+ GETTEXT_TRIGGERS:= _
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_config/pg_config.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_config/pg_config.c
+--- postgresql-8.2beta2/src/bin/pg_config/pg_config.c	2006-10-04 02:30:04.000000000 +0200
++++ postgresql-8.2beta2/src/bin/pg_config/pg_config.c	2006-10-27 09:06:22.000000000 +0200
+@@ -451,7 +451,7 @@
+ 	int			j;
+ 	int			ret;
+ 
+-	set_pglocale_pgservice(argv[0], "pg_config");
++	set_pglocale_pgservice(argv[0], "pg_config-8.2");
+ 
+ 	progname = get_progname(argv[0]);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_controldata/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_controldata/nls.mk
+--- postgresql-8.2beta2/src/bin/pg_controldata/nls.mk	2005-01-14 09:57:05.000000000 +0100
++++ postgresql-8.2beta2/src/bin/pg_controldata/nls.mk	2006-10-27 09:06:22.000000000 +0200
+@@ -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.2
+ 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 postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_controldata/pg_controldata.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_controldata/pg_controldata.c
+--- postgresql-8.2beta2/src/bin/pg_controldata/pg_controldata.c	2006-08-21 18:16:31.000000000 +0200
++++ postgresql-8.2beta2/src/bin/pg_controldata/pg_controldata.c	2006-10-27 09:06:22.000000000 +0200
+@@ -75,7 +75,7 @@
+ 	char	   *strftime_fmt = "%c";
+ 	const char *progname;
+ 
+-	set_pglocale_pgservice(argv[0], "pg_controldata");
++	set_pglocale_pgservice(argv[0], "pg_controldata-8.2");
+ 
+ 	progname = get_progname(argv[0]);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_ctl/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_ctl/nls.mk
+--- postgresql-8.2beta2/src/bin/pg_ctl/nls.mk	2004-12-16 12:27:41.000000000 +0100
++++ postgresql-8.2beta2/src/bin/pg_ctl/nls.mk	2006-10-27 09:06:22.000000000 +0200
+@@ -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.2
+ 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 postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_ctl/pg_ctl.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_ctl/pg_ctl.c
+--- postgresql-8.2beta2/src/bin/pg_ctl/pg_ctl.c	2006-10-12 07:14:49.000000000 +0200
++++ postgresql-8.2beta2/src/bin/pg_ctl/pg_ctl.c	2006-10-27 09:06:22.000000000 +0200
+@@ -1509,7 +1509,7 @@
+ #endif
+ 
+ 	progname = get_progname(argv[0]);
+-	set_pglocale_pgservice(argv[0], "pg_ctl");
++	set_pglocale_pgservice(argv[0], "pg_ctl-8.2");
+ 
+ 	/*
+ 	 * save argv[0] so do_start() can look for the postmaster if necessary. we
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_dump/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_dump/nls.mk
+--- postgresql-8.2beta2/src/bin/pg_dump/nls.mk	2005-01-25 18:32:00.000000000 +0100
++++ postgresql-8.2beta2/src/bin/pg_dump/nls.mk	2006-10-27 09:06:22.000000000 +0200
+@@ -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.2
+ 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 postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_dump/pg_dumpall.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_dump/pg_dumpall.c
+--- postgresql-8.2beta2/src/bin/pg_dump/pg_dumpall.c	2006-10-07 22:59:05.000000000 +0200
++++ postgresql-8.2beta2/src/bin/pg_dump/pg_dumpall.c	2006-10-27 09:06:22.000000000 +0200
+@@ -117,7 +117,7 @@
+ 
+ 	int			optindex;
+ 
+-	set_pglocale_pgservice(argv[0], "pg_dump");
++	set_pglocale_pgservice(argv[0], "pg_dump-8.2");
+ 
+ 	progname = get_progname(argv[0]);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_dump/pg_dump.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_dump/pg_dump.c
+--- postgresql-8.2beta2/src/bin/pg_dump/pg_dump.c	2006-10-10 01:36:59.000000000 +0200
++++ postgresql-8.2beta2/src/bin/pg_dump/pg_dump.c	2006-10-27 09:06:22.000000000 +0200
+@@ -266,7 +266,7 @@
+ 	};
+ 	int			optindex;
+ 
+-	set_pglocale_pgservice(argv[0], "pg_dump");
++	set_pglocale_pgservice(argv[0], "pg_dump-8.2");
+ 
+ 	g_verbose = false;
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_dump/pg_restore.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_dump/pg_restore.c
+--- postgresql-8.2beta2/src/bin/pg_dump/pg_restore.c	2006-10-15 01:07:22.000000000 +0200
++++ postgresql-8.2beta2/src/bin/pg_dump/pg_restore.c	2006-10-27 09:06:22.000000000 +0200
+@@ -117,7 +117,7 @@
+ 		{NULL, 0, NULL, 0}
+ 	};
+ 
+-	set_pglocale_pgservice(argv[0], "pg_dump");
++	set_pglocale_pgservice(argv[0], "pg_dump-8.2");
+ 
+ 	opts = NewRestoreOptions();
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_resetxlog/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_resetxlog/nls.mk
+--- postgresql-8.2beta2/src/bin/pg_resetxlog/nls.mk	2004-12-16 12:27:42.000000000 +0100
++++ postgresql-8.2beta2/src/bin/pg_resetxlog/nls.mk	2006-10-27 09:06:22.000000000 +0200
+@@ -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.2
+ 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 postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/pg_resetxlog/pg_resetxlog.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/pg_resetxlog/pg_resetxlog.c
+--- postgresql-8.2beta2/src/bin/pg_resetxlog/pg_resetxlog.c	2006-10-04 02:30:05.000000000 +0200
++++ postgresql-8.2beta2/src/bin/pg_resetxlog/pg_resetxlog.c	2006-10-27 09:06:22.000000000 +0200
+@@ -86,7 +86,7 @@
+ 	int			fd;
+ 	char		path[MAXPGPATH];
+ 
+-	set_pglocale_pgservice(argv[0], "pg_resetxlog");
++	set_pglocale_pgservice(argv[0], "pg_resetxlog-8.2");
+ 
+ 	progname = get_progname(argv[0]);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/psql/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/psql/nls.mk
+--- postgresql-8.2beta2/src/bin/psql/nls.mk	2004-12-13 17:30:48.000000000 +0100
++++ postgresql-8.2beta2/src/bin/psql/nls.mk	2006-10-27 09:06:22.000000000 +0200
+@@ -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.2
+ 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 postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/psql/startup.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/psql/startup.c
+--- postgresql-8.2beta2/src/bin/psql/startup.c	2006-10-04 02:30:06.000000000 +0200
++++ postgresql-8.2beta2/src/bin/psql/startup.c	2006-10-27 09:06:22.000000000 +0200
+@@ -110,7 +110,7 @@
+ 	char	   *password_prompt = NULL;
+ 	bool		need_pass;
+ 
+-	set_pglocale_pgservice(argv[0], "psql");
++	set_pglocale_pgservice(argv[0], "psql-8.2");
+ 
+ 	if (argc > 1)
+ 	{
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/scripts/clusterdb.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/scripts/clusterdb.c
+--- postgresql-8.2beta2/src/bin/scripts/clusterdb.c	2006-03-05 16:58:52.000000000 +0100
++++ postgresql-8.2beta2/src/bin/scripts/clusterdb.c	2006-10-27 09:06:22.000000000 +0200
+@@ -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.2");
+ 
+ 	handle_help_version_opts(argc, argv, "clusterdb", help);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/scripts/createdb.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/scripts/createdb.c
+--- postgresql-8.2beta2/src/bin/scripts/createdb.c	2006-06-01 02:15:36.000000000 +0200
++++ postgresql-8.2beta2/src/bin/scripts/createdb.c	2006-10-27 09:06:22.000000000 +0200
+@@ -60,7 +60,7 @@
+ 	PGresult   *result;
+ 
+ 	progname = get_progname(argv[0]);
+-	set_pglocale_pgservice(argv[0], "pgscripts");
++	set_pglocale_pgservice(argv[0], "pgscripts-8.2");
+ 
+ 	handle_help_version_opts(argc, argv, "createdb", help);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/scripts/createlang.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/scripts/createlang.c
+--- postgresql-8.2beta2/src/bin/scripts/createlang.c	2006-07-14 16:52:27.000000000 +0200
++++ postgresql-8.2beta2/src/bin/scripts/createlang.c	2006-10-27 09:06:22.000000000 +0200
+@@ -52,7 +52,7 @@
+ 	PGresult   *result;
+ 
+ 	progname = get_progname(argv[0]);
+-	set_pglocale_pgservice(argv[0], "pgscripts");
++	set_pglocale_pgservice(argv[0], "pgscripts-8.2");
+ 
+ 	handle_help_version_opts(argc, argv, "createlang", help);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/scripts/createuser.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/scripts/createuser.c
+--- postgresql-8.2beta2/src/bin/scripts/createuser.c	2006-10-04 02:30:06.000000000 +0200
++++ postgresql-8.2beta2/src/bin/scripts/createuser.c	2006-10-27 09:06:22.000000000 +0200
+@@ -82,7 +82,7 @@
+ 	PGresult   *result;
+ 
+ 	progname = get_progname(argv[0]);
+-	set_pglocale_pgservice(argv[0], "pgscripts");
++	set_pglocale_pgservice(argv[0], "pgscripts-8.2");
+ 
+ 	handle_help_version_opts(argc, argv, "createuser", help);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/scripts/dropdb.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/scripts/dropdb.c
+--- postgresql-8.2beta2/src/bin/scripts/dropdb.c	2006-09-22 20:50:41.000000000 +0200
++++ postgresql-8.2beta2/src/bin/scripts/dropdb.c	2006-10-27 09:06:22.000000000 +0200
+@@ -51,7 +51,7 @@
+ 	PGresult   *result;
+ 
+ 	progname = get_progname(argv[0]);
+-	set_pglocale_pgservice(argv[0], "pgscripts");
++	set_pglocale_pgservice(argv[0], "pgscripts-8.2");
+ 
+ 	handle_help_version_opts(argc, argv, "dropdb", help);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/scripts/droplang.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/scripts/droplang.c
+--- postgresql-8.2beta2/src/bin/scripts/droplang.c	2006-05-31 13:02:42.000000000 +0200
++++ postgresql-8.2beta2/src/bin/scripts/droplang.c	2006-10-27 09:06:22.000000000 +0200
+@@ -63,7 +63,7 @@
+ 	PGresult   *result;
+ 
+ 	progname = get_progname(argv[0]);
+-	set_pglocale_pgservice(argv[0], "pgscripts");
++	set_pglocale_pgservice(argv[0], "pgscripts-8.2");
+ 
+ 	handle_help_version_opts(argc, argv, "droplang", help);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/scripts/dropuser.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/scripts/dropuser.c
+--- postgresql-8.2beta2/src/bin/scripts/dropuser.c	2006-09-22 20:50:41.000000000 +0200
++++ postgresql-8.2beta2/src/bin/scripts/dropuser.c	2006-10-27 09:06:22.000000000 +0200
+@@ -51,7 +51,7 @@
+ 	PGresult   *result;
+ 
+ 	progname = get_progname(argv[0]);
+-	set_pglocale_pgservice(argv[0], "pgscripts");
++	set_pglocale_pgservice(argv[0], "pgscripts-8.2");
+ 
+ 	handle_help_version_opts(argc, argv, "dropuser", help);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/scripts/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/scripts/nls.mk
+--- postgresql-8.2beta2/src/bin/scripts/nls.mk	2006-09-22 20:50:41.000000000 +0200
++++ postgresql-8.2beta2/src/bin/scripts/nls.mk	2006-10-27 09:06:22.000000000 +0200
+@@ -1,5 +1,5 @@
+ # $PostgreSQL: pgsql/src/bin/scripts/nls.mk,v 1.20 2006/09/22 18:50:41 petere Exp $
+-CATALOG_NAME    := pgscripts
++CATALOG_NAME    := pgscripts-8.2
+ 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 postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/scripts/reindexdb.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/scripts/reindexdb.c
+--- postgresql-8.2beta2/src/bin/scripts/reindexdb.c	2006-09-02 19:10:17.000000000 +0200
++++ postgresql-8.2beta2/src/bin/scripts/reindexdb.c	2006-10-27 09:06:22.000000000 +0200
+@@ -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.2");
+ 
+ 	handle_help_version_opts(argc, argv, "reindexdb", help);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/bin/scripts/vacuumdb.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/bin/scripts/vacuumdb.c
+--- postgresql-8.2beta2/src/bin/scripts/vacuumdb.c	2006-03-05 16:58:52.000000000 +0100
++++ postgresql-8.2beta2/src/bin/scripts/vacuumdb.c	2006-10-27 09:06:22.000000000 +0200
+@@ -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.2");
+ 
+ 	handle_help_version_opts(argc, argv, "vacuumdb", help);
+ 
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/interfaces/libpq/fe-misc.c postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/interfaces/libpq/fe-misc.c
+--- postgresql-8.2beta2/src/interfaces/libpq/fe-misc.c	2006-10-04 02:30:13.000000000 +0200
++++ postgresql-8.2beta2/src/interfaces/libpq/fe-misc.c	2006-10-27 09:06:22.000000000 +0200
+@@ -1139,7 +1139,7 @@
+ 		ldir = getenv("PGLOCALEDIR");
+ 		if (!ldir)
+ 			ldir = LOCALEDIR;
+-		bindtextdomain("libpq", ldir);
++		bindtextdomain("libpq5", ldir);
+ #ifdef WIN32
+ 		SetLastError(save_errno);
+ #else
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta2/src/interfaces/libpq/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2beta2/src/interfaces/libpq/nls.mk
+--- postgresql-8.2beta2/src/interfaces/libpq/nls.mk	2005-01-14 09:57:06.000000000 +0100
++++ postgresql-8.2beta2/src/interfaces/libpq/nls.mk	2006-10-27 09:06:22.000000000 +0200
+@@ -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	:= libpq5
+ 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.2-8.2.3.orig/debian/patches/50-contrib-enablemodules.patch
+++ postgresql-8.2-8.2.3/debian/patches/50-contrib-enablemodules.patch
@@ -0,0 +1,13 @@
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta1/contrib/Makefile postgresql-8.2.new/build-tree/postgresql-8.2beta1/contrib/Makefile
+--- postgresql-8.2beta1/contrib/Makefile	2006-09-09 06:07:51.000000000 +0200
++++ postgresql-8.2beta1/contrib/Makefile	2006-09-25 19:32:51.000000000 +0200
+@@ -30,7 +30,8 @@
+ 		spi		\
+ 		tablefunc	\
+ 		tsearch2	\
+-		vacuumlo
++		vacuumlo	\
++		xml2
+ 
+ ifeq ($(with_openssl),yes)
+ WANTED_DIRS += sslinfo
--- postgresql-8.2-8.2.3.orig/debian/patches/02-pager.patch
+++ postgresql-8.2-8.2.3/debian/patches/02-pager.patch
@@ -0,0 +1,12 @@
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta1/src/bin/psql/print.h postgresql-8.2.new/build-tree/postgresql-8.2beta1/src/bin/psql/print.h
+--- postgresql-8.2beta1/src/bin/psql/print.h	2006-08-30 00:25:07.000000000 +0200
++++ postgresql-8.2beta1/src/bin/psql/print.h	2006-09-25 19:18:54.000000000 +0200
+@@ -89,7 +89,7 @@
+ void		setDecimalLocale(void);
+ 
+ #ifndef __CYGWIN__
+-#define DEFAULT_PAGER "more"
++#define DEFAULT_PAGER "/usr/bin/pager"
+ #else
+ #define DEFAULT_PAGER "less"
+ #endif
--- postgresql-8.2-8.2.3.orig/debian/patches/08-pkglibdir.patch
+++ postgresql-8.2-8.2.3/debian/patches/08-pkglibdir.patch
@@ -0,0 +1,12 @@
+diff -ruN postgresql-8.2beta4-old/src/Makefile.global.in postgresql-8.2beta4/src/Makefile.global.in
+--- postgresql-8.2beta4-old/src/Makefile.global.in	2005-09-27 18:39:32.000000000 +0100
++++ postgresql-8.2beta4/src/Makefile.global.in	2005-10-26 20:40:52.000000000 +0100
+@@ -89,7 +89,7 @@
+ pkglibdir = $(libdir)
+ ifeq "$(findstring pgsql, $(pkglibdir))" ""
+ ifeq "$(findstring postgres, $(pkglibdir))" ""
+-override pkglibdir := $(pkglibdir)/postgresql
++override pkglibdir := $(pkglibdir)/postgresql/8.2/lib
+ endif
+ endif
+ 
--- postgresql-8.2-8.2.3.orig/debian/patches/01-build-contrib.patch
+++ postgresql-8.2-8.2.3/debian/patches/01-build-contrib.patch
@@ -0,0 +1,25 @@
+diff -Nur postgresql-8.2/build-tree/postgresql-8.2beta1/GNUmakefile.in postgresql-8.2.new/build-tree/postgresql-8.2beta1/GNUmakefile.in
+--- postgresql-8.2beta1/GNUmakefile.in	2006-08-18 21:58:05.000000000 +0200
++++ postgresql-8.2beta1/GNUmakefile.in	2006-09-25 19:15:34.000000000 +0200
+@@ -12,18 +14,21 @@
+ 	$(MAKE) -C doc all
+ 	$(MAKE) -C src all
+ 	$(MAKE) -C config all
++	$(MAKE) -C contrib all
+ 	@echo "All of PostgreSQL successfully made. Ready to install."
+ 
+ install:
+ 	$(MAKE) -C doc $@
+ 	$(MAKE) -C src $@
+ 	$(MAKE) -C config $@
++	$(MAKE) -C contrib $@
+ 	@echo "PostgreSQL installation complete."
+ 
+ installdirs uninstall:
+ 	$(MAKE) -C doc $@
+ 	$(MAKE) -C src $@
+ 	$(MAKE) -C config $@
++	$(MAKE) -C contrib $@
+ 
+ distprep:
+ 	$(MAKE) -C doc $@
--- postgresql-8.2-8.2.3.orig/debian/patches/09-server-includedir.patch
+++ postgresql-8.2-8.2.3/debian/patches/09-server-includedir.patch
@@ -0,0 +1,12 @@
+diff -ruN postgresql-8.2.0-old/src/Makefile.global.in postgresql-8.2.0/src/Makefile.global.in
+--- postgresql-8.2.0-old/src/Makefile.global.in	2005-11-05 18:54:55.000000000 -0500
++++ postgresql-8.2.0/src/Makefile.global.in	2005-11-05 18:55:59.000000000 -0500
+@@ -133,7 +133,7 @@
+ 
+ # These derived path variables aren't separately configurable.
+ 
+-includedir_server = $(pkgincludedir)/server
++includedir_server = $(pkgincludedir)/8.2/server
+ includedir_internal = $(pkgincludedir)/internal
+ pgxsdir = $(pkglibdir)/pgxs
+ 
--- postgresql-8.2-8.2.3.orig/debian/postgresql-contrib-8.2.install
+++ postgresql-8.2-8.2.3/debian/postgresql-contrib-8.2.install
@@ -0,0 +1,35 @@
+usr/share/doc/postgresql-doc-8.2/contrib/* usr/share/doc/postgresql-contrib-8.2
+usr/share/postgresql/8.2/contrib/*
+usr/lib/postgresql/8.2/bin/oid2name
+usr/lib/postgresql/8.2/bin/pgbench
+usr/lib/postgresql/8.2/bin/vacuumlo
+usr/lib/postgresql/8.2/lib/_int.so
+usr/lib/postgresql/8.2/lib/autoinc.so
+usr/lib/postgresql/8.2/lib/btree_gist.so
+usr/lib/postgresql/8.2/lib/chkpass.so
+usr/lib/postgresql/8.2/lib/cube.so
+usr/lib/postgresql/8.2/lib/dblink.so
+usr/lib/postgresql/8.2/lib/earthdistance.so
+usr/lib/postgresql/8.2/lib/fuzzystrmatch.so
+usr/lib/postgresql/8.2/lib/insert_username.so
+usr/lib/postgresql/8.2/lib/int_aggregate.so
+usr/lib/postgresql/8.2/lib/lo.so
+usr/lib/postgresql/8.2/lib/ltree.so
+usr/lib/postgresql/8.2/lib/moddatetime.so
+usr/lib/postgresql/8.2/lib/pg_trgm.so
+usr/lib/postgresql/8.2/lib/pgcrypto.so
+usr/lib/postgresql/8.2/lib/pgstattuple.so
+usr/lib/postgresql/8.2/lib/refint.so
+usr/lib/postgresql/8.2/lib/seg.so
+usr/lib/postgresql/8.2/lib/tablefunc.so
+usr/lib/postgresql/8.2/lib/timetravel.so
+usr/lib/postgresql/8.2/lib/tsearch2.so
+usr/lib/postgresql/8.2/lib/pgxml.so
+usr/lib/postgresql/8.2/lib/pg_buffercache.so
+usr/lib/postgresql/8.2/lib/adminpack.so
+usr/lib/postgresql/8.2/lib/sslinfo.so
+usr/lib/postgresql/8.2/lib/isn.so
+usr/lib/postgresql/8.2/lib/hstore.so
+usr/lib/postgresql/8.2/lib/pgrowlocks.so
+usr/lib/postgresql/8.2/lib/pg_freespacemap.so
+
--- postgresql-8.2-8.2.3.orig/debian/copyright
+++ postgresql-8.2-8.2.3/debian/copyright
@@ -0,0 +1,110 @@
+This package was debianized by Martin Pitt <mpitt@debian.org>. 
+
+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.2-8.2.3.orig/debian/postgresql-doc-8.2.doc-base
+++ postgresql-8.2-8.2.3/debian/postgresql-doc-8.2.doc-base
@@ -0,0 +1,13 @@
+Document: postgresql-8.2
+Title: PostgreSQL 8.2 Documentation
+Author: The PostgreSQL Global Development Group
+Abstract: The documentation for the PostgreSQL database management system,
+ version 8.2. 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.2/html/index.html
+Files: /usr/share/doc/postgresql-doc-8.2/html/*
+
--- postgresql-8.2-8.2.3.orig/debian/postgresql-8.2.init
+++ postgresql-8.2-8.2.3/debian/postgresql-8.2.init
@@ -0,0 +1,55 @@
+#!/bin/sh -e
+
+### BEGIN INIT INFO
+# Provides:		postgresql postgresql-8.2
+# Required-Start:	$local_fs $network $time
+# Required-Stop:	$local_fs $network $time
+# Should-Start:		$syslog $remote_fs
+# Should-Stop:		$syslog $remote_fs
+# Default-Start:	2 3 4 5
+# Default-Stop:		S 0 1 6
+# Short-Description:	PostgreSQL 8.2 RDBMS server
+### END INIT INFO
+
+# Setting environment variables for the postmaster here does not work; please
+# set them in /etc/postgresql/8.2/<cluster>/environment instead.
+
+[ -r /usr/share/postgresql-common/init.d-functions ] || exit 0
+
+. /usr/share/postgresql-common/init.d-functions
+
+VERSION=8.2
+
+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.2-8.2.3.orig/debian/libpq5.shlibs
+++ postgresql-8.2-8.2.3/debian/libpq5.shlibs
@@ -0,0 +1 @@
+libpq 5 libpq5
--- postgresql-8.2-8.2.3.orig/debian/postgresql-contrib-8.2.postinst
+++ postgresql-8.2-8.2.3/debian/postgresql-contrib-8.2.postinst
@@ -0,0 +1,11 @@
+#!/bin/sh -e
+
+VERSION=8.2
+
+. /usr/share/postgresql-common/maintscripts-functions
+
+if [ "$1" = configure ]; then
+    configure_contrib_version $VERSION "$2"
+fi
+
+#DEBHELPER#
--- postgresql-8.2-8.2.3.orig/debian/postgresql-doc-8.2.dirs
+++ postgresql-8.2-8.2.3/debian/postgresql-doc-8.2.dirs
@@ -0,0 +1 @@
+/usr/share/doc/postgresql-doc-8.2/tutorial
--- postgresql-8.2-8.2.3.orig/.shelf/current-shelf
+++ postgresql-8.2-8.2.3/.shelf/current-shelf
@@ -0,0 +1 @@
+default
\ No newline at end of file