--- postgresql-8.2-8.2.11.orig/debian/postgresql-8.2.links +++ postgresql-8.2-8.2.11/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.11.orig/debian/rules +++ postgresql-8.2-8.2.11/debian/rules @@ -0,0 +1,90 @@ +#!/usr/bin/make -f +TCL_VER := 8.4 +DEB_TAR_SRCDIR:=postgresql-8.2.11 + +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 + +ifneq ($(findstring $(DEB_BUILD_ARCH), sparc mips mipsel),) + TESTSUITE_FAIL_CMD=true +else + TESTSUITE_FAIL_CMD=exit 1 +endif + +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:: +ifeq (, $(findstring nocheck, $(DEB_BUILD_OPTIONS))) + # patch away the "don't execute as root" check for the test + # suite; doing it here will ensure that the actual debs have + # the check. + set -e; cd build-tree/$(DEB_TAR_SRCDIR); \ + patch --no-backup-if-mismatch -p1 < ../../debian/disable-root-check.patch; \ + make check || fail=1; \ + patch --no-backup-if-mismatch -Rp1 < ../../debian/disable-root-check.patch; \ + if [ -n "$$fail" ]; then \ + for l in regression.diffs log/initdb.log log/postmaster.log; do \ + if [ -e src/test/regress/$$l ]; then \ + echo "********* $$l *******"; \ + cat src/test/regress/$$l; \ + fi; \ + done; \ + $(TESTSUITE_FAIL_CMD); \ + fi +endif + + # compress manpages + find debian/postgresql-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.11.orig/debian/libpgtypes2.install +++ postgresql-8.2-8.2.11/debian/libpgtypes2.install @@ -0,0 +1 @@ +usr/lib/libpgtypes.so.2* --- postgresql-8.2-8.2.11.orig/debian/changelog +++ postgresql-8.2-8.2.11/debian/changelog @@ -0,0 +1,1123 @@ +postgresql-8.2 (8.2.11-0ubuntu0.7.10) gutsy-proposed; urgency=low + + * New upstream bug fix release 8.2.11: (LP: #293758) + - Fix GiST index corruption due to marking the wrong index entry + "dead" after a deletion. This would result in index searches failing to + find rows they should have found. + - Fix backend crash when the client encoding cannot represent a + localized error message. + - Fix possible crash when deeply nested functions are invoked from a + trigger. + - Improve optimization of "expression" IN ("expression-list") queries. + Cases in which there are query variables on the right-hand side had + been handled less efficiently in 8.2.x and 8.3.x than in prior + versions. The fix restores 8.1 behavior for such cases. + - Fix mis-expansion of rule queries when a sub-SELECT appears in a + function call in FROM, a multi-row VALUES list, or a RETURNING list. + The usual symptom of this problem is an "unrecognized node type" + error. + - Fix memory leak during rescan of a hashed aggregation plan. + - Ensure an error is reported when a newly-defined PL/pgSQL trigger + function is invoked as a normal function. + - Prevent possible collision of relfilenode numbers when moving a + table to another tablespace with "ALTER SET TABLESPACE". + - Fix incorrect tsearch2 headline generation when single query item + matches first word of text. + - Fix improper display of fractional seconds in interval values when + using a non-ISO datestyle. + - Ensure SPI_getvalue and SPI_getbinval behave correctly when the + passed tuple and tuple descriptor have different numbers of columns. + This situation is normal when a table has had columns added or + removed, but these two functions didn't handle it properly. The + only likely consequence is an incorrect error indication. + - Fix ecpg's parsing of "CREATE ROLE". + - Fix recent breakage of pg_ctl restart. + * 03-gettext-domains.patch: Unfuzz for new release. + + -- Martin Pitt Tue, 04 Nov 2008 21:22:42 +0100 + +postgresql-8.2 (8.2.9-0ubuntu0.7.10) gutsy-proposed; urgency=low + + * New upstream bug fix release (note that 8.2.8 was never officially + released due to the discovery of another major bug): + - Make pg_get_ruledef() parenthesize negative constants. + Before this fix, a negative constant in a view or rule might be + dumped as, say, -42::integer, which is subtly incorrect: it should + be (-42)::integer due to operator precedence rules. Usually this + would make little difference, but it could interact with another + recent patch to cause PostgreSQL to reject what had been a valid + "SELECT DISTINCT" view query. Since this could result in pg_dump + output failing to reload, it is being treated as a high-priority + fix. + - Make "ALTER AGGREGATE ... OWNER TO" update pg_shdepend. + This oversight could lead to problems if the aggregate was later + involved in a "DROP OWNED" or "REASSIGN OWNED" operation. + - Fix "ALTER TABLE ADD COLUMN ... PRIMARY KEY" so that the new column + is correctly checked to see if it's been initialized to all + non-nulls. Previous versions neglected to check this requirement at all. + - Fix possible "CREATE TABLE" failure when inheriting the "same" + constraint from multiple parent relations that inherited that + constraint from a common ancestor. + - Fix pg_get_ruledef() to show the alias, if any, attached to the + target table of an "UPDATE" or "DELETE". + - Fix GIN bug that could result in a too many LWLocks taken failure. + - Avoid possible crash when decompressing corrupted data. + - Repair two places where SIGTERM exit of a backend could leave + corrupted state in shared memory. + - Fix conversions between ISO-8859-5 and other encodings to handle + Cyrillic "Yo" characters (e and E with two dots). + - Fix several datatype input functions, notably array_in(), that were + allowing unused bytes in their results to contain uninitialized, + unpredictable values. + This could lead to failures in which two apparently identical + literal values were not seen as equal, resulting in the parser + complaining about unmatched ORDER BY and DISTINCT expressions. + - Fix a corner case in regular-expression substring matching. + - Fix incorrect result from ecpg's PGTYPEStimestamp_sub() function. + - Fix broken GiST comparison function for "contrib/tsearch2"'s + tsquery type. + - Fix possible crashes in "contrib/cube" functions. + - Fix core dump in "contrib/xml2"'s xpath_table() function when the + input query returns a NULL value. + (LP: #238587) + + -- Martin Pitt Mon, 09 Jun 2008 17:32:57 +0200 + +postgresql-8.2 (8.2.7-0ubuntu0.7.10) gutsy-proposed; urgency=low + + * New upstream bug fix release: (LP: #203734) + - Repair potential deadlock between concurrent "VACUUM FULL" + operations on different system catalogs. + - Fix longstanding "LISTEN"/"NOTIFY" race condition. + - Disallow "LISTEN" and "UNLISTEN" within a prepared transaction. + This was formerly allowed but trying to do it had various + unpleasant consequences, notably that the originating backend could + not exit as long as an "UNLISTEN" remained uncommitted. + - Disallow dropping a temporary table within a prepared transaction + This was correctly disallowed by 8.1, but the check was + inadvertently broken in 8.2. + - Fix rare crash when an error occurs during a query using a hash + index. + - Fix memory leaks in certain usages of set-returning functions. + - Fix input of datetime values for February 29 in years BC. + - Fix "unrecognized node type" error in some variants of "ALTER + OWNER". + - Ensure pg_stat_activity.waiting flag is cleared when a lock wait is + aborted. + - Fix pg_ctl to correctly extract the postmaster's port number from + command-line options. (See Debian #358546) + - Use "-fwrapv" to defend against possible misoptimization in recent + gcc versions. + - Correctly enforce statement_timeout values longer than INT_MAX + microseconds (about 35 minutes). + - Fix "unexpected PARAM_SUBLINK ID" planner error when + constant-folding simplifies a sub-select. + - Fix logical errors in constraint-exclusion handling of IS NULL and + NOT expressions. + - Fix another cause of "failed to build any N-way joins" planner + errors. + - Fix incorrect constant propagation in outer-join planning. + - Fix display of constant expressions in ORDER BY and GROUP BY. + - Fix libpq to handle NOTICE messages correctly during COPY OUT. + * Remove debian/patches/00upstream-clauseless-joins-regression.patch, + upstream now. + + -- Martin Pitt Tue, 18 Mar 2008 23:26:14 +0100 + +postgresql-8.2 (8.2.6-0ubuntu0.7.10.1) gutsy-security; urgency=low + + * Upload 8.2.6 into gutsy-security. + * Add debian/patches/00upstream-clauseless-joins-regression.patch: + - Fix a regression of 8.2.6 wrt. large clauseless joins. + - Taken from upstream CVS: + http://archives.postgresql.org/pgsql-committers/2008-01/msg00164.php + + -- Martin Pitt Fri, 11 Jan 2008 16:29:39 +0100 + +postgresql-8.2 (8.2.6-0ubuntu0.7.10) gutsy-proposed; urgency=low + + * New upstream security/bugfix release: + - Prevent functions in indexes from executing with the privileges of + the user running "VACUUM", "ANALYZE", etc. "SET ROLE" is now forbidden + within a SECURITY DEFINER context. [CVE-2007-6600] + - Suitably crafted regular-expression patterns could cause crashes, + infinite or near-infinite looping, and/or massive memory + consumption, all of which pose denial-of-service hazards for + applications that accept regex search patterns from untrustworthy + sources. [CVE-2007-4769, CVE-2007-4772, CVE-2007-6067] + - Require non-superusers who use "/contrib/dblink" to use only + password authentication, as a security measure. + The fix that appeared for this in 8.2.5 was incomplete, as it + plugged the hole for only some "dblink" functions. [CVE-2007-6601, + CVE-2007-3278] + - Fix bugs in WAL replay for GIN indexes. + - Fix GIN index build to work properly when maintenance_work_mem is + 4GB or more. + - Improve planner's handling of LIKE/regex estimation in non-C + locales. + - Fix planning-speed problem for deep outer-join nests, as well as + possible poor choice of join order. + - Fix planner failure in some cases of WHERE false AND var IN (SELECT + ...). + - Make "CREATE TABLE ... SERIAL" and "ALTER SEQUENCE ... OWNED BY" + not change the currval() state of the sequence. + - Preserve the tablespace and storage parameters of indexes that are + rebuilt by "ALTER TABLE ... ALTER COLUMN TYPE". + - Make archive recovery always start a new WAL timeline, rather than + only when a recovery stop time was used. This avoids a corner-case risk + of trying to overwrite an existing archived copy of the last WAL + segment, and seems simpler and cleaner than the original definition. + - Make "VACUUM" not use all of maintenance_work_mem when the table is + too small for it to be useful. + - Fix potential crash in translate() when using a multibyte database + encoding. + - Make corr() return the correct result for negative correlation + values. + - Fix overflow in extract(epoch from interval) for intervals + exceeding 68 years. + - Fix PL/Perl to not fail when a UTF-8 regular expression is used in + a trusted function. + - Fix PL/Python to work correctly with Python 2.5 on 64-bit machines + (Marko Kreen) + - Fix PL/Python to not crash on long exception messages. + - Fix pg_dump to correctly handle inheritance child tables that have + default expressions different from their parent's. + - Fix libpq crash when PGPASSFILE refers to a file that is not a + plain file. + - ecpg parser fixes. + - Make "contrib/tablefunc"'s crosstab() handle NULL rowid as a + category in its own right, rather than crashing. + - Fix tsvector and tsquery output routines to escape backslashes + correctly. (LP: #146382) + - Fix crash of to_tsvector() on huge input strings. + * Drop debian/patches/00upstream-tsearch2-compareWORD.patch, upstream. + + -- Martin Pitt Sat, 05 Jan 2008 20:24:54 +0100 + +postgresql-8.2 (8.2.5-1.1) gutsy; urgency=low + + * Upload bzr head to Gutsy to get the fix below quickly. + * Add debian/patches/00upstream-tsearch2-compareWORD.patch: + - Fix tsearch2's compareWORD() function to return 0 on identical strings. + This avoids endless loops for situations where identical strings appear + in sort lists (which Should Not Happen™, but do anyway). + - Patch taken from upstream CVS: + http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/tsvector.c?r1=1.26&r2=1.26.2.1 + - Thanks to Stuart Bishop for finding the bug and providing a reproducer. + - (LP: #141637) + + -- Martin Pitt Fri, 28 Sep 2007 15:12:33 +0200 + +postgresql-8.2 (8.2.5-1) unstable; urgency=low + + * New upstream bugfix release: + - Require non-superusers who use "/contrib/dblink" to use only + password authentication, as a security measure. + [CVE-2007-3278, CVE-2007-3280] + - Fix ALTER DOMAIN ADD CONSTRAINT for cases involving domains over + domains. + - Make "CREATE DOMAIN ... DEFAULT NULL" work properly. + - Fix some planner problems with outer joins, notably poor size + estimation for t1 LEFT JOIN t2 WHERE t2.col IS NULL. + - Allow the interval data type to accept input consisting only of + milliseconds or microseconds. + - Allow timezone name to appear before the year in timestamp input. + - Fixes for GIN indexes used by "/contrib/tsearch2". + - Speed up rtree index insertion. + - Fix excessive logging of SSL error messages. + - Fix logging so that log messages are never interleaved when using + the syslogger process. + - Fix crash when log_min_error_statement logging runs out of memory. + - Fix incorrect handling of some foreign-key corner cases. + - Fix stddev_pop(numeric) and var_pop(numeric). + - Prevent "REINDEX" and "CLUSTER" from failing due to attempting to + process temporary tables of other sessions. + - Restrict "/contrib/pgstattuple" functions to superusers, for + security reasons. + - Do not let "/contrib/intarray" try to make its GIN opclass the + default (this caused problems at dump/restore). + * Remove debian/patches/00upstream-01-polymorphic-functions.patch: Upstream + now. + + -- Martin Pitt Sun, 16 Sep 2007 12:25:19 +0200 + +postgresql-8.2 (8.2.4-3) unstable; urgency=medium + + * Urgency medium since the dpkg bug above is nasty and I want this fixed in + testing ASAP. + * debian/postgresql-8.2.postinst: Work around dpkg bug #435938 by manually + doing the timezone symlink transition. Closes: #430524 + * debian/rules: Make binary-arch idempotent if test suite fails. + Closes: #431565 + + -- Martin Pitt Sat, 04 Aug 2007 14:07:00 +0200 + +postgresql-8.2 (8.2.4-2) unstable; urgency=low + + * debian/control: Remove some unnecessary build depends. Closes: #424010 + * debian/postgresql-8.2.install: Actually install the "timezone" symlink, + not the dereferenced files. + * Add debian/patches/12-m32r-tas.patch: + - Support m32r architecture, thanks to Kazuhiro Inaoka for the initial + patch. + - Backported from CVS head: + http://archives.postgresql.org/pgsql-committers/2007-05/msg00065.php + - Closes: #419267 + * Add debian/patches/00upstream-01-polymorphic-functions.patch: + - Fix breakage of polymorphic SQL functions (regression in 8.2.4), add + test cases. + - Patch taken from upstream CVS: + http://archives.postgresql.org/pgsql-committers/2007-05/msg00010.php + - Closes: #430347 + * debian/control: Fix libpq-dev Depends: line: ${Source-Version} -> + ${binary:Version}. + + -- Martin Pitt Sat, 23 Jun 2007 19:08:25 +0200 + +postgresql-8.2 (8.2.4-1) unstable; urgency=medium + + * New upstream security/bug fix release: + - Support explicit placement of the temporary-table schema within + search_path, and disable searching it for functions and operators. + This is needed to allow a security-definer function to set a truly + secure value of search_path. Without it, an unprivileged SQL user + can use temporary objects to execute code with the privileges of + the security-definer function (CVE-2007-2138). See "CREATE + FUNCTION" for more information. + - Fix to_char() so it properly upper/lower cases localized day or + month names. + - "/contrib/tsearch2" crash fixes. + - Require "COMMIT PREPARED" to be executed in the same database as + the transaction was prepared in. + - New traditional (Taiwan) Chinese FAQ. + - Prevent the statistics collector from writing to disk too + frequently. + - Fix potential-data-corruption bug in how "VACUUM FULL" handles + "UPDATE" chains. + - Fix bug in domains that use array types. + - Fix "pg_dump" so it can dump a serial column's sequence using "-t" + when not also dumping the owning table. + - Planner fixes, including improving outer join and bitmap scan + selection logic. + - Fix possible wrong answers or crash when a PL/pgSQL function tries + to RETURN from within an EXCEPTION block. + - Fix PANIC during enlargement of a hash index. + * debian/patches/04-timezone-symlinks.patch: Adapt to slightly changed + Makefile of 8.2.4. + * Remove debian/patches/12-vacuum-cycle-hang.patch: Fixed upstream. + * debian/postgresql-8.2.postrm: Fix bashism. + + -- Martin Pitt Fri, 20 Apr 2007 09:23:55 +0200 + +postgresql-8.2 (8.2.3-5) unstable; urgency=low + + * debian/rules: Do not let failed test suite fail the build on mips and + mipsel. The Debian buildds' kernels are still broken. + * debian/control: Add empty postgresql{,-client,-contrib,-doc} packages + which always point to the latest available version. + + -- Martin Pitt Sat, 14 Apr 2007 21:23:32 +0200 + +postgresql-8.2 (8.2.3-4) unstable; urgency=low + + * First upload to unstable: Welcome, Lenny! + + -- Martin Pitt Sat, 14 Apr 2007 13:52:28 +0200 + +postgresql-8.2 (8.2.3-3) experimental; urgency=low + + * debian/rules: Do not FTBFS on failed test suite on sparc. sparc throws a + 'floating point exception' instead of a 'division by zero' error, which is + fine, but differs from expected string output. Closes: #417160 + + -- Martin Pitt Wed, 4 Apr 2007 12:09:37 +0200 + +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 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 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 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 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 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 Sun, 3 Dec 2006 17:57:43 +0100 + +postgresql-8.2 (8.2~rc1-1) experimental; urgency=low + + * Release candidate 1. + + -- Martin Pitt Sun, 26 Nov 2006 15:59:11 +0100 + +postgresql-8.2 (8.2~beta3-1) experimental; urgency=low + + * New upstream beta release. + + -- Martin Pitt 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 ' 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 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 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 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 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 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 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 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 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 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 Mon, 10 Apr 2006 22:43:11 +0200 + +postgresql-8.1 (8.1.3-3) unstable; urgency=low + + * debian/postgresql-8.1.init: Use shell 'sh -e' instead of bash. + * debian/postgresql-contrib-8.1.install: Ship ora2pg.pl and Ora2Pg.pm. + * debian/control: Updated contrib package description. Closes: #355172 + * debian/rules: Don't special-case HPPA for --enable-thread-safety-force; + the current kernel seems to cope with threads quite well, so that the + configure check does not hang any more. Closes: #315440 + * debian/control: Build server packages on mips and mipsel again, even if + they do not work. No need to block testing migration forever (the + ftp-masters seem reluctant to remove the mips binaries, see #344487), and + the bug is in binutils, not PostgreSQL itself (see #357603). + + -- Martin Pitt Sat, 1 Apr 2006 22:13:03 +0200 + +postgresql-8.1 (8.1.3-2) unstable; urgency=low + + * Re-enable 'do not run as root' check from upstream: + - Move debian/patches/08-disable-root-check.patch to + debian/disable-root-check.patch. + - debian/rules: Move test suite to binary/predeb and apply + disable-root-check.patch manually right before calling the test suite. + Unapply debian/disable-root-check.patch after executing the + test suite to not break subsequent package builds. + - With this, the test suite can happily run as (fake)root during package + build without disabling the check in the actual packages. + * postgresql-doc-8.1: Ship tutorial C and SQL files. + (https://launchpad.net/bugs/30233) + * debian/control, postgresql-client-8.1: Depend on postgresql-client-common + instead of postgresql-common. + + -- Martin Pitt Sat, 18 Mar 2006 15:21:27 +0100 + +postgresql-8.1 (8.1.3-1) unstable; urgency=low + + * New upstream security and bug fix release: + - Fix bug that allowed any logged-in user to "SET ROLE" to any other + database user id (CVE-2006-0553). + - See upstream changelog for detailled changes. + * Remove debian/patches/80-cvs-pg_restore-COPY.patch: Upstream now. + * debian/rules: Use --as-needed linker option to avoid excessive + library dependencies. + * debian/control: Remove unnecessary dependencies from PL/Python and PL/Tcl + packages. + + -- Martin Pitt Tue, 14 Feb 2006 17:46:31 +0100 + +postgresql-8.1 (8.1.2-2) unstable; urgency=low + + * debian/patches/09-relax-sslkey-permscheck.patch: Do not check for any + particular group if the SSL key is group readable, to allow sharing a + common SSL certificate with other server processes. + * debian/control: Add ${shlibs:Depends} to packages which need it. + Closes: #348066 + * debian/control, libecpg5: Remove obsolete Provides/Conflicts to ecpg. + * Add debian/patches/80-cvs-pg_restore-COPY.patch: + - Fix pg_restore to properly discard COPY data when trying to continue + after an error in a COPY statement. Formerly it thought the COPY data + was SQL commands, and got quite confused. + - Patch from Stephen Frost, taken from upstream CVS. + * Add debian/patches/12-krb5-multiusers.patch: + - Fix krb5 credential handling in libpq for multiple connections with + different users: Don't keep credentials in global variables, but pass + them around in a new krb5_info struct. + - Patch from Stephen Frost, proposed to be adopted upstream. + + -- Martin Pitt Mon, 6 Feb 2006 21:07:31 +0100 + +postgresql-8.1 (8.1.2-1) unstable; urgency=medium + + * New upstream bugfix release: + - Fix bug introduced in 8.0 that could allow ReadBuffer to return an + already-used page as new, potentially causing loss of recently-committed + data. + - Fix for protocol-level Describe messages issued outside a + transaction or in a failed transaction. + - Fix character string comparison for locales that consider different + character combinations as equal, such as Hungarian. + This might require "REINDEX" to fix existing indexes on textual + columns. + - Set locale environment variables during postmaster startup to + ensure that plperl won't change the locale later. This fixes a problem + that occurred if the postmaster was started + with environment variables specifying a different locale than what + initdb had been told. Under these conditions, any use of plperl was + likely to lead to corrupt indexes. You may need "REINDEX" to fix + existing indexes on textual columns if this has happened to you. + (postgresql-common checks and aborts on this condition.) + - Allow more flexible relocation of installation directories. + Previous releases supported relocation only if all installation + directory paths were the same except for the last component. + This makes the test suite work with Debian's directory structure, so + that the horology test can find the timezones again and pass. + - Prevent crashes caused by the use of ISO-8859-5 and ISO-8859-9 + encodings. + - Fix longstanding bug in strpos() and regular expression handling in + certain rarely used Asian multi-byte character sets. + - Fix bug where COPY CSV mode considered any \. to terminate the copy + data. The new code requires \. to appear alone on a line, as per + documentation. + - Make COPY CSV mode quote a literal data value of \. to ensure it + cannot be interpreted as the end-of-data marker. + - Various fixes for functions returning RECORDs. + - Fix processing of "postgresql.conf" so a final line with no newline + is processed properly. + - Fix bug in "/contrib/pgcrypto" gen_salt, which caused it not to use + all available salt space for MD5 and XDES algorithms. Salts for + Blowfish and standard DES are unaffected. + - Fix autovacuum crash when processing expression indexes. + - Fix "/contrib/dblink" to throw an error, rather than crashing, when + the number of columns specified is different from what's actually + returned by the query. + * Remove debian/patches/12-readline-prompt-ignore.patch: Adopted upstream. + * Bump postgresql-common dependencies to >= 39. This will ensure more + robust upgrades and other bug fixes. + + -- Martin Pitt Mon, 9 Jan 2006 18:34:31 +0100 + +postgresql-8.1 (8.1.1-2) unstable; urgency=low + + * Do not build postgresql-8.1, p-contrib-8.1, and the PL/ packages on mips + and mipsel, since the postmaster just SIGBUSes on these architectures and + nobody seems to be able to fix that. + * Add debian/patches/12-readline-prompt-ignore.patch: Do not prepend a + '\001' before the 'prompt ignore begin/end' readline commands; this is a + bash quirk, not a readline feature. Thanks to Aaron Schrab. + Closes: #343616 + + -- Martin Pitt Thu, 22 Dec 2005 19:13:21 +0100 + +postgresql-8.1 (8.1.1-1) unstable; urgency=low + + * New upstream bug fix release. + * Remove debian/patches/80_cvs_crash_deform_tuple.patch, upstream now. + * debian/postgresql-8.1.postrm: Also clean start.conf if purging without + pg_dropcluster. + * debian/postgresql-8.1.postrm: Check if a /etc/postgresql/8.1 subdirectory + is really a cluster directory before trying to remove it. Closes: #339810 + * Ship upstream changelog. + + -- Martin Pitt Mon, 12 Dec 2005 17:27:57 +0100 + +postgresql-8.1 (8.1.0-3) unstable; urgency=low + + * debian/rules: Remove superfluous R include path. + * debian/control: Version the libpq-dev dependency of -server-dev-8.1 to + avoid horrible breakage. + * Add debian/patches/80_cvs_crash_deform_tuple.patch: + - Fix crash in tuple deformator (stolen from CVS head). + - Closes: #339527 + * Add debian/patches/52-contrib-dbase-enable-iconv.patch: + - Enable iconv support for 'dbf2pg' contrib module. + - Closes: #338645 + + -- Martin Pitt Sun, 20 Nov 2005 17:01:53 +0100 + +postgresql-8.1 (8.1.0-2) unstable; urgency=low + + * Do not install pg_config and its mo files into postgresql-server-dev-8.1 + any more, since libpq-dev now ships it. Closes: #338231 + * debian/control: Clean up contrib description. Closes: #338308 + + -- Martin Pitt Wed, 9 Nov 2005 20:29:16 -0500 + +postgresql-8.1 (8.1.0-1) unstable; urgency=low + + * Final 8.1.0 upstream release, first unstable upload. + * Build client libraries (-8.0 does not build them any more). + * Add debian/patches/11-server-includedir.patch: Change server include + directory to /usr/include/postgresql/8.1/server since we do want to + keep apart server include files. + + -- Martin Pitt Sat, 5 Nov 2005 18:57:00 -0500 + +postgresql-8.1 (8.0+8.1rc1-1) experimental; urgency=low + + * Upgrade to 8.1rc1 release. + + -- Martin Pitt Mon, 31 Oct 2005 17:43:19 -0500 + +postgresql-8.1 (8.0+8.1beta4-2) experimental; urgency=low + + * Clean up the installation path ./configure arguments. + - debian/rules: Use default libdir /usr/lib. + - Add debian/patches/10-pkglibdir.patch: Set pkglibdir to + /usr/lib/postgresql/8.1/lib instead of /usr/lib/postgresql. + + -- Martin Pitt Wed, 26 Oct 2005 20:45:02 +0100 + +postgresql-8.1 (8.0+8.1beta4-1) experimental; urgency=low + + * Upgrade to 8.1beta4 release. + * Adopt patches to new upstream version: + - 09-relax-sslkey-permscheck.patch + * debian/postgresql-8.1.postrm: clean_dir(): Ensure that directory is not a + symbolic link before attempting to rmdir it. Closes: #333867 + * debian/rules: Remove obsolete --disable-spinlocks build option for mips. + + -- Martin Pitt Mon, 24 Oct 2005 16:59:53 +0200 + +postgresql-8.1 (8.0+8.1beta3-1) experimental; urgency=low + + * Upgrade to 8.1beta3 release. + * Drop debian/patches/81-beta2.patch: beta2->beta3 changes are too big to be + sensibly stuffed into a patch. + * Adopt patches to new upstream version: + - 03-gettext-domains.patch + * Remove patches which are upstream now: + - 52-contrib-dbf2pg-errorcheck.patch + - 53-contrib-dbf2pg-textfield + * debian/patches/09-relax-sslkey-permscheck.patch: Use effective rather than + real group id for checking the private SSL certificate permissions. It + does not make any practical difference, but is more consistent. + * Rename patch 01-top-makefile.patch to 01-build-contrib.patch to give a + better idea of what it does. + + -- Martin Pitt Thu, 13 Oct 2005 18:32:33 +0200 + +postgresql-8.1 (8.0+8.1beta-4) experimental; urgency=low + + * Add debian/patches/09-relax-sslkey-permscheck.patch: + - Relax security check on private SSL key file: The file is also + considered safe if it has owner and/or group "root", and if it is + group-readable (unless the group is something other than root or the + database owner group). + - See bug #327901. + + -- Martin Pitt Wed, 21 Sep 2005 22:52:39 +0200 + +postgresql-8.1 (8.0+8.1beta-3) experimental; urgency=low + + * Add debian/patches/81-beta2.patch: Upgrade to 8.1beta2 release. + * Remove debian/patches/80-s_lock.h-m68k.patch: Included upstream now. + + -- Martin Pitt Mon, 19 Sep 2005 08:31:22 +0200 + +postgresql-8.1 (8.0+8.1beta-2) experimental; urgency=low + + * debian/postgresql-8.1.postrm: Do not remove an empty /var/log/postgresql, + postgresql-common now cares for it to not break log rotation. (See + #325330) + * Remove debian/postgresql-server-dev-8.1.manpages: Do not install the + manpage, since it belongs to libpq-dev (which is currently built by + postgresql-8.0). Closes: #327379 + * debian/postgresql-server-dev-8.1.install: Ship pg_config. + * Build-depend on libpq-dev to pull in libpq4 dependencies for binary + packages. This hack is necessary as long as we build libpq from + postgresql-8.0. Closes: #327765 + + -- Martin Pitt Tue, 13 Sep 2005 22:04:54 +0200 + +postgresql-8.1 (8.0+8.1beta-1) experimental; urgency=low + + * First public beta version. + + -- Martin Pitt Fri, 26 Aug 2005 09:00:47 +0200 + +postgresql-8.1 (8.0+8.1alpha-1) experimental; urgency=low + + * New upstream snapshot release. The first beta is close to be released, and + I want to be prepared for that. + * Package based on postgresql-8.0 8.0.3-13; don't build client libraries yet + until 8.1 final is released. + + -- Martin Pitt Wed, 24 Aug 2005 08:34:00 +0200 + +postgresql-8.0 (8.0.3-13) unstable; urgency=low + + * debian/control: Fix libpq4 description, it is compatible with servers + starting from 7.3. + * Move back client include files to /usr/include/postgresql/ for now to + not render all client packages unbuildable which have not yet converted + to pg_config: + - debian/rules: Configure with include dir /usr/include/postgresql. + - debian/libecpg-dev.install, debian/libpq-dev.install: Install files from + and to /usr/include/postgresql + - Add debian/patches/13_server_includedir.patch: Change server include + directory back to /usr/include/postgresql/8.0/server since we do want to + keep apart server include files. + - Closes: #322085 + * Drop obsolete xml contrib module, build and ship xml2 instead: + - Remove debian/patches/51-contrib-xml-enable.patch + - Add debian/patches/51-contrib-xml2-enable.patch + - debian/control: Add build dependency libxslt1-dev. + - debian/postgresql-contrib-8.0.install: Ship pgxml.so, drop pgxml_dom.so. + - Closes: #322777 + * Add debian/patches/14-mips-gcc4.patch: + - Add a proper test-and-set function for mips and mipsel. Thanks to Thiemo + Seufer for the patch and Aurelien Jarno for his help. This now also + works with gcc 4. + * debian/rules: Remove the --disable-spinlocks option for mips again, now + that we have a proper patch for that. + + -- Martin Pitt Sat, 20 Aug 2005 17:34:01 +0200 + +postgresql-8.0 (8.0.3-12) unstable; urgency=low + + * debian/rules: + - Robustify log output in case of a failed test suite; also print out + regression.diffs if it fails. Closes: #319218 + - Don't run the test suite if DEB_BUILD_OPTIONS contains "nocheck". + * Add debian/check_installed_files to check for upstream installed files + which are not shipped in any deb. + * debian/postgresql-contrib-8.0.install: Ship pgxml_dom.so. Closes: #318922 + + -- Martin Pitt Sun, 24 Jul 2005 17:35:56 +0200 + +postgresql-8.0 (8.0.3-11) unstable; urgency=low + + * Add debian/patches/12-disable-root-check.patch: Disable "am I root" test + in initdb and postmaster to be able to run the test suite at build time. + This check is already done in pg_createcluster. + * debian/rules: Remove all the chown/setuid crack and simply call "make + check" now; print the log files if the test fails. + * debian/patches/10-testsuite-params.patch: Disable authentication in the + test suite db since ident authentication does not work with fakeroot. + + -- Martin Pitt Fri, 15 Jul 2005 13:31:51 +0300 + +postgresql-8.0 (8.0.3-10) unstable; urgency=low + + * debian/rules: If the test suite fails, don't let the build fail but rather + cat the log files. Once the test suite calling works reliably, the + previous behaviour can be restored. + + -- Martin Pitt Thu, 14 Jul 2005 14:19:30 +0300 + +postgresql-8.0 (8.0.3-9) unstable; urgency=low + + * Bump Standards-Version to 3.6.2. + * debian/rules: Use start-stop-daemon instead of su to call the test suite + since su requires a terminal. + * debian/rules: Disable spinlocks on mips and mipsel for now since they + FTBFS with gcc-4.0. + + -- Martin Pitt Wed, 13 Jul 2005 22:22:59 +0300 + +postgresql-8.0 (8.0.3-8) unstable; urgency=low + + * postgresql-client-8.0: Now suggest postgresql-8.0; clarified the + description wrt the server package (see #313247). + * Fix README.Debian symlink. + * Add debian/patches/10-testsuite-params.patch: Use /tmp as the socket + directory when running the test suite. + * debian/rules: Call the test suite when building the package. Since + creating databases as root is not permitted, do this as "nobody" if run by + root (as on the buildds); don't do it at all if run with fakeroot. + + -- Martin Pitt Tue, 12 Jul 2005 19:10:03 +0300 + +postgresql-8.0 (8.0.3-7) unstable; urgency=low + + * Removed some redundant configure options which cdbs applies anyway. + * configure with --enable-thread-safety-force on HPPA since the configure + check triggers a kernel bug on the buildd. (See #315440) + * debian/postgresql-8.0.init: autovac-* functions in postgresql-common were + renamed to autovac_* to comply to POSIX shell standard (see #315551). + Adaped dependencies. + + -- Martin Pitt Sun, 26 Jun 2005 14:23:32 +0200 + +postgresql-8.0 (8.0.3-6) unstable; urgency=low + + * Added debian/postgresql-8.0.links: Symlink README.Debian from + postgresql-common. + * Added debian/patches/08-timezone-inttimestamps.patch (stolen from CVS + head): Fix integer timestamps in time zone handling. + Closes: #249417, #311533. + * debian/rules: Fix POT file generation. + * Added debian/patches/09-libpq-defaultsocketdir.patch: + - Set default socket directory for libpq to /var/run/postgresql. + Closes: #313507, #313602 + * Adjusted packages to follow upstream library SONAME change in 8.0.3: + libecpg4 -> libecpg5, libecpg-compat1 -> libecpg-compat2, + libpgtypes1 -> libpgtypes2. Closes: #313452, #313453, #313454 + + -- Martin Pitt Tue, 14 Jun 2005 19:58:10 +0200 + +postgresql-8.0 (8.0.3-5) unstable; urgency=low + + * debian/rules: Generate POT files to help translators. + * Added debian/libpq-dev.manpages: Install pg_wrapper(1) manpage. + Closes: #311671 + * debian/control: Restrict libpq-dev conflict to postgresql-dev to + versions << 7.5. Closes: #312827 + + -- Martin Pitt Fri, 10 Jun 2005 19:01:20 +0200 + +postgresql-8.0 (8.0.3-4) unstable; urgency=low + + * First unstable upload. + * debian/control: Now build with libreadline5-dev instead of version 4. + + -- Martin Pitt Tue, 7 Jun 2005 12:15:43 +0200 + +postgresql-8.0 (8.0.3-3) experimental; urgency=low + + * Added libpq4 dependency to libpq-dev. + * postgresql-contrib-8.0.install: Correct paths to install missing shared + files and documentation. (Closes: #311553) + * libpq-dev.install: Install some more header files from server/ which are + required by client libraries. + + -- Martin Pitt Mon, 6 Jun 2005 12:24:57 +0200 + +postgresql-8.0 (8.0.3-2) experimental; urgency=low + + * Added CAN numbers to previous changelog entries. + * debian/patches/07-postgresql.conf.patch: Enable listen_addresses = '*' by + default. + * debian/control, libpq-dev: Conflict to and replace postgresql-dev. + + -- Martin Pitt Tue, 31 May 2005 11:09:48 +0200 + +postgresql-8.0 (8.0.3-1) experimental; urgency=low + + * New upstream release: + - Prevent calling conversion functions by users. [CAN-2005-1409] + - Prevent calling tsearch2 functions by users. [CAN-2005-1410] + * debian/libpq-dev.{install,links}: Install pg_config into + /usr/lib/postgresql/8.0/bin to make it print correct paths, and install a + symlink into /usr/bin instead. Closes: #305200 + * debian/rules: Change include dir configure option to + /usr/include/postgresql/8.0, so that different versions of + postgresql-server-dev- do not conflict with each other. Since + applications using the libpq-dev are supposed to use pg_config, this + should not break them either. + + -- Martin Pitt Thu, 12 May 2005 23:37:56 +0200 + +postgresql-8.0 (8.0.2-1) experimental; urgency=low + + * New upstream release: + - Removed debian/patches/02-libpq-soname.patch, upstream adopted SONAME + change to libpq4. + * Ship "reindexdb" in -contrib. + * Added debian/patches/02_pager.patch: Use /usr/bin/pager as default pager + in psql. Closes: #304459 + * Added debian/postgresql-doc-8.0.doc-base: Register doc package in + doc-base. + + -- Martin Pitt Tue, 19 Apr 2005 21:19:50 +1000 + +postgresql-8.0 (8.0.1-4) experimental; urgency=low + + * Ship pg_config in libpq-dev instead of postgresql-8.0; added + proper package conflict. Closes: #303257 + * Install pg_config in /usr/bin instead of 8.0-specific bin dir. + Closes: #302368 + * debian/postgresql-8.0.init: Added autovacuum functions. + + -- Martin Pitt Tue, 5 Apr 2005 23:15:31 +0200 + +postgresql-8.0 (8.0.1-3) experimental; urgency=low + + * Dropped pgxs package, the Makefiles are now part of postgresql-server-dev. + * -contrib: Only recommend, not depend on libpg-perl and libdbd-pg-perl. + * Renamed packages pg-pl*-8.0 to postgresql-pl*-8.0 for consistency. + * Added debian/patches/07-postgresql.conf.patch: + - Patch for Debian changes to the default configuration. + - Enable stats_row_level to allow pg_autovacuum to work. + + -- Martin Pitt Sat, 2 Apr 2005 18:21:57 +0200 + +postgresql-8.0 (8.0.1-2) experimental; urgency=low + + * Changed dependency of pg-pltcl-8.0 from libtcl8.4 to tcl8.4 + * Now depend on postgresql-common >= 3 which provides more maintainer script + functions. + * Compress manpages. + + -- Martin Pitt Sun, 20 Mar 2005 21:23:10 +0100 + +postgresql-8.0 (8.0.1-1) experimental; urgency=low + + * New upstream release. Closes: #274043, #291350 + - Ignores shell backticks with invalid meta-commands. Closes: #285844 + - Fixes uninitialized error strings when connecting to a server which is + down. Closes: #264603, #277757 + - configure script supports GNU/Hurd and GNU/k*BSD. Closes: #262081 + - Fixes comma splices in HTML documentation. Closes: #243781 + - Now upper() and lower() work also for Unicode characters. + Closes: #139389, #290118, #290399 + - New configuration variable max_stack_depth which prevents DoS situations + due to infinite recursion. Closes: #239811 + - Reportedly works with Turkish locale. Closes: #305886 + - This version is not vulnerable against the following security issues: + . Load arbitrary shared libs, execute startup function [CAN-2005-0227] + . Execute functions with aggregate wrapper [CAN-2005-0244] + . Buffer overflow and 64-bit issues in contrib/intagg [CAN-2005-0246] + . Buffer overflows in the PL/PGSQL parser in gram.y [CAN-2005-0247] + . Insecure temporary files in make_oidjoins_check [CAN-2004-0977] + * Splitted development package into libpq-dev and postgresql-server-dev. + Closes: #280417 + * Splitted libecpg4 into libecpg4, libecpg-compat1 and libpgtypes1. + * Old libpgtcl package does not exist any more. The PL/TCL procedural + language is now shipped in pg-pltcl8.0, the TCL client library is not + shipped by PostgreSQL any more. Closes: #280418 + * Now use /var/lib/postgresql/ as (default) data directory. Closes: #285929 + + -- Martin Pitt Sun, 20 Feb 2005 19:17:17 +0100 + --- postgresql-8.2-8.2.11.orig/debian/postgresql-server-dev-8.2.install +++ postgresql-8.2-8.2.11/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.11.orig/debian/libecpg-compat2.install +++ postgresql-8.2-8.2.11/debian/libecpg-compat2.install @@ -0,0 +1 @@ +usr/lib/libecpg_compat.so.2* --- postgresql-8.2-8.2.11.orig/debian/postgresql-contrib-8.2.install +++ postgresql-8.2-8.2.11/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.11.orig/debian/libecpg-dev.manpages +++ postgresql-8.2-8.2.11/debian/libecpg-dev.manpages @@ -0,0 +1 @@ +debian/tmp/usr/share/postgresql/8.2/man/man1/ecpg.1 --- postgresql-8.2-8.2.11.orig/debian/postgresql-8.2.install +++ postgresql-8.2-8.2.11/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.11.orig/debian/postgresql-doc-8.2.dirs +++ postgresql-8.2-8.2.11/debian/postgresql-doc-8.2.dirs @@ -0,0 +1 @@ +/usr/share/doc/postgresql-doc-8.2/tutorial --- postgresql-8.2-8.2.11.orig/debian/watch +++ postgresql-8.2-8.2.11/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.11.orig/debian/postgresql-plperl-8.2.install +++ postgresql-8.2-8.2.11/debian/postgresql-plperl-8.2.install @@ -0,0 +1 @@ +usr/lib/postgresql/8.2/lib/plperl.so --- postgresql-8.2-8.2.11.orig/debian/disable-root-check.patch +++ postgresql-8.2-8.2.11/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.11.orig/debian/libpq5.install +++ postgresql-8.2-8.2.11/debian/libpq5.install @@ -0,0 +1,2 @@ +usr/lib/libpq.so.5* +usr/share/locale/*/LC_MESSAGES/libpq5.mo --- postgresql-8.2-8.2.11.orig/debian/postgresql-8.2.prerm +++ postgresql-8.2-8.2.11/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.11.orig/debian/libpq-dev.install +++ postgresql-8.2-8.2.11/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.11.orig/debian/postgresql-doc-8.2.doc-base +++ postgresql-8.2-8.2.11/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.11.orig/debian/copyright +++ postgresql-8.2-8.2.11/debian/copyright @@ -0,0 +1,110 @@ +This package was debianized by Martin Pitt . + +PostgreSQL was downloaded from ftp://ftp.postgresql.org/mirror/postgresql/src/ + +Please note that there are many other mirrors, listed on +http://www.postgresql.org/mirrors-ftp.html. + +Copyright. The following copyright applies to the entire distribution: + + PostgreSQL Data Base Management System + (formerly known as Postgres, then as Postgres95). + + Portions Copyright (c) 1996-2003, The PostgreSQL Global Development Group + + Portions Copyright (c) 1994, The Regents of the University of California + + Permission to use, copy, modify, and distribute this software and its + documentation for any purpose, without fee, and without a written agreement + is hereby granted, provided that the above copyright notice and this + paragraph and the following two paragraphs appear in all copies. + + IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR + DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING + LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS + DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE + POSSIBILITY OF SUCH DAMAGE. + + THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, + INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY + AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS + ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO + PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. + + +The following copyright applies to the regex code in the backend +(src/backend/regex): + + Copyright (c) 1998, 1999 Henry Spencer. All rights reserved. + + Development of this software was funded, in part, by Cray Research Inc., + UUNET Communications Services Inc., Sun Microsystems Inc., and Scriptics + Corporation, none of whom are responsible for the results. The author + thanks all of them. + + Redistribution and use in source and binary forms -- with or without + modification -- are permitted for any purpose, provided that + redistributions in source form retain this entire copyright notice and + indicate the origin and nature of any modifications. + + I'd appreciate being given credit for this package in the documentation + of software which uses it, but that is not a requirement. + + THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, + INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY + AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL + HENRY SPENCER BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, + EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, + PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; + OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, + WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR + OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF + ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. + +PostgreSQL adopted the code out of Tcl 8.4.1. Portions of regc_locale.c +and re_syntax.n were developed by Tcl developers other than Henry; these +files bear the Tcl copyright and license notice: + + This software is copyrighted by the Regents of the University of + California, Sun Microsystems, Inc., Scriptics Corporation, ActiveState + Corporation and other parties. The following terms apply to all files + associated with the software unless explicitly disclaimed in + individual files. + + The authors hereby grant permission to use, copy, modify, distribute, + and license this software and its documentation for any purpose, provided + that existing copyright notices are retained in all copies and that this + notice is included verbatim in any distributions. No written agreement, + license, or royalty fee is required for any of the authorized uses. + Modifications to this software may be copyrighted by their authors + and need not follow the licensing terms described here, provided that + the new terms are clearly indicated on the first page of each file where + they apply. + + IN NO EVENT SHALL THE AUTHORS OR DISTRIBUTORS BE LIABLE TO ANY PARTY + FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES + ARISING OUT OF THE USE OF THIS SOFTWARE, ITS DOCUMENTATION, OR ANY + DERIVATIVES THEREOF, EVEN IF THE AUTHORS HAVE BEEN ADVISED OF THE + POSSIBILITY OF SUCH DAMAGE. + + THE AUTHORS AND DISTRIBUTORS SPECIFICALLY DISCLAIM ANY WARRANTIES, + INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, + FITNESS FOR A PARTICULAR PURPOSE, AND NON-INFRINGEMENT. THIS SOFTWARE + IS PROVIDED ON AN "AS IS" BASIS, AND THE AUTHORS AND DISTRIBUTORS HAVE + NO OBLIGATION TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR + MODIFICATIONS. + + GOVERNMENT USE: If you are acquiring this software on behalf of the + U.S. government, the Government shall have only "Restricted Rights" + in the software and related documentation as defined in the Federal + Acquisition Regulations (FARs) in Clause 52.227.19 (c) (2). If you + are acquiring the software on behalf of the Department of Defense, the + software shall be classified as "Commercial Computer Software" and the + Government shall have only "Restricted Rights" as defined in Clause + 252.227-7013 (c) (1) of DFARs. Notwithstanding the foregoing, the + authors grant the U.S. Government and others acting in its behalf + permission to use and distribute the software in accordance with the + terms specified in this license. + +Subsequent modifications to the code by the PostgreSQL project follow +the same license terms as the rest of PostgreSQL. --- postgresql-8.2-8.2.11.orig/debian/postgresql-client-8.2.prerm +++ postgresql-8.2-8.2.11/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.11.orig/debian/postgresql-contrib-8.2.prerm +++ postgresql-8.2-8.2.11/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.11.orig/debian/postgresql-client-8.2.postinst +++ postgresql-8.2-8.2.11/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.11.orig/debian/libecpg-dev.install +++ postgresql-8.2-8.2.11/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.11.orig/debian/libpq-dev.links +++ postgresql-8.2-8.2.11/debian/libpq-dev.links @@ -0,0 +1 @@ +/usr/lib/postgresql/8.2/bin/pg_config /usr/bin/pg_config --- postgresql-8.2-8.2.11.orig/debian/postgresql-pltcl-8.2.install +++ postgresql-8.2-8.2.11/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.11.orig/debian/pycompat +++ postgresql-8.2-8.2.11/debian/pycompat @@ -0,0 +1 @@ +2 --- postgresql-8.2-8.2.11.orig/debian/compat +++ postgresql-8.2-8.2.11/debian/compat @@ -0,0 +1 @@ +5 --- postgresql-8.2-8.2.11.orig/debian/postgresql-doc-8.2.install +++ postgresql-8.2-8.2.11/debian/postgresql-doc-8.2.install @@ -0,0 +1 @@ +usr/share/doc/postgresql-doc-8.2/html/* --- postgresql-8.2-8.2.11.orig/debian/postgresql-8.2.postrm +++ postgresql-8.2-8.2.11/debian/postgresql-8.2.postrm @@ -0,0 +1,53 @@ +#!/bin/sh -e + +#DEBHELPER# + +VERSION=8.2 + +clean_dir() { + if [ -d "$1" ] && [ ! -L "$1" ]; then + rmdir "$1" >/dev/null 2>/dev/null || true + fi +} + +drop_cluster() { + # if we still have the postgresql-common package, use it to also shutdown + # server, etc.; otherwise just remove the directories + if [ -x /usr/bin/pg_dropcluster ]; then + pg_dropcluster --stop-server $VERSION "$1" + else + # remove data directory + 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.11.orig/debian/postgresql-client-8.2.install +++ postgresql-8.2-8.2.11/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.11.orig/debian/postgresql-contrib-8.2.postinst +++ postgresql-8.2-8.2.11/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.11.orig/debian/libecpg5.install +++ postgresql-8.2-8.2.11/debian/libecpg5.install @@ -0,0 +1 @@ +usr/lib/libecpg.so.5* --- postgresql-8.2-8.2.11.orig/debian/control +++ postgresql-8.2-8.2.11/debian/control @@ -0,0 +1,291 @@ +Source: postgresql-8.2 +Section: misc +Priority: optional +Maintainer: Ubuntu Core Developers +XSBC-Original-Maintainer: Martin Pitt +Standards-Version: 3.7.2 +XS-Python-Version: current +Build-Depends: debhelper (>= 5.0.37.2), cdbs (>= 0.4.43), perl (>= 5.8), libperl-dev, tcl8.4-dev, 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 (= ${binary: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. + +Package: postgresql +Architecture: all +Section: misc +Depends: postgresql-8.2 +Description: object-relational SQL database (latest version) + PostgreSQL is a fully featured object-relational database management + system. It supports a large part of the SQL standard and is designed + to be extensible by users in many aspects. Some of the features are: + ACID transactions, foreign keys, views, sequences, subqueries, + triggers, user-defined types and functions, outer joins, multiversion + concurrency control. Graphical user interfaces and bindings for many + programming languages are available as well. + . + This package always depends on the latest available database server + for PostgreSQL. + +Package: postgresql-client +Architecture: all +Section: misc +Depends: postgresql-client-8.2 +Description: front-end programs for PostgreSQL (latest version) + This package contains client and administrative programs for + PostgreSQL: these are the interactive terminal client psql and + programs for creating and removing users and databases. + . + This package always depends on the latest available database client + package for PostgreSQL. If you install PostgreSQL on a standalone + machine, you need the server package postgresql, too. On a network, + you can install this package on many client machines, while the + server package may be installed on only one machine. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-doc +Architecture: all +Section: doc +Depends: postgresql-doc-8.2 +Description: documentation for the PostgreSQL database management system + This package contains all README files, user manual, and examples for + the latest available PostgreSQL version. The manual is in HTML format. + . + PostgreSQL is an object-relational SQL database management system. + +Package: postgresql-contrib +Architecture: all +Section: misc +Depends: postgresql-contrib-8.2 +Description: additional facilities for PostgreSQL (latest version) + The PostgreSQL contrib package provides several additional features + for the PostgreSQL database. contrib often serves as a testbed for + features before they are adopted into PostgreSQL proper. + . + This package always depends on the latest available contrib package + for PostgreSQL. + . + PostgreSQL is an object-relational SQL database management system. --- postgresql-8.2-8.2.11.orig/debian/postgresql-8.2.postinst +++ postgresql-8.2-8.2.11/debian/postgresql-8.2.postinst @@ -0,0 +1,19 @@ +#!/bin/sh -e + +VERSION=8.2 + + +if [ "$1" = configure ]; then + # work around dpkg bug #435938: not replacing directories with symlinks on + # upgrades + if ! [ -L /usr/share/postgresql/8.2/timezone ]; then + rmdir /usr/share/postgresql/8.2/timezone + ln -s ../../zoneinfo /usr/share/postgresql/8.2/timezone + fi + + . /usr/share/postgresql-common/maintscripts-functions + + configure_version $VERSION "$2" +fi + +#DEBHELPER# --- postgresql-8.2-8.2.11.orig/debian/postgresql-8.2.init +++ postgresql-8.2-8.2.11/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//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.11.orig/debian/libpq-dev.manpages +++ postgresql-8.2-8.2.11/debian/libpq-dev.manpages @@ -0,0 +1 @@ +debian/tmp/usr/share/postgresql/8.2/man/man1/pg_config.1 --- postgresql-8.2-8.2.11.orig/debian/libpq5.shlibs +++ postgresql-8.2-8.2.11/debian/libpq5.shlibs @@ -0,0 +1 @@ +libpq 5 libpq5 --- postgresql-8.2-8.2.11.orig/debian/postgresql-plpython-8.2.install +++ postgresql-8.2-8.2.11/debian/postgresql-plpython-8.2.install @@ -0,0 +1 @@ +usr/lib/postgresql/8.2/lib/plpython.so --- postgresql-8.2-8.2.11.orig/debian/patches/05-check-rlimits-nofile.patch +++ postgresql-8.2-8.2.11/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 + + /* + * 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.11.orig/debian/patches/11-pg_regress-socketpath.patch +++ postgresql-8.2-8.2.11/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.11.orig/debian/patches/01-build-contrib.patch +++ postgresql-8.2-8.2.11/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.11.orig/debian/patches/07-relax-sslkey-permscheck.patch +++ postgresql-8.2-8.2.11/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.11.orig/debian/patches/09-server-includedir.patch +++ postgresql-8.2-8.2.11/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.11.orig/debian/patches/50-contrib-enablemodules.patch +++ postgresql-8.2-8.2.11/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.11.orig/debian/patches/12-m32r-tas.patch +++ postgresql-8.2-8.2.11/debian/patches/12-m32r-tas.patch @@ -0,0 +1,47 @@ +diff -Nur postgresql-8.2/build-tree/postgresql-8.2.4/configure postgresql-8.2.new/build-tree/postgresql-8.2.4/configure +--- postgresql-8.2.4/configure 2007-04-20 05:20:41.000000000 +0200 ++++ postgresql-8.2.4/configure 2007-06-20 18:22:04.000000000 +0200 +@@ -7537,7 +7537,7 @@ + + + +-for ac_header in crypt.h dld.h endian.h fp_class.h getopt.h ieeefp.h langinfo.h poll.h pwd.h sys/ipc.h sys/poll.h sys/pstat.h sys/resource.h sys/select.h sys/sem.h sys/socket.h sys/shm.h sys/time.h sys/un.h termios.h utime.h wchar.h wctype.h kernel/OS.h kernel/image.h SupportDefs.h ++for ac_header in crypt.h dld.h endian.h fp_class.h getopt.h ieeefp.h langinfo.h poll.h pwd.h sys/ipc.h sys/poll.h sys/pstat.h sys/resource.h sys/select.h sys/sem.h sys/socket.h sys/shm.h sys/tas.h sys/time.h sys/un.h termios.h utime.h wchar.h wctype.h kernel/OS.h kernel/image.h SupportDefs.h + do + as_ac_Header=`echo "ac_cv_header_$ac_header" | $as_tr_sh` + if eval "test \"\${$as_ac_Header+set}\" = set"; then +diff -Nur postgresql-8.2/build-tree/postgresql-8.2.4/src/include/pg_config.h.in postgresql-8.2.new/build-tree/postgresql-8.2.4/src/include/pg_config.h.in +--- postgresql-8.2.4/src/include/pg_config.h.in 2006-11-06 04:44:38.000000000 +0100 ++++ postgresql-8.2.4/src/include/pg_config.h.in 2007-06-20 18:22:30.000000000 +0200 +@@ -484,6 +484,9 @@ + /* Define to 1 if you have the header file. */ + #undef HAVE_SYS_STAT_H + ++/* Define to 1 if you have the header file. */ ++#undef HAVE_SYS_TAS_H ++ + /* Define to 1 if you have the header file. */ + #undef HAVE_SYS_TIME_H + +diff -Nur postgresql-8.2/build-tree/postgresql-8.2.4/src/include/storage/s_lock.h postgresql-8.2.new/build-tree/postgresql-8.2.4/src/include/storage/s_lock.h +--- postgresql-8.2.4/src/include/storage/s_lock.h 2006-06-08 00:24:45.000000000 +0200 ++++ postgresql-8.2.4/src/include/storage/s_lock.h 2007-06-20 18:23:04.000000000 +0200 +@@ -556,6 +556,18 @@ + #endif /* __mips__ && !__sgi */ + + ++#if defined(__m32r__) && defined(HAVE_SYS_TAS_H) /* Renesas' M32R */ ++#define HAS_TEST_AND_SET ++ ++#include ++ ++typedef int slock_t; ++ ++#define TAS(lock) tas(lock) ++ ++#endif /* __m32r__ */ ++ ++ + /* These live in s_lock.c, but only for gcc */ + + --- postgresql-8.2-8.2.11.orig/debian/patches/02-pager.patch +++ postgresql-8.2-8.2.11/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.11.orig/debian/patches/03-gettext-domains.patch +++ postgresql-8.2-8.2.11/debian/patches/03-gettext-domains.patch @@ -0,0 +1,340 @@ +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/backend/main/main.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/backend/main/main.c +--- postgresql-8.2.11/src/backend/main/main.c 2007-01-04 01:58:01.000000000 +0100 ++++ postgresql-8.2.11/src/backend/main/main.c 2008-11-04 21:20:06.000000000 +0100 +@@ -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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/backend/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2.11/src/backend/nls.mk +--- postgresql-8.2.11/src/backend/nls.mk 2008-10-27 20:37:36.000000000 +0100 ++++ postgresql-8.2.11/src/backend/nls.mk 2008-11-04 21:21:36.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/backend/nls.mk,v 1.20.4.1 2008/10/27 19:37:36 tgl 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 + GETTEXT_TRIGGERS:= _ errmsg errdetail errhint errcontext write_stderr yyerror +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/initdb/initdb.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/initdb/initdb.c +--- postgresql-8.2.11/src/bin/initdb/initdb.c 2008-03-01 00:31:57.000000000 +0100 ++++ postgresql-8.2.11/src/bin/initdb/initdb.c 2008-11-04 21:20:06.000000000 +0100 +@@ -2443,7 +2443,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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/initdb/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/initdb/nls.mk +--- postgresql-8.2.11/src/bin/initdb/nls.mk 2005-01-09 18:38:18.000000000 +0100 ++++ postgresql-8.2.11/src/bin/initdb/nls.mk 2008-11-04 21:20:06.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/initdb/nls.mk,v 1.18 2005/01/09 17:38:18 petere Exp $ +-CATALOG_NAME := initdb ++CATALOG_NAME := initdb-8.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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_config/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_config/nls.mk +--- postgresql-8.2.11/src/bin/pg_config/nls.mk 2006-10-21 23:03:01.000000000 +0200 ++++ postgresql-8.2.11/src/bin/pg_config/nls.mk 2008-11-04 21:20:06.000000000 +0100 +@@ -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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_config/pg_config.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_config/pg_config.c +--- postgresql-8.2.11/src/bin/pg_config/pg_config.c 2006-10-04 02:30:04.000000000 +0200 ++++ postgresql-8.2.11/src/bin/pg_config/pg_config.c 2008-11-04 21:20:08.000000000 +0100 +@@ -451,7 +451,7 @@ + int j; + int ret; + +- set_pglocale_pgservice(argv[0], "pg_config"); ++ set_pglocale_pgservice(argv[0], "pg_config-8.2"); + + progname = get_progname(argv[0]); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_controldata/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_controldata/nls.mk +--- postgresql-8.2.11/src/bin/pg_controldata/nls.mk 2005-01-14 09:57:05.000000000 +0100 ++++ postgresql-8.2.11/src/bin/pg_controldata/nls.mk 2008-11-04 21:20:08.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/pg_controldata/nls.mk,v 1.16 2005/01/14 08:57:05 petere Exp $ +-CATALOG_NAME := pg_controldata ++CATALOG_NAME := pg_controldata-8.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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_controldata/pg_controldata.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_controldata/pg_controldata.c +--- postgresql-8.2.11/src/bin/pg_controldata/pg_controldata.c 2008-09-24 10:59:44.000000000 +0200 ++++ postgresql-8.2.11/src/bin/pg_controldata/pg_controldata.c 2008-11-04 21:20:08.000000000 +0100 +@@ -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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_ctl/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_ctl/nls.mk +--- postgresql-8.2.11/src/bin/pg_ctl/nls.mk 2004-12-16 12:27:41.000000000 +0100 ++++ postgresql-8.2.11/src/bin/pg_ctl/nls.mk 2008-11-04 21:20:08.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/pg_ctl/nls.mk,v 1.15 2004/12/16 11:27:41 petere Exp $ +-CATALOG_NAME := pg_ctl ++CATALOG_NAME := pg_ctl-8.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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_ctl/pg_ctl.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_ctl/pg_ctl.c +--- postgresql-8.2.11/src/bin/pg_ctl/pg_ctl.c 2008-09-30 15:14:15.000000000 +0200 ++++ postgresql-8.2.11/src/bin/pg_ctl/pg_ctl.c 2008-11-04 21:20:08.000000000 +0100 +@@ -1596,7 +1596,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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_dump/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_dump/nls.mk +--- postgresql-8.2.11/src/bin/pg_dump/nls.mk 2005-01-25 18:32:00.000000000 +0100 ++++ postgresql-8.2.11/src/bin/pg_dump/nls.mk 2008-11-04 21:20:08.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/pg_dump/nls.mk,v 1.19 2005/01/25 17:32:00 petere Exp $ +-CATALOG_NAME := pg_dump ++CATALOG_NAME := pg_dump-8.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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_dump/pg_dumpall.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_dump/pg_dumpall.c +--- postgresql-8.2.11/src/bin/pg_dump/pg_dumpall.c 2007-05-15 22:20:24.000000000 +0200 ++++ postgresql-8.2.11/src/bin/pg_dump/pg_dumpall.c 2008-11-04 21:20:08.000000000 +0100 +@@ -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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_dump/pg_dump.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_dump/pg_dump.c +--- postgresql-8.2.11/src/bin/pg_dump/pg_dump.c 2007-04-16 20:42:17.000000000 +0200 ++++ postgresql-8.2.11/src/bin/pg_dump/pg_dump.c 2008-11-04 21:20:08.000000000 +0100 +@@ -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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_dump/pg_restore.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_dump/pg_restore.c +--- postgresql-8.2.11/src/bin/pg_dump/pg_restore.c 2006-10-15 01:07:22.000000000 +0200 ++++ postgresql-8.2.11/src/bin/pg_dump/pg_restore.c 2008-11-04 21:20:08.000000000 +0100 +@@ -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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_resetxlog/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_resetxlog/nls.mk +--- postgresql-8.2.11/src/bin/pg_resetxlog/nls.mk 2004-12-16 12:27:42.000000000 +0100 ++++ postgresql-8.2.11/src/bin/pg_resetxlog/nls.mk 2008-11-04 21:20:08.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/pg_resetxlog/nls.mk,v 1.17 2004/12/16 11:27:42 petere Exp $ +-CATALOG_NAME := pg_resetxlog ++CATALOG_NAME := pg_resetxlog-8.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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/pg_resetxlog/pg_resetxlog.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/pg_resetxlog/pg_resetxlog.c +--- postgresql-8.2.11/src/bin/pg_resetxlog/pg_resetxlog.c 2008-09-24 10:59:44.000000000 +0200 ++++ postgresql-8.2.11/src/bin/pg_resetxlog/pg_resetxlog.c 2008-11-04 21:20:08.000000000 +0100 +@@ -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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/psql/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/psql/nls.mk +--- postgresql-8.2.11/src/bin/psql/nls.mk 2004-12-13 17:30:48.000000000 +0100 ++++ postgresql-8.2.11/src/bin/psql/nls.mk 2008-11-04 21:20:08.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/bin/psql/nls.mk,v 1.21 2004/12/13 16:30:48 petere Exp $ +-CATALOG_NAME := psql ++CATALOG_NAME := psql-8.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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/psql/startup.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/psql/startup.c +--- postgresql-8.2.11/src/bin/psql/startup.c 2006-10-04 02:30:06.000000000 +0200 ++++ postgresql-8.2.11/src/bin/psql/startup.c 2008-11-04 21:20:08.000000000 +0100 +@@ -110,7 +110,7 @@ + char *password_prompt = NULL; + bool need_pass; + +- set_pglocale_pgservice(argv[0], "psql"); ++ set_pglocale_pgservice(argv[0], "psql-8.2"); + + if (argc > 1) + { +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/scripts/clusterdb.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/scripts/clusterdb.c +--- postgresql-8.2.11/src/bin/scripts/clusterdb.c 2006-03-05 16:58:52.000000000 +0100 ++++ postgresql-8.2.11/src/bin/scripts/clusterdb.c 2008-11-04 21:20:08.000000000 +0100 +@@ -56,7 +56,7 @@ + char *table = NULL; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.2"); + + handle_help_version_opts(argc, argv, "clusterdb", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/scripts/createdb.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/scripts/createdb.c +--- postgresql-8.2.11/src/bin/scripts/createdb.c 2006-06-01 02:15:36.000000000 +0200 ++++ postgresql-8.2.11/src/bin/scripts/createdb.c 2008-11-04 21:20:08.000000000 +0100 +@@ -60,7 +60,7 @@ + PGresult *result; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.2"); + + handle_help_version_opts(argc, argv, "createdb", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/scripts/createlang.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/scripts/createlang.c +--- postgresql-8.2.11/src/bin/scripts/createlang.c 2007-08-10 02:39:44.000000000 +0200 ++++ postgresql-8.2.11/src/bin/scripts/createlang.c 2008-11-04 21:20:08.000000000 +0100 +@@ -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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/scripts/createuser.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/scripts/createuser.c +--- postgresql-8.2.11/src/bin/scripts/createuser.c 2006-10-04 02:30:06.000000000 +0200 ++++ postgresql-8.2.11/src/bin/scripts/createuser.c 2008-11-04 21:20:08.000000000 +0100 +@@ -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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/scripts/dropdb.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/scripts/dropdb.c +--- postgresql-8.2.11/src/bin/scripts/dropdb.c 2006-09-22 20:50:41.000000000 +0200 ++++ postgresql-8.2.11/src/bin/scripts/dropdb.c 2008-11-04 21:20:08.000000000 +0100 +@@ -51,7 +51,7 @@ + PGresult *result; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.2"); + + handle_help_version_opts(argc, argv, "dropdb", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/scripts/droplang.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/scripts/droplang.c +--- postgresql-8.2.11/src/bin/scripts/droplang.c 2007-08-10 02:39:44.000000000 +0200 ++++ postgresql-8.2.11/src/bin/scripts/droplang.c 2008-11-04 21:20:08.000000000 +0100 +@@ -63,7 +63,7 @@ + PGresult *result; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.2"); + + handle_help_version_opts(argc, argv, "droplang", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/scripts/dropuser.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/scripts/dropuser.c +--- postgresql-8.2.11/src/bin/scripts/dropuser.c 2006-09-22 20:50:41.000000000 +0200 ++++ postgresql-8.2.11/src/bin/scripts/dropuser.c 2008-11-04 21:20:08.000000000 +0100 +@@ -51,7 +51,7 @@ + PGresult *result; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.2"); + + handle_help_version_opts(argc, argv, "dropuser", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/scripts/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/scripts/nls.mk +--- postgresql-8.2.11/src/bin/scripts/nls.mk 2006-09-22 20:50:41.000000000 +0200 ++++ postgresql-8.2.11/src/bin/scripts/nls.mk 2008-11-04 21:20:08.000000000 +0100 +@@ -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 -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/scripts/reindexdb.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/scripts/reindexdb.c +--- postgresql-8.2.11/src/bin/scripts/reindexdb.c 2006-09-02 19:10:17.000000000 +0200 ++++ postgresql-8.2.11/src/bin/scripts/reindexdb.c 2008-11-04 21:20:08.000000000 +0100 +@@ -65,7 +65,7 @@ + const char *index = NULL; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.2"); + + handle_help_version_opts(argc, argv, "reindexdb", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/bin/scripts/vacuumdb.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/bin/scripts/vacuumdb.c +--- postgresql-8.2.11/src/bin/scripts/vacuumdb.c 2006-03-05 16:58:52.000000000 +0100 ++++ postgresql-8.2.11/src/bin/scripts/vacuumdb.c 2008-11-04 21:20:08.000000000 +0100 +@@ -64,7 +64,7 @@ + bool verbose = false; + + progname = get_progname(argv[0]); +- set_pglocale_pgservice(argv[0], "pgscripts"); ++ set_pglocale_pgservice(argv[0], "pgscripts-8.2"); + + handle_help_version_opts(argc, argv, "vacuumdb", help); + +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/interfaces/libpq/fe-misc.c postgresql-8.2.new/build-tree/postgresql-8.2.11/src/interfaces/libpq/fe-misc.c +--- postgresql-8.2.11/src/interfaces/libpq/fe-misc.c 2008-08-20 13:53:49.000000000 +0200 ++++ postgresql-8.2.11/src/interfaces/libpq/fe-misc.c 2008-11-04 21:20:08.000000000 +0100 +@@ -1148,7 +1148,7 @@ + ldir = getenv("PGLOCALEDIR"); + if (!ldir) + ldir = LOCALEDIR; +- bindtextdomain("libpq", ldir); ++ bindtextdomain("libpq5", ldir); + #ifdef WIN32 + SetLastError(save_errno); + #else +diff -Nur -x '*.orig' -x '*~' postgresql-8.2/build-tree/postgresql-8.2.11/src/interfaces/libpq/nls.mk postgresql-8.2.new/build-tree/postgresql-8.2.11/src/interfaces/libpq/nls.mk +--- postgresql-8.2.11/src/interfaces/libpq/nls.mk 2005-01-14 09:57:06.000000000 +0100 ++++ postgresql-8.2.11/src/interfaces/libpq/nls.mk 2008-11-04 21:20:08.000000000 +0100 +@@ -1,5 +1,5 @@ + # $PostgreSQL: pgsql/src/interfaces/libpq/nls.mk,v 1.20 2005/01/14 08:57:06 petere Exp $ +-CATALOG_NAME := libpq ++CATALOG_NAME := 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.11.orig/debian/patches/10-tutorial-README.patch +++ postgresql-8.2-8.2.11/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.11.orig/debian/patches/04-timezone-symlinks.patch +++ postgresql-8.2-8.2.11/debian/patches/04-timezone-symlinks.patch @@ -0,0 +1,12 @@ +diff -Nur postgresql-8.2/build-tree/postgresql-8.2.4/src/timezone/Makefile postgresql-8.2.new/build-tree/postgresql-8.2.4/src/timezone/Makefile +--- postgresql-8.2.4/src/timezone/Makefile 2007-03-14 18:38:15.000000000 +0100 ++++ postgresql-8.2.4/src/timezone/Makefile 2007-04-20 09:25:20.000000000 +0200 +@@ -38,7 +38,7 @@ + $(CC) $(CFLAGS) $(ZICOBJS) $(LDFLAGS) $(LIBS) -o $@$(X) + + install: all installdirs +- ./zic -d '$(DESTDIR)$(datadir)/timezone' -p '$(POSIXRULES)' $(TZDATAFILES) ++ ln -s /usr/share/zoneinfo '$(DESTDIR)$(datadir)/timezone' + $(MAKE) -C tznames $@ + + installdirs: --- postgresql-8.2-8.2.11.orig/debian/patches/08-pkglibdir.patch +++ postgresql-8.2-8.2.11/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.11.orig/debian/patches/06-libpq-defaultsocketdir.patch +++ postgresql-8.2-8.2.11/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.11.orig/postgresql-8.2.11.tar.bz2.cdbs-config_list +++ postgresql-8.2-8.2.11/postgresql-8.2.11.tar.bz2.cdbs-config_list @@ -0,0 +1,5 @@ +postgresql-8.2.11/src/tools/msvc/config.pl +postgresql-8.2.11/doc/src/sgml/config.sgml +postgresql-8.2.11/contrib/tsearch2/gendict/config.sh +postgresql-8.2.11/config/config.guess +postgresql-8.2.11/config/config.sub