postgresql (7.4.7-6sarge6) oldstable-security; urgency=low

  * SECURITY UPDATE: User privilege escalation.
  * Add debian/patches/63dblink_restrictions.patch:
    - Require non-superusers who use "/contrib/dblink" to use only password
      authentication, to prevent abusing the postmaster as source for remote
      attacks with trust or ident authentication. 
      [CVE-2007-3278, CVE-2007-6601]
    - Patch backported from 7.4.19 CVS:
      http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/dblink.c.diff?r1=1.25.4.4;r2=1.25.4.6
      http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/dblink.sql.in.diff?r1=1.8;r2=1.8.4.1

 -- Martin Pitt <mpitt@debian.org>  Sun, 13 Jan 2008 14:56:44 +0100

postgresql (7.4.7-6sarge5) oldstable-security; urgency=high

  * SECURITY UPDATE: User privilege escalation.
  * Add debian/patches/62secure_search_path.path:
    - Support explicit placement of the temporary-table schema within
      search_path.  This is needed to allow a security-definer function to set a
      truly secure value of search_path.  Without it, a malicious user can use
      temporary objects to execute code with the privileges of the
      security-definer function.  Even pushing the temp schema to the back of
      the search path is not quite good enough, because a function or operator
      at the back of the path might still capture control from one nearer the
      front due to having a more exact datatype match.  Hence, disable searching
      the temp schema altogether for functions and operators. [CVE-2007-2138]
    - Patch backported from 7.4.17 CVS:
      http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/namespace.c.diff?r1=1.58;r2=1.58.2.1
    - Add test cases for the placement of the temp schema in the search path.
      Backported from 7.4.17 CVS:
      http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/temp.out.diff?r1=1.9;r2=1.9.2.1
      http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/temp.sql.diff?r1=1.5;r2=1.5.4.1
  * Add debian/docs.patch: manpage and HTML documentation patches which
    explain the changes above. Upstream keeps them in the SGML source, but
    since we do not build this and instead use the pre-built files which come
    in man.tar.gz and postgresql.tar.gz, we cannot use a regular
    debian/patches/ patch for this.
  * debian/rules: Apply debian/docs.patch in the install target to update the
    files in the binary install directories.

 -- Martin Pitt <mpitt@debian.org>  Fri, 20 Apr 2007 11:30:38 +0200

postgresql (7.4.7-6sarge4) stable-security; urgency=low

  * SECURITY UPDATE: Read out arbitrary memory locations from the server,
    local DoS.
  * Add debian/patches/60sql_fun_typecheck.patch:
    - Repair insufficiently careful type checking for SQL-language functions.
      Not only can one trivially crash the backend, but with appropriate
      misuse of pass-by-reference datatypes it is possible to read out
      arbitrary locations in the server process's memory, which could allow
      retrieving database content the user should not be able to see.
    - Discovered by Jeff Trout.
    - Patch backported from 7.4.16 from CVS:
      http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/functions.c.diff?r1=1.75.2.1;r2=1.75.2.2
      http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c.diff?r1=1.154.2.4;r2=1.154.2.5
    - CVE-2007-0555
  * Add debian/patches/61max_utf8_wchar_len.patch:
    - Update various string functions to support the maximum UTF-8 sequence
      length for 4-byte character set to prevent buffer overflows.
    - Patch backported from 7.4.16 from CVS:
      http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mb/wchar.c.diff?r1=1.34.2.2;r2=1.34.2.3

 -- Martin Pitt <mpitt@debian.org>  Sun,  4 Feb 2007 21:46:34 +0100

postgresql (7.4.7-6sarge3) stable-proposed-updates; urgency=low

  * debian/patches/57quote-escaping.patch:
    - contrib/dbmirror/DBMirror.pl: Fix parsing of quotes escaped as '' in the
      PendingData table to make the script work with the updated quoting
      method introduced in 7.4.7-6sarge2 (using \' escaping is insecure).
    - Closes: #372115

 -- Martin Pitt <mpitt@debian.org>  Thu,  6 Jul 2006 09:48:40 +0200

postgresql (7.4.7-6sarge2) stable-security; urgency=high

  * SECURITY UPDATE: Remote SQL injection. Closes: #368645
  * Add debian/patches/55reject-invalid-encoding.patch:
    - Change the backend to reject strings containing invalidly-encoded
      multibyte characters in all cases.  Formerly we mostly just threw warnings
      for invalid input, and failed to detect it at all if no encoding
      conversion was required.  The tighter check is needed to defend
      against SQL-injection attacks.
    - Also, fix a few longstanding errors in little-used encoding conversion
      routines: win1251_to_iso, win866_to_iso, euc_tw_to_big5, euc_tw_to_mic,
      mic_to_euc_tw were all broken to varying extents.
    - Patch backported from 8.0.8.
    - CVE-2006-2313
  * Add debian/patches/56backslash_quote-guc.patch:
    - Add a new GUC parameter backslash_quote, which determines whether the
      SQL parser will allow "\'" to be used to represent a literal quote mark.
      The "\'" representation has been deprecated for some time in favor of the
      SQL-standard representation "''" (two single quote marks), but it has been
      used often enough that just disallowing it immediately won't do.  Hence
      backslash_quote allows the settings "on", "off", and "safe_encoding", the
      last meaning to allow "\'" only if client_encoding is a valid server
      encoding.  That is now the default, and the reason is that in encodings
      such as SJIS that allow 0x5c (ASCII backslash) to be the last byte of a
      multibyte character, accepting "\'" allows SQL-injection attacks.
    - The "on" setting is available for backward compatibility, but it must
      not be used with clients that are exposed to untrusted input.
    - Patch backported from 8.0.8.
    - CVE-2006-2314
  * Add debian/patches/57quote-escaping.patch:
    - Change escaping from \' to '' throughout the code (in client programs
      and contrib modules).
    - Patch backported from 8.0.8.
  * Add debian/patches/58libpq-string-escaping.patch:
    - Modify libpq's string-escaping routines to be aware of encoding
      considerations and standard_conforming_strings.  The encoding changes are
      needed for proper escaping in multibyte encodings, as per the
      SQL-injection vulnerabilities noted in CVE-2006-2313 and CVE-2006-2314.
    - Since the existing API of PQescapeString and PQescapeBytea provides no
      way to inform them which settings are in use, these functions are now
      deprecated in favor of new functions PQescapeStringConn and
      PQescapeByteaConn.  The new functions take the PGconn to which the string
      will be sent as an additional parameter, and look inside the connection
      structure to determine what to do.  So as to provide some functionality
      for clients using the old functions, libpq stores the latest encoding and
      standard_conforming_strings values received from the backend in
      static variables, and the old functions consult these variables.
      This will work reliably in clients using only one Postgres
      connection at a time, or even multiple connections if they all use
      the same encoding and string syntax settings; which should cover
      many practical scenarios.
    - Clients that use homebrew escaping methods, such as PHP's addslashes()
      function or even hardwired regexp substitution, will require extra effort
      to fix :-(.  It is strongly recommended that such code be replaced by use
      of PQescapeStringConn/PQescapeByteaConn if at all feasible.
    - Patch backported from 8.0.8.
  * Add debian/patches/59indexscan-duplicate-tuples.patch:
    - Fix nasty bug in nodeIndexscan.c's detection of duplicate tuples during
      a multiple (OR'ed) indexscan.  It was checking for duplicate
      tuple->t_data->t_ctid, when what it should be checking is tuple->t_self.
    - Patch backported from 8.0.8.
  * Add debian/patches/40testsuite-ignore-horology.patch: Ignore failure of
    'horology' test suite, since it cannot succeed with our configure
    arguments (this has been fixed in current 8.0/8.1 versions, but
    backporting this fix is out of question).

 -- Martin Pitt <mpitt@debian.org>  Sun, 28 May 2006 10:04:30 +0000

postgresql (7.4.7-6sarge1) testing-proposed-updates; urgency=low

  * debian/postinst.in: db_security_update_CAN_2005_1409_1410(): Do not fail
    completely if the security update cannot be applied to a single data base,
    but rather print an error message for this database. Closes: #307888
  * debian/po/pt_BR.po: Fixed some typos, thanks to Andre Luis Lopes.
    Closes: #308328
  * debian/postgresql-startup.in: Fixed handling of stale and invalid PID
    files. Closes: #304861
  * debian/README.Debian: Added section "First steps for the impatient".
  * Added debian/patches/53transaction-race:
    - Repair race condition that allowed a transaction to be seen as committed
      for some purposes (eg SELECT FOR UPDATE) slightly sooner than for other
      purposes. This is an extremely serious bug since it could lead to
      apparent data inconsistencies being briefly visible to applications.
    - Backported from stable 7.4.8 release.
  * Added debian/patches/54vacuum-race:
    - Repair race condition between relation extension and VACUUM
      This could theoretically have caused loss of a page's worth of
      freshly-inserted data, although the scenario seems of very low
      probability.
    - Backported from stable 7.4.8 release.

 -- Martin Pitt <mpitt@debian.org>  Wed, 18 May 2005 10:20:16 +0200

postgresql (7.4.7-6) unstable; urgency=high

  * Security update: Fix potential buffer overflows and crashes.
  * Added debian/patches/51CAN-2005-1409:
    - Change the signature of conversion functions to declare the
      output area as INTERNAL, not CSTRING. This prevents users from calling
      the functions by hand.
    - CAN-2005-1409
  * Added debian/patches/52CAN-2005-1410:
   - Change the signature of tsearch2 modules to take INTERNAL instead of
     TEXT. This prevents users from calling the functions by hand.
   - CAN-2005-1410
  * debian/postinst.in:
   - Added function db_security_update_CAN_2005_1409_1410() which applies
     above fixes to all already existing databases.
   - Call that function if upgrading from earlier releases.

 -- Martin Pitt <mpitt@debian.org>  Tue, 12 Apr 2005 21:57:58 +0200

postgresql (7.4.7-5) unstable; urgency=low

  * postgresql/cron.d: Fixed do.maintenance call, which had the pidof check
    inverted (regression from 7.4.7-4).

 -- Martin Pitt <mpitt@debian.org>  Tue, 12 Apr 2005 07:53:43 +0200

postgresql (7.4.7-4) unstable; urgency=low

  * Replaced most ps | grep constructs by pidof calls and safely use the two
    remaining use cases. Closes: #298122
  * debian/control: Depend on dpkg >= 1.10.3 to assert sane start-stop-daemon
    behaviour on startup if the server is already running.
  * Ship reindexdb in postgresql-contrib. Closes: #303295
  * debian/postinst.in: Fix quoting of RESTARTOUT to prevent expansion of
    shell characters like '*'. Closes: #297192
  * debian/postinst.in: Parse init script output also if invoke-rc.d is not
    available.

 -- Martin Pitt <mpitt@debian.org>  Sun, 10 Apr 2005 22:40:06 +0200

postgresql (7.4.7-3) unstable; urgency=low

  * debian/postgresql.init: Create socket directory /var/run/postgresql if it
    does not exist. This happens if /var/run is mounted on a tmpfs.
  * Added CAN number to 7.4.6-1 changelog entry.
  * Removed bogus postgresql-dev.prerm. Closes: #296350
  * Typo corrections of German debconf translations, thanks to Helge
    Kreutzmann. Closes: #294924
  * postgresql-client
    - postinst: do not use mail, just print errors to stderr
    - postinst: code cleanup
    - dropped dependency to mailx. Closes: #293597

 -- Martin Pitt <mpitt@debian.org>  Wed, 23 Feb 2005 11:47:26 +0100

postgresql (7.4.7-2) unstable; urgency=high

  * Urgency high since this fixes a security vulnerability (and nothing else).
  * Added patch 50CAN-2005-0247: 
    - Fix multiple buffer overflows in the PL/PGSQL parser's gram.y file.
    - CAN-2005-0247
    - Closes: #294406
  * Added CAN numbers to previous changelog version.

 -- Martin Pitt <mpitt@debian.org>  Thu, 10 Feb 2005 13:04:02 +0100

postgresql (7.4.7-1) unstable; urgency=high

  * New upstream bug fix release, fixes several vulnerabilities:
    - Low-privileged users could use LOAD to load any shared library into the
      PostgreSQL server; its initialisation function was then executed with the
      permissions of the server. Closes: #293125 [CAN-2005-0227]
    - By creating a CREATE AGGREGATE wrapper around a function, this function
      could be executed even without the EXECUTE permission. [CAN-2005-0244]
    - Prevent overrunning a heap-allocated buffer in the pl/pgsql parser if
      more than 1024 parameters to a refcursor declaration are specified.
      [CAN-2005-0245]
    - Fixes denial of service by crafted arrays in contrib/inntag. 
      [CAN-2005-0246]
    See http://archives.postgresql.org/pgsql-bugs/2005-01/msg00269.php
  * Removed the following patches (now in upstream source):
    - debian/patches/13frenchpo, 
    - debian/patches/14emptyarrays
  * Applied some portability enhancements to work on GNU/Hurd and GNU/k*BSD,
    thanks to Robert Millan:
    - debian/startup-checks-root.sh: Use "sysctl" instead of direct /proc
      access to read kernel variables.
    - debian/rules: configure with --with-template=linux
    Closes: #262081

 -- Martin Pitt <mpitt@debian.org>  Tue,  1 Feb 2005 12:23:04 +0100

postgresql (7.4.6-7) unstable; urgency=medium

  * Urgency medium since this fixes (only) RC and important bugs.
  * Dropped obsolete patch 04doc_src_sgml_Makefile
  * Dropped now obsolete build dependency "mmv" again
  * postinst.in: correct argument passing to do_upgrade() function.
    Closes: #290544
  * postgresql-startup.in: Remove broken check for obsolete "peer"
    authentication method; this was already obsolete and checked in Woody, so
    we can assume it is correct now. Closes: #291700
  * Fixed handling of temporary files (partly security relevant), thanks a lot
    to Javier Fernández-Sanguino Peña for spotting these. Closes: #291962
    - debian/postgresql-dump.in: remove creation/deletion of TMPFILE, it is
      not used any more
    - debian/enable_lang.in, debian/preinst.in: eliminate usage of temporary
      files, replaced by variables
    - debian/postinst.in:
      + use mktemp switch -t
      + tighten permissions of $MAILFILE, $TMPFILE, and $SCRIPTFILE
      + replaced some TMPFILE usage with variables
    - Added patch 15secure_tempfiles which fixes relevant issues in upstream
      build files:
      + src/backend/catalog/genbki.sh: use mktemp
      + src/test/bench/perquery: eliminate tempfile, use pipe instead
    - All other files mentioned in the bug report are not used for building
      postgresql. pg_upgrade is not shipped, so does not need to be fixed as
      well.
   * Create the default log directory world-readable again and also with
     setgid postgres (2775) to comply with Debian Policy. Since the directory
     is not touched if it already exists, administrator can easily change the
     permissions afterwards (some people want to have it non-world-readable).
     Closes: #286737
   * Moved newer libpq.mo translations out of postgresql into libpq3, where
     they belong. libpq3 now Conflicts: to postgresql << 7.4.6-7.
   * debian/control: set Martin as primary maintainer and Oliver as
     Comaintainer

 -- Martin Pitt <mpitt@debian.org>  Tue, 25 Jan 2005 12:43:35 +0100

postgresql (7.4.6-6) unstable; urgency=low

  * debian/rules: fix DEB_BUILD_OPTIONS usage:
    - removed obsolete "debug"
    - support "noopt"
    - build with -O2 if not using noopt; Closes: #284894
  * Added patch 13frenchpo to fix wrong french translations; thanks to Julien
    Cristau. Closes: #283856
  * postgresql.init: if postmaster fails to shutdown in 'fast' mode, try
    'immediate'; if that fails as well, eventually kill -9 the process.
    Closes: #284147
  * Added patch 14emptyarrays: fix type handling of empty arrays (backported
    from 8.0 tree); thanks to Florian Pflug for spotting this.
    Closes: #286908
  * postgresql.init: make log directory not world-readable any more.
    Closes: #286737
  * Added Dutch debconf translations, thanks to Alper Cugun. Closes: #286924
  * Added build-dependency "mmv" since patch 04doc_src_sgml_Makefile uses this
    command.
  * postgresql.init: added PREFIX and PG_STARTUP variables for easier and more
    flexible configuration. Closes: #287079
  * postgresql-startup.in: respect ':' field delimiter when parsing the output
    of pg_controldata. Closes: #287430
  * cleaned up the conffile touching mess; up to now, administrator overrides
    of conffile permissions were not respected on upgrades and the permissions
    of additional files (like SSL certificates) got modified, which caused
    failed upgrades. Closes: #285177
    - postgresql-dump.in: do not use initdb's --debian-conffile option any
      more (since it writes into /etc/postgresql/), instead do the symlinking
      in postinst.in
    - postinst.in: cleaned up permission setup and conffile symlinking,
      encapsulated it into function setup_conffiles(), only call it after
      initdb calls (install from scratch or after major upgrade)

 -- Martin Pitt <mpitt@debian.org>  Wed, 29 Dec 2004 14:38:37 +0100

postgresql (7.4.6-5) unstable; urgency=low

  * Fixed silly typo in postgresql-startup.in which caused the postmaster not
    to start after it crashed. Closes: #282940
  * postrm: check whether ucf is installed before calling it. Closes: #283079
  * Moved createlang and droplang programs to postgresql-client.
    Closes: #282977
  * linked clusterdb, vacuumdb, droplang, pg_dumpall to /usr/bin to make them
    accessible more easily. Closes: #282973
  * postgresql-client now conflicts to postgresql (<< 7.4.6-5) to avoid file
    clashes; postgresql now conflicts to postgresql-client (<< 7.4.6-5) to
    avoid missing userspace programs
  * postgresql.init: do not exit with value 1 if postmaster is already running
    in the "start" command; likewise for autovac-start. Closes: #282984
  * postgresql.init: create log directory and file if it does not exist;
    removed obsolete code from postinst.  Closes: #283458

 -- Martin Pitt <mpitt@debian.org>  Mon, 29 Nov 2004 18:49:09 +0100

postgresql (7.4.6-4) unstable; urgency=medium

  * Urgency medium since this fixes an RC bug also present in Sarge.
  * Moved kernel variable checks from postgresql-startup to new script
    /usr/share/postgresql/startup-checks-root.sh and execute the latter in the
    init script. Some security enhanced kernels restrict the permissions of
    /proc/sys to root-only readability. Closes: #282431
  * postgresql-contrib.{postinst,postrm}: use the new autovac-{start,stop}
    init functions instead of restarting the complete PostgreSQL server.
    Closes: #282090
  * postgresql-startup.in: specify full path to pg_controldata to be more
    robust
  * postinst.in: fixed get_encoding function to just match against one locale
    in the list. Closes: #282502
  * postinst.in: changed fallback encoding to SQL_ASCII, which is safer than
    UTF8.

 -- Martin Pitt <mpitt@debian.org>  Tue, 23 Nov 2004 15:29:28 +0100

postgresql (7.4.6-3) unstable; urgency=low

  * postinst: do not assume that /var/lib/postgres exists in chown -R command;
    it was redundant anyway since it already processed ${PGHOME}.
    Closes: #278952
  * patch 26dbf2pg-errorcheck: improved error checking for dbf2pg. Thanks to
    Brad Thompson <brad@vecna.com>. Closes: #147823
  * patch 27dbf2pg-textfield: add dbf2pg support for dbase field 'M',
    corresponding to PostgreSQL's TEXT field. Thanks to Brad Thompson
    <brad@vecna.com>. Closes: #149789.
  * Fixed typo in postgresql-contrib package description. Closes: #271277
  * Updated patch 24autovacuum: check if env variable PGDATA is set before
    actually using it to avoid a SEGFAULT if it is not defined. Thanks to
    Ulrich Dangel for spotting this. Closes: #273891
  * split patch 25contrib into separate parts: -dbmirror, -enablemysql,
    -enablexml
  * patch 25contrib-enableoracle: install the Oracle conversion scripts.
    Closes: #265307
  * Updated debian/copyright.
  * postgresql-dev: dropped dependency on libkrb5-dev to Recommends, since the
    dependency caused build conflicts in cyrus-sasl2 (#279158)
  * enable_lang.in: check for accessibility only for user 'postgres', not for
    'all'. Closes: #277725
  * moved some code from postgresql.init to postgresql-startup to simplify
    writing of Mandatory Access Control rules. Closes: #149057
  * do not set the kernel "file-max" parameter any more, but write a verbose
    error message if it is too small; packages should not mess up central
    kernel variables, this should be done by the admin in /etc/sysctl.conf.
  * postinst.in: do chmod'ing of conffiles as root (before calling initdb) to
    avoid permission errors
  * Dropped debconf question for default database encoding; this is now
    automatically determined from the locale. Locale debconf question now also
    explains the impact on encoding. Closes: #254058, #257117
  * postgresql.config.in: Fixed a debconf logic flaw: previously, initdb used
    the locale of the package installation process, not the one chosen in
    debconf. Closes: #263503
  * Renamed debian/po/cz.po to cs.po (CZ is the language, cs is the country).
  * Modernized package descriptions; Thanks to Peter Eisentraut for providing
    them. Closes: #280423

 -- Martin Pitt <mpitt@debian.org>  Wed, 10 Nov 2004 12:38:59 +0100

postgresql (7.4.6-2) unstable; urgency=medium

  * postgresql.init: now call pg_ctl as user postgresql, it does not work any
    more as root. Use start-stop-daemon for that to stay compatible with
    SELinux. Closes: #278573.
  * Still urgency medium, since the previous upload fixes security bugs.

 -- Martin Pitt <mpitt@debian.org>  Fri, 29 Oct 2004 20:10:45 +0200

postgresql (7.4.6-1) unstable; urgency=medium

  * New upstream security and bug fix release
    - fix several bugs causing potential data loss 
    - fixes insecure temporary files in make_oidjoins_check [CAN-2004-0977]
      Closes: #278336, #278262
    - removed patch 15outer_join (applied upstream)
  * debian/rules: do not install the make_oidjoins_check script any more, it
    has still unsafe temporary file handling and nobody needs it anyway
  * postgresql-dev now depends on libkrb5-dev
  * postgresql-contrib.logrotate: added 'missingok' flag. Closes: #278318
  * added Czech debconf translations; thanks to Miroslav Kure. Closes: #273837

 -- Martin Pitt <mpitt@debian.org>  Wed, 27 Oct 2004 12:08:01 +0200

postgresql (7.4.5-4) unstable; urgency=low
 
   * Applied upstream patch to fix long-standing bug in large outer joins.
     (Patch 15outer_join)
   * Altered postgresql init file to enable pg_autovacuum to be stopped and
     started separately.  Closes: #273807
 
 -- Oliver Elphick <olly@linda>  Tue,  5 Oct 2004 09:12:32 +0100

postgresql (7.4.5-3) unstable; urgency=medium

  * Still urgency medium since this is an RC bug and the previous medium
    upload has not yet gone into testing
  * postinst.in: always assign a default value to TMPFILE if it is not set.
    Closes: #269465

 -- Martin Pitt <mpitt@debian.org>  Thu,  2 Sep 2004 08:04:41 +0200

postgresql (7.4.5-2) unstable; urgency=medium

  * Urgency medium since the previous medium upload did not reach testing yet
    and this version does not make intrusive changes.
  * Sanitized log file permissions. Closes: #266878 [Martin Pitt]
  * Made /var/run/postgres writeable for group 'postgres'. This is necessary
    for postgresql extensions like pgpool that should run as a separate user,
    but need access to the directory. Closes: #269256 [Martin Pitt]
  * patch 30libpq: removed useless -L directive output from libpq3-config, it
    contained a relative path that is only interesting in the build tree.
    Closes: #260350 [Martin Pitt]
  * Added tsearch2 to description of postgresql-contrib, installed
    README.tsearch2. Closes: #269373 [Martin Pitt]

 -- Martin Pitt <mpitt@debian.org>  Wed,  1 Sep 2004 11:25:27 +0200

postgresql (7.4.5-1) unstable; urgency=medium

  * Urgency medium since this fixes several critical issues which have to go
    into sarge soon.
  * New upstream version which corrects several critical upstream bugs.
    Closes: #268610
    Plus these bugs which are recorded in BTS:
    - fix constraint trigger when renaming a column which references another
      table. Closes: #259995 
    - fix changing of session authorization in pg_dump. Closes: #260315
    [Martin Pitt]
  * removed patch 13ecpg-parser (now handled upstream)
  * postinst.in: execute temporary script not directly, but through /bin/sh to
    make it work also on noexec /tmp/ directories. Closes: #265576 [Martin Pitt]
  * chown the TMPFILE to postgres to allow postgresql-dump to write into it
    (it is executed as user postgres). This fixes the other issue in #265576.
    [Martin Pitt]
  * added Brazilian Portugese debconf translations, thanks to Andre Luis
    Lopes. Closes: #262576 [Martin Pitt]
  * postgresql.init: fixed the check of shmmax to reflect reality and print
    out a better message if shmmax is too low for PostgreSQL. Closes: #264223
    [Martin Pitt]
  * Log files and directory is not installed as world-readable any more since
    they might contain sensitive data. Closes: #266878 [Martin Pitt]
  * Dropped priority of debconf questions postgresql/purge_data_too and
    postgresql/upgrade/policy to 'medium' since they have sensible defaults.
    [Martin Pitt]
  * Added symlink /usr/bin/createlang to pg_wrapper. Closes: #267318 
    [Martin Pitt]
  * postgresql-contrib now suggests libpgtcl since it is required for rserv
    (also updated description). Closes: #269026 [Martin Pitt]

 -- Oliver Elphick <Oliver.Elphick@lfix.co.uk>  Mon, 30 Aug 2004 15:45:34 +0200

postgresql (7.4.3-3) unstable; urgency=medium

  * Fixed permissions of several temporary scripts which were world-writeable
    up to now. Urgency medium since this is a security update. Closes: #259251 
    [Martin Pitt]
  * postgresql-doc: removed useless src/tutorial directory. Closes: #257716
    [Martin Pitt]
  * postinst.in: before executing initdb script as user postgres,
    /etc/postgresql/ is chown'ed to postgres to execute the script cleanly.
    This fixes the three chmod error messages during installation. 
    [Martin Pitt]
  * postgresql.config.in: path to locales was wrong (they now live in
    /usr/share/locales) and testing the directory existence is not really
    necessary anyway; -> removed directory test to enable locale debconf
    question again [Martin Pitt]
  * postgresql.init: now checks whether available shared kernel memory
    is sufficient and prints a warning (and how to enlarge it) if not.
    Closes: #67481, #230087 [Martin Pitt]
  * postinst.in: complain and abort installation if POSTGRES_HOME is /.
    Closes: #256560 [Martin Pitt]

 -- Oliver Elphick <Oliver.Elphick@lfix.co.uk>  Thu,  8 Jul 2004 14:47:47 +0200

postgresql (7.4.3-2) unstable; urgency=low

  * postgresql.config.in: fixed guessing of default day/month order; this is
    not done any more if question was already answered. Closes: #254686
    [Martin Pitt]
  * Added patch 13ecpg-parser to fix parsing of indicators in ecpg (this is
    already committed in upstream CVS, so it will be removed in the next
    upstream version). Closes: #254873 [Martin Pitt]
  * Removed mysql comparison from postgresql description since it is out of
    date. Closes: #255813 [Martin Pitt]
  * Changed upstream Makefile to install scripts and data for contrib
    module dbmirror [Oliver Elphick]
  * pg_wrapper (when linked to psql) now reports the program name when
    doing an error exit when no database is specified.  Partial resolution
    of #201712 [Oliver Elphick]

 -- Oliver Elphick <Oliver.Elphick@lfix.co.uk>  Sun,  4 Jul 2004 14:45:48 +0100

postgresql (7.4.3-1) unstable; urgency=low

  * New upstream bugfix release
  * Removed patch 12hba-tokenerror, adopted upstream
  * postgresql.config.in: moved the setting of PGLANG further down to actually
    make it work (up to now PGDATA was not set yet, so it had no effect)
    [Martin Pitt]
  * Corrected ucf version dependency to >= 0.28 [Martin Pitt]
  * postinst.in: sanitized handling of failed postmaster start; a broken
    invoke-rc.d (there were several reports that it is linked to /bin/true) is
    now recognized, the postinst does not fail any more in this case 
    [Martin Pitt]
  * Corrected several typos and inconsistencies in debconf templates; thanks
    to Helge Kreutzmann for spotting them! Closes: #252618 [Martin Pitt]
  * Merged some paragraph from Helge's German debconf template translation
    into the current one. Closes: #252613 [Martin Pitt]
  * Added Turkish debconf translation, thanks to Gurkan Aslan and Recai Oktas.
    Closes: #252803 [Martin Pitt]
  * Standard datestyle is now ISO for standards conformance; removed style
    guessing and related debconf template. Closes: #253004 [Martin Pitt]
  * Fixed initdb manpage to describe --debian-conffile point to this option in
    README.Debian and README.Debian.migration. Closes: #253337 [Martin Pitt]
  * Put a symlink to /usr/lib/postgresql/bin/ecpg into /usr/bin. 
    Closes: #253507 [Martin Pitt]
  * postgresql.init: Clarified request when to send a bug report to avoid
    getting reports about full disks and such. Closes: #253795 [Martin Pitt]
  * Guessing of default day/month ordering now uses LC_TIME from user postgres
    instead of digging through time zone (this does not work every time)
  * Added patch 12asmconstraints to fix inconsistent asm constraints on
    m68k and ia64. Closes: #252957 [Martin Pitt]

 -- Oliver Elphick <olly@lfix.co.uk>  Tue, 15 Jun 2004 09:40:35 +0100

postgresql (7.4.2-6) unstable; urgency=low

  * Adjusted permissions of /etc/postgresql/*. The previous version did not
    cover some upgrade paths, sorry for that! Closes: #251325
  * prerm.in: removed superfluous postgresql stop, debhelper does that already

 -- Martin Pitt <mpitt@debian.org>  Sat, 29 May 2004 12:12:57 +0200

postgresql (7.4.2-5) unstable; urgency=low

  * In the patch to pg_autovacuum.c, move the declaration of nullfd to
    the top of its routine so that it will compile with gcc-2.95
  * Now uses ucf to handle postgresql.conf and postmaster.conf instead of
    changing it in-place. Thanks to Jeroen van Wolffelaar for many hints
    regarding this. Closes: #246717 [Martin Pitt]
  * Removed build-dependency sharutils since postgresql.xpm is not uudecoded
    any more [Martin Pitt]
  * Moved postgresql.xpm from X11R6 directory to /usr/share/pixmaps since the
    former location is obsolete [Martin Pitt]
  * postgresql: now provides real alternative 'pidentd' to virtual package
    ident-server [Martin Pitt]
  * Corrected section of postgresql-dump.8 [Martin Pitt]
  * pg_wrapper.c: now recognizes psql option -n. Closes: #247918 [Martin Pitt]
  * postgresql.config: quoted arguments of dirname to work also with spaces in
    arguments. Closes: #245402, #250651 [Martin Pitt]
  * Removed unused files from debian/ [Martin Pitt]
  * Added patch 08check_rlimit_nofile to prevent opening more files than the
    current system limit allows; up to now files were dup()ed until an error
    to check how many files can be opened simultaneously. Thanks to Jacek
    Drobiecki for the patch! Closes: #248967 [Martin Pitt]
  * Enable thread safety in libpq3. Closes: #249444 [Martin Pitt]
  * Drop obsolete --enable-recode configure option [Martin Pitt]
  * Changed the very-old-version-warning to complain if upgrading from pre 7.2
    (i. e. from pre-Woody) and removed a lot of obsolete configuration
    conversion code. [Martin Pitt]
  * Removed the obsolete test for deleted configuration files since dpkg
    restores them anyway and copying *.dpkg-dist files to restore them is
    wrong (since these do not exist when the conffile has been deleted)
    [Martin Pitt]
  * postinst: fixed dollar quoting in call to chmod in generated script to
    make it actually work (and the "too few arguments" warning disappear)
    [Martin Pitt]
  * postgresql.config: only ask for upgrade policy and dump/backup paths when
    actually upgrading; now this script is automatically generated from
    postgresql.config.in to insert the current version [Martin Pitt]
  * postrm purge: now also delete .bash_profile and .login besides .profile and
    changed order of commands to actually make /var/lib/postgres empty
  * test for existence of invoke-rc.d before actually calling it to comply to
    Policy 9.3.3.2 [Martin Pitt]
  * fixed subtle bug in dumpall_loc.inc that broke upgrading: the interleaving
    of old prerm and new preinst scripts could cause new binaries to be saved
    in the old version's binary dump directory. Closes: #203994 [Martin Pitt]
  * now /etc/postgresql/* is owned by root, not postgresql (conforming to
    Policy) [Martin Pitt]
  * Small fixes in the debconf templates [Martin Pitt]
  * Created and added German debconf templates [Martin Pitt]
  * Completely rewrote mechanism to save old binaries; now all linked
    libraries are saved as well, which should fix many upgrading problems.
    get_old_bins.inc and prerm.inc were replaced by savebin.inc and the
    maintainer scripts were updated accordingly.
    Closes: #236554, #239657, #239899 [Martin Pitt]
  * Added patch 12hba-tokenerror to show the correct authentication token in
    error message (should help to fix #249083) [Martin Pitt]

 -- Martin Pitt <mpitt@debian.org>  Thu, 27 May 2004 14:01:24 +0200

postgresql (7.4.2-4) unstable; urgency=medium

  * Urgency medium since this fixes an RC bug also present in testing
  * Changed default postgresql.conf: not log to syslog anymore, but to
    /var/log/postgresql/postgres.log. Closes: #241819
  * postgresql now depends on postgresql-client (>= 7.4); before it
    effectively was >= 7.3 which broke upgrading from 7.3. Closes: #241873
  * Deactivated server.inc; paths of server include files are now left as in
    upstream. Closes: #243826
  * do.maintenance now calls psql with -X to avoid reading ~/.psqlrc (which
    may cause undesired output). Closes: #242880

 -- Martin Pitt <mpitt@debian.org>  Thu, 22 Apr 2004 14:24:50 +0200

postgresql (7.4.2-3) unstable; urgency=medium

  * Added patch 21pg_dump_convnow which adds option '-N' to pg_dump and
    pg_dumpall to convert DEFAULT 'now' to DEFAULT now(); previously
    postgresql-dump used sed, but this also changed string values. Sorry for
    the mess! [Martin Pitt]
  * debconf question whether to allow automatic upgrading now defaults to
    'yes'.

 -- Martin Pitt <mpitt@debian.org>  Fri,  2 Apr 2004 18:09:30 +0200

postgresql (7.4.2-2) unstable; urgency=medium

  * Urgency medium since this fixes an RC bug also present in testing and this
    is no new upstream version
  * Deleted superfluous space in postgresql.conf. It works also with space,
    but comment says the opposite. Closes: #237359 [Martin Pitt]
  * pkgIndex.tcl cannot be generated on autobuilders since this would require
    a build-dependency on libpq3; this file is now kept in the source package
    and is regenerated if deleted. Closes: #226486 [Martin Pitt]
  * Changed libpgtcl dependency from 'tcl8.4|tclsh' to 'tcl8.4' since the
    library is linked against libtcl8.4.so (which is not provided by earlier
    tcl versions). Closes: #238722 [Martin Pitt]
  * p-contrib now rotates /var/log/postgresql/autovacuum_log. Closes: #238806
    [Martin Pitt]
  * Protected all necessary 'cmd && cmd' in 'set -e' scripts with '|| true' to
    avoid script failures. Closes: #240008 [Martin Pitt]
  * Corrected postgresql-doc.doc-base title and author. Closes: #240097
    [Martin Pitt]
  * Modified 24autovacuum patch to detach from stdin, stdout, stderr.
    Closes: #225680 [Martin Pitt]
  * Fixed postinst script to not sending bogus error mails when the automatic
    upgrade succeeded. Closes: #225668 [Martin Pitt]
  * Fixed trap in postinst: status mails now have correct subject
    [Martin Pitt]
  * Added postgresql-dump option '-n' to convert from DEFAULT 'now' to
    DEFAULT now() and use this parameter in the postinst for upgrading.
    Closes: #226294, #241091 [Martin Pitt]
  * postinst: separated out actual database upgrading into function
    do_upgrade(); it is much easier to read now
  * postinst now explicitly checks whether postmaster startup failed because
    of an old database; it may fail because of other reasons. Closes: #161200
    This now also displays the reason when postgresql fails to start because a
    fake start-stop-daemon was used in a chroot. Closes: #209171
    [Martin Pitt]
  * preinst: check for presence of /usr/lib/postgresql/bin/postgres to decide
    whether to save old binaries; merely checking the directory existence
    always succeeds since postgresql depends on postgresql-client.
    Closes: #219487 [Martin Pitt]

 -- Martin Pitt <mpitt@debian.org>  Wed,  31 Mar 2004 12:17:42 +0200

postgresql (7.4.2-1) unstable; urgency=low

  * New upstream bugfix release.
  * Updated fr.po internationalisation file.  Closes: #232069
  * Updated dependencies to comply to renaming of libpgperl to libpg-perl.
    Closes: #231540 [Martin Pitt]
  * Added in README.Debian a URL of a slide presentation on locking and
    database consistency.
  * Removed debugging path from convert.ph_hba.conf, now converts the correct
    file. Closes: #226363 [Martin Pitt]
  * Removed upgrade74 debconf question again since it is fundamentally broken
    (see bug report for details). Closes: #230681, #236305 [Martin Pitt]
  * Changed psql menu entry from "PostgreSQL Databases" to "PostgreSQL
    interactive terminal (psql)". Closes: #234893 [Martin Pitt]
  * Updated jp.po internationalisation file. Closes: #235106 [Martin Pitt]
  * postgresql-dump.in: read LC_* settings from previous installation to
    maintain locale settings. Closes: #235892
  * Saner autovacuum configuration and integration:
    - cronjob only calls do.maintenance if pg_autovacuum is not running
    - stats_start_collector is now enabled by default (required for
      autovacuuming)
    Closes: #231542 [Martin Pitt]
  * Added postgresql-contrib.postinst and postgresql-contrib.postrm to restart
    postgresql after installation and removal; this will automatically
    (de-)activate the autovacuum daemon [Martin Pitt]
  * All right-hand sides in postgresql-client are now quoted, per 
    lintian warning.

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 10 Mar 2004 14:36:16 +0000

postgresql (7.4.1-3) unstable; urgency=low

  * I'm doing the upload for Oliver Elphick since he cannot do uploads at the
    moment; this is neither a NMU nor a hijack
  * Corrected libpq3 shlibs file. Closes: #230745, #230259
  * Do not refer to button labels in debconf templates. Closes: #230982
  * Make configuration files writeable before calling initdb. Closes: #228450
  * do.maintenance is now called with -F in cronjob; this avoids sending a
    warning mail every 5 hours when AUTOVACUUM is enabled and does no other
    harm. Closes: #224266

 -- Martin Pitt <mpitt@debian.org>  Tue,  3 Feb 2004 22:04:49 +0100

postgresql (7.4.1-2) unstable; urgency=low

  * Patch 09hppa-linux to provide spinlocks for PA-RISC Linux version.
    Closes: #225729
  * postinst.in: corrected sed expression to change datestyle in
    postgresql.conf. Closes: #225628 [Martin Pitt]
  * added patch 08createuser to fix createuser.c: it generated an invalid SQL
    string when only '-E' without '-P' was given. Closes: #224716 
    [Martin Pitt]
  * deleted postgresql-doc.dhelp and don't install it any more into -doc. This
    file is generated by install-docs in the postinst on package installation;
    this altered the md5sum of this file which made debsum complain.
    Closes: #222983 [Martin Pitt]
  * changed patch 03initdb_for_debian to give correct instructions how to
    start the server. Closes: #221924 [Martin Pitt]
  * p-contrib: build manpage for my2pg.pl [Martin Pitt]
  * changed build-dependency from flex-old to flex; the current version now
    builds happily with the new flex. Closes: #190329 [Martin Pitt]
  * fixed typo in debconf templates: chnaged -> changed. Closes: #226856
  * Added French translation of debconf templates.  Closes: #227045
  * Update Japanese translation of debconf templates. Closes: #227220
  * now uses getent instead of grepping /etc/passwd in dumpall_loc.inc to work
    also with NIS/LDAP. Closes: #227216 [Martin Pitt]
  * symlinked pg_config and libpq3-config to /usr/bin/ so that they can be
    called without a special $PATH. Closes: #227887 [Martin Pitt]
  * moved plperl.so from libpgperl to main postgresql package since it does
    not belong to libpgperl; changed Conflicts: to reflect this. 
    Closes: #132293 [Martin Pitt]
  * Add debconf question share/postgresql/upgrade74 to postgresql, libpq3
    and postgresql-client.  This is to ensure that the user has (or claims
    to have) an up to date dump of the database if he is upgrading from
    an earlier major version.  This will provide a means of doing a
    manual upgrade, even if an automatic one fails. Closes: #225812, #225635
  * splitted out auxillary packages (pgeasy, pgperl, psqlodbc, plr) to
    separate source packages [Martin Pitt]
  * now has a proper orig.tar.gz. Closes: #206761 [Martin Pitt]
  * updated README.Debian.
  * applied psql.1.patch to the SGML documentation (see new patch
    11mandefaultdb) and deleted patch file [Martin Pitt]

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 25 Jan 2004 18:19:54 +0000

postgresql (7.4.1-1) unstable; urgency=low

  * New upstream bugfix release.
  * Move out of experimental, now that the testing logjam has finally
    cleared.
  * postgresql-dev: pg_config is no longer linked to pg_wrapper
    Closes: #220766
  * postinst.in: unset noclobber option to allow config file alterations even
    if noclobber was previously set. Closes: #221144 [Martin Pitt]
  * Fix bug in postgresql-startup when a different port is defined but no
    other options.  Closes: #220573
  * Make postgresql-dump use the new pg_dump rather than the old binary.
    (It still needs the old postmaster.) Make it retry with the old binary
    if the new one fails.
  * Change leading spaces to TAB in src/tutorial/Makefile
  * Use `locale -a` instead of listing /usr/lib/locales. Closes: #225008
  * Change Apps/Database to Apps/Databases in postgresql-doc.doc-base to
    agree with the menus and with other packages.
  * Add pg_pam.HOWTO file to postgresql-doc package.
  * Update policy version to 3.6.1

 -- Oliver Elphick <olly@lfix.co.uk>  Sat, 27 Dec 2003 11:58:52 +0000

postgresql (7.4-1) experimental; urgency=low

  * New official upstream release.
  * Fix typo in debian/rules that prevented display of the regression test
    differences if there was an error.

 -- Oliver Elphick <olly@lfix.co.uk>  Mon, 17 Nov 2003 22:19:13 +0000

postgresql (7.3.99.7.4rc2-1) experimental; urgency=low

  * New upstream release candidate
  * Removed /usr/lib/postgresql/src from postgresql-dev - it wasn't any use
    at all.  Closes: #201715
  * libpq3.postinst now removes old forgotten libpsql12 /usr/doc symlink.
    Closes: #189915 [Martin Pitt]
  * Change init script to identify the autovacuum daemon by user rather
    than a pidfile (which had the wrong PID in it).
  * Turn on stats row collecting in postgresql.conf; this is necessary for
    autovacuuming to work.

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 12 Nov 2003 10:20:55 +0000

postgresql (7.3.99.7.4rc1-1) experimental; urgency=low

  * First upstream release candidate for PostgreSQL 7.4
  * New upstream version of psqlodbc - 07.03.0200
  * Explained in README.Debian why pam_unix authentication does not work.
    Closes: #217891 [Martin Pitt]
  * Corrected comment in /etc/cron.d/postgresql on where autovacuuming is
    configured.  Added information on autovacuuming to README.Debian.

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 26 Oct 2003 19:17:02 +0000

postgresql (7.3.99.7.4beta5-2) experimental; urgency=low

  * calling the temporal script for database dumping differently.
    Closes: #210428 [Andreas Schuldei]
  * postgresql.init: unscrambled error output, additional check whether
    postmaster is really running [Martin Pitt]
  * cleaned up postgresql-doc: [Martin Pitt]
    - removed postgresql-doc.{postinst,prerm}; debhelper does that
      automatically
    - removed postgresql-doc.links; /usr/share/doc/postgres shouldn't exist
    - postgresql.preinst: fixed symlink removal; removed postgresql-guide
      deletion, debhelper does that automatically. Closes: #140938
    - don't install complete upstream doc/ directory any more, only
      interesting and non-redundant parts of it
      Closes: #201715, #201717, #82689
  * Build-Depends on gettext
  * Added note where to put include files to pg_hba.conf. Closes: #161218
    [Martin Pitt]
  * tutorial is not prebuilt any more, since that does not work anyway (wrong
    directory) [Martin Pitt]
  * Added patch 06tutorial to fix tutorial Makefile and extend README
    Closes: #148897 [Martin Pitt]

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 22 Oct 2003 23:45:45 +0100

postgresql (7.3.99.7.4beta5-1) experimental; urgency=low

  * New upstream beta release
  * Internationalise postgresql.templates and postgresql-client.templates
    Closes: #195248
  * Further fix to bug in postgresql.config.  It seems that debconf
    substitutions must not contain newlines.
  * Corrected Build-Dependencies: removed postgresql-client, added real
    package alternative for libpam-dev, alternated zlib1g-dev
    Closes: #200687. [Martin Pitt]
  * Corrected postgresql dependencies: adduser is now a pre-depends
    Closes: #180199. [Martin Pitt]
  * nonstandard data directory (asked by debconf) is now really used
    Closes: #193493. [Martin Pitt]
  * Update /etc/postgresql/postgresql.conf to match new upstream version
    (with additional or changed GUC parameters)
  * Give better extended description for odbc-postgresql.  Closes: #209792
  * New upstream version fixes pg_dumplo. Closes: #183427
  * Make sure server-side include files are included in postgresql-dev.
    Closes: #215683
  * Made init script output policy-compliant. Closes: #107741. [Martin Pitt]

 -- Oliver Elphick <olly@lfix.co.uk>  Sat, 18 Oct 2003 23:22:58 +0100

postgresql (7.3.99.7.4beta4-3) experimental; urgency=low

  * postgresql: fix bug in config script.  Where a configuration file was
    missing, its name was added to debconf question postgresql/missing_conf
    on a separate line but without a preceding space.  As a result, it was
    interpreted as a command and unsuccessfully executed, causing the failure
    of the preinst script.
  * Run the regression tests as part of the build-arch target in debian/rules

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 12 Oct 2003 11:41:22 +0100

postgresql (7.3.99.7.4beta4-2) experimental; urgency=low

  * postgresql-dump now uses the function pg_encoding_to_char() rather than
    the program pg_encoding, which is liable to be removed soon.
  * Remove the libpqpp and libpqpp-dev packages, since the library is
    obsolete and no longer required.

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 12 Oct 2003 10:29:04 +0100

postgresql (7.3.99.7.4beta4-1) experimental; urgency=low

  * New upstream beta version
  * Applied patch from CVS to src/interfaces/ecpg/utils/timestamp.c
  * Renamed definition and use of a local function strndup() to estrndup()
    in src/interfaces/ecpg/libcompat/informix.c
  * Expanded some long descriptions in debian/control
  * Added status command to /etc/init.d/postgresql.
  * Change /etc/init.d/postgresql to start pg_autovacuum if it is enabled
    by new variables set in /etc/postgresql/postmaster.conf and if the
    package postgresql-contrib is installed.  If pg_autovacuum is running,
    the do.maintenance script (run by cron) will not do any vacuuming unless
    the -F option is set to force it.  Add a mention of autovacuuming to
    the debconf message about VACUUM FULL.
  * Remove extra shift from initdb in handling --debian-conffile option;
    this was causing a command line parameter to be lost.
  * Isolate all version numbers for various software at the top of
    debian/rules for easier maintenance.
  * Fix problem in testing for whether pg_hba.conf needs updating.  This was
    giving the wrong result when the host address and mask were expressed
    as a single CIDR field.  As an extra safeguard, the conversion script
    will abort if it finds unexpected data at the end of a line in
    pg_hba.conf.
  * postgresql: increased sleep time in postinst after restarting postmaster
    from 5 to 10 seconds, because the postmaster is taking some time to get
    fully started and there were spurious reports that the postmaster had
    failed to start.

 -- Oliver Elphick <olly@lfix.co.uk>  Tue,  7 Oct 2003 19:03:48 +0100

postgresql (7.3.99.7.4beta2-3) experimental; urgency=low

  * libecpg4-dev now depends on libecpg4

 -- Oliver Elphick <olly@lfix.co.uk>  Thu, 11 Sep 2003 09:30:47 +0100

postgresql (7.3.99.7.4beta2-2) experimental; urgency=low

  * /usr/lib/libpgtypes.so was in two binary packages

 -- Oliver Elphick <olly@lfix.co.uk>  Mon,  8 Sep 2003 10:19:12 +0100

postgresql (7.3.99.7.4beta2-1) experimental; urgency=low

  * Beta version of upcoming 7.4 release.
  * Updated versions of PL/R (0.5.2-alpha) and ODBC (7.03.0100)
  * New binary package libecpg4 for new major version of this library.
  * PyGreSQL is no longer part of the upstream source, so we drop the
    binary package python-pygresql.

 -- Oliver Elphick <olly@lfix.co.uk>  Fri, 29 Aug 2003 23:00:01 +0100

postgresql (7.3.4-6) unstable; urgency=low

  * libecpg3-dev: now depends on libecpg3.  Closes: #210398
  * postgresql-dev: no longer depends on libecpg3
  * postgresql: /etc/init.d/postgresql now has a status command.
    Closes: #212423
  * Added upstream patch to src/backend/executor/spi.c to throw an error
    if an SPI operation is called without a previous SPI_connect().
    Patch: 13spi
  * Added upstream patch to correct a bug in dumping schemas.
    Patch: 31ruleutils

 -- Oliver Elphick <olly@lfix.co.uk>  Fri,  3 Oct 2003 06:28:50 +0100

postgresql (7.3.4-5) unstable; urgency=low

  * python2.x: that proper path in 7.3.4-4 was improper.  Remove one level
    of parent directory.  Closes: #210278

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 10 Sep 2003 14:42:42 +0100

postgresql (7.3.4-4) unstable; urgency=low

  * Remove erroneous line accessing /tmp/psql.1 from debian/rules
  * New python patch from Matthias Klose <doko@cs.tu-berlin.de>.
    Closes: #209742
  * python2.x: add proper library path for -lpq to setup.py.
    Closes: #209247

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 10 Sep 2003 04:25:52 +0100

postgresql (7.3.4-3) unstable; urgency=low

  * postgresql-contrib: add the mysql conversion scripts.  (They were
    advertised but not present.)
  * postgresql: move the creation of the postgres user to the top of the
    preinst script.  The subsequent absence of that user becomes a fatal
    error.  Closes: #207790
  * postgresql: make postinst use $TMPDIR wherever a temorary directory
    is used.  Closes: #208108
  * python-pygresql: Apply patch from Matthias Klose to put right the
    packaging and provide versioned modules.  Closes: #208017, #208018, #208407
  * postgresql: Add debconf note to warn about the use of cron to run
    VACUUM FULL every Sunday (some adminstrators may want to disable this).
    Closes: #183106
  * postgresql-client: Added 2 missing long options for psql to pg_wrapper
  * postgresql-doc: moved /usr/share/doc/postgresql-doc/build-tree/{x}/src
    up two levels and removed the build-tree/{x} directory, which was never
    meant to be there.
  * postgresql-client: Altered man page for psql to document that Debian
    requires a database to be specified on the command line (see bug #201712)

 -- Oliver Elphick <olly@lfix.co.uk>  Wed,  3 Sep 2003 09:03:01 +0100

postgresql (7.3.4-2) unstable; urgency=low

  * Reenable kerberos authentication, but build against libkrb5-dev
    instead of heimdal-dev.

 -- Oliver Elphick <olly@lfix.co.uk>  Thu, 28 Aug 2003 16:30:24 +0100

postgresql (7.3.4-1) unstable; urgency=low

  * New upstream bugfix release.  Urgent for anyone running 7.3.3
  * Add --debian-conffile option to initdb, for use in the installation
    scripts.  This puts the configuration files in /etc/postgresql, while
    leaving the possibility of creating private databases in the manner
    expected by upstream users.  Closes: #195880
  * Move /usr/lib/postgresql/bin/pltcl_*mod from postgresql package to
    libpgtcl.  Closes: #200034
  * Move clusterdb and vacuumdb commands from postgresql package to
    postgresql-client, since they are client-side commands. Closes: #200032
  * Move pg_dumpall to postgresql-client so that users on remote systems
    can still use it.  This should not affect existing installations,
    because postgresql depends on postgresql-client anyway.  Closes: #200031
  * libpgtcl: expand the package description to mention the PL/Tcl procedural
    langucage.  Closes: #200027
  * libpgtcl: Add symlinks for pgtclsh and pgtksh in  /usr/bin.
    Closes: #200026
  * Added lines to logcheck default filter to exclude "connection received"
    and "connection authorized" messages.  Closes: #200616
  * Fixed typo in getopts command of do.maintenance script.  Closes: #205175
  * Corrected netmask in reject line of the default pg_hba.conf from
    255.255.255.255 to 0.0.0.0.  Closes: #204102
  * Added a line specific to the postgres user to pg_hba.conf with a note
    that it should not be deleted without making other arrangements for
    automatic maintenance access from cron.  Closes: #204089
  * Build for python 2.3.  Closes: #205745
  * Removed kerberos support, because heimdal-dev is no longer installable
    (because libacl1 is a base package and conflicts with
    libacl1-kerberos4kth)

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 27 Aug 2003 15:08:05 +0100

postgresql (7.3.3-1) unstable; urgency=low

  * New upstream release (bug-fixing)
  * New upstream version of PL/R
  * postgresql-client: preinst was crashing out if postgresql was not
    installed.  Closes: #195202
  * postgresql-dev: Now suggests heimdal-dev (which supplies libkrb5.a).
    Closes: #194940
  * postgresql: fix typos in the postinst script.  Closes: #195597

 -- Oliver Elphick <olly@lfix.co.uk>  Sat, 31 May 2003 22:20:17 +0100

postgresql (7.3.2r1-6) unstable; urgency=low

  * Build depend on flex-old and remove the botched patches introduced in
    7.3.2r1-4 (bug #190329 - not closed because this is still not an ideal
    solution).
  * The character encoding number of the default database was incorrect after
    running postgresql-dump when upgrading from 7.2 to 7.3 and when the
    old default database encoding was anything other than SQL_ASCII, EUC_JP,
    EUC_CN, EUC_KR or EUC_TW.  I have added a translation step to
    postgresql-dump to get round this problem.  Closes: #194011

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 21 May 2003 10:55:23 +0100

postgresql (7.3.2r1-5) unstable; urgency=low

  * Change debconf question in postgresql-client to remove redundant
    wording.  Closes: #191615
  * Upstream fix to pg_dump to cure possible segfault with databases that use
    PL languages. (debian/patches/29pg_dump)

 -- Oliver Elphick <olly@lfix.co.uk>  Mon,  5 May 2003 11:22:35 +0100

postgresql (7.3.2r1-4) unstable; urgency=low

  * Fix contrib lexer sources to allow use of new flex. Closes: #190329
    This is a quick and ugly fix using the minimal changes needed to get it
    to compile (patches/36flex).  An improved version would be welcome...
    Remove versioned Build-Dependency on flex.

 -- Oliver Elphick <olly@lfix.co.uk>  Fri, 25 Apr 2003 20:27:23 +0100

postgresql (7.3.2r1-3) unstable; urgency=low

  * Removed detailed descriptions from README.postgresql.conf.gz, since these
    merely duplicate what is already in the manual and can get out of sync
    with it.  Closes: #188517
  * Updated text in README.passwords.
  * Patch to allow configure to accept flex >= 2.5.30 (it was falling foul of
    the test for buggy 2.5.3).
  * Make sure there is nothing in the installation scripts that can possibly
    overwrite /etc/postgresql/pg_hba.conf.  postgresql-dump will now delete
    the database file pg_hba.conf (which should be a symbolic link to
    /etc/postgresql/pg_hba.conf) before writing anything to it.  The symbolic
    link is restored at the end of the script.  Closes: #183721
  * flex 2.5.31 breaks several contrib modules, so I have put in a build
    dependency of (<= 2.5.4a-33)

 -- Oliver Elphick <olly@lfix.co.uk>  Fri, 18 Apr 2003 07:20:45 +0100

postgresql (7.3.2r1-2) unstable; urgency=low

  * Moved libpqpp to section libs from devel (where it has wrongly been for
    some time).
  * Added command libpq3-config for use by scripts statically linking libpq3.a
    to enable them easily to link the correct libraries.  Closes: #183721

 -- Oliver Elphick <olly@lfix.co.uk>  Tue,  8 Apr 2003 13:45:18 +0100

postgresql (7.3.2r1-1) unstable; urgency=low

  * New upstream version of PL/R - 0.3.1-alpha, so new orig.tar.gz
  * Change plr module pathname to $libdir
  * Remove createlang patch to change $libdir to $libdir/lib since this is
    obsoleted by the fix to Makefile.global in release -7. Closes: #186385
  * Changed sections of several binary packages to match the reorganisation
    announced by the ftp archive maintainer.
  * Applied upstream patch to fix problem with ON DELETE SET DEFAULT in
    referential integrity code.
  * Fix to missing HTML docs.  Closes: #187186

 -- Oliver Elphick <olly@lfix.co.uk>  Wed,  2 Apr 2003 08:43:29 +0100

postgresql (7.3.2r-7) unstable; urgency=low

  * Revised ODBC and UNIX HOWTO text to show how to access schemas
  * Fix the return type of the timezone() function.
  * Patch src/Makefile.global.in to set pkglibdir to /usr/lib/postgresql/lib
    and thus fix the problem with misinterpreted $libdir.
    Closes: #182663
  * Fix error in postgresql.config (change db_set to db_get at line 202)
    Closes: #172572
  * Applied patch supplied by Roland Mas <lolando@debian.org> to fix an
    error in setting a temporary file path. Closes: #181501
  * /etc/init.d/postgresql start will now check whether postmaster.pid
    belongs to a running postmaster process.  If it doesn't, it will remove
    it.  Closes: #184782

 -- Oliver Elphick <olly@lfix.co.uk>  Fri, 21 Mar 2003 21:27:54 +0000

postgresql (7.3.2r-6) unstable; urgency=low

  * Added Build dependency on libltdl3-dev.  Closes: #184834

 -- Oliver Elphick <olly@lfix.co.uk>  Sat, 15 Mar 2003 00:35:28 +0000

postgresql (7.3.2r-5) unstable; urgency=low

  * Enable NLS for multiple languages.
  * Upstream patch to planner (debian/patches/26planner.c)
  * Upstream patch to date.c to stop it corrupting its input
    (debian/patches/27date.c)

 -- Oliver Elphick <olly@lfix.co.uk>  Fri, 14 Mar 2003 09:41:50 +0000

postgresql (7.3.2r-4) unstable; urgency=low

  * Upstream patch (23pg_restore) to fix a problem with pg_restore and blobs.
  * Added PL/R documentation.  Closes: #183916

 -- Oliver Elphick <olly@lfix.co.uk>  Sun,  9 Mar 2003 20:56:48 +0000

postgresql (7.3.2r-3) unstable; urgency=low

  * Upstream patch to planner, which was crashing the backend in certain
    queries containing inherited tables.
  * postgresql: postinst now sends mail to root rather than root@localhost.
    Closes: #183627
  * postgresql-client: pg_dumpall now accepts the option "--globals-only" as
    a synonym for "-g".
  * postgresql.config: added "|| true" after a db_input that lacked it and
    was causing the postinst to fail.  Closes: #180407
  * Added a README.Debian file to postgresql-client to explain the
    incompatibility between psql from 7.3 and servers of 7.2.x and earlier.
    Closes: #183872

 -- Oliver Elphick <olly@lfix.co.uk>  Sat,  8 Mar 2003 00:27:29 +0000

postgresql (7.3.2r-2) unstable; urgency=low

  * Correction to changelog for 7.3.2r-1: R_HOME is not defined in
    /etc/postgresql/init.d.  It is read from the environment by the PL/R
    module and set to /usr/lib/R if it is undefined.
  * Added upstream patch to fix a memory leak in spi.
  * postgresql-client: set datestyle to ISO at start of pg_dump so that all
    dates will be put into the dump in a portable format.  Closes: #117668
  * Fixed a typo that crept into /etc/init.d/postgresql through my typing in
    the wrong window.  Closes: #183411

 -- Oliver Elphick <olly@lfix.co.uk>  Tue,  4 Mar 2003 19:01:47 +0000

postgresql (7.3.2r-1) unstable; urgency=low

  * Upstream patch to fix a problem with idle clients letting the SI
    buffer overrun, so that the connected backend would ignore "fast"
    shutdown requests.
  * Removed reference to C++ libraries in the long description of the
    libpq3 package.
  * Add the PL/R procedural language (as an optional extra). This requires
    a Build-Dependency on r-base-core.  The plr module is included as an
    additional source package, so the version number is amended to 7.3.2r
    to ensure that we can upload a new upstream source.  The module has
    to be built under contrib, so we tweak the contrib Makefile to build it
    along with all the other contrib modules.
  * Amend /etc/init.d/postgresql to define R_HOME which is needed for the R
    interpreter to run.
  * r-base-core does not seem to call ldconfig successfully for libR.so, so
    we use -rpath when linking plr.so
  * Applied upstream patch to avoid getting the wrong value of now when the
    timezone is changed within a transaction.

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 23 Feb 2003 22:53:16 +0000

postgresql (7.3.2-3) unstable; urgency=low

  * Inserted missing docs (README files) for postgresql-contrib
  * Increased default sort memeory size to 8Mb; this will give much
    better responsiveness in large queries on out-of-box installations.
  * Add libxml2-dev to Build-Depends.  Closes: #181066
  * Add upstream patches for bugs in spi, the rewrite handler and in the
    functioning of ALTER TABLE ADD COLUMN to allow column constraints to
    be added.

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 16 Feb 2003 21:58:24 +0000

postgresql (7.3.2-2) unstable; urgency=low

  * Removed pgperl-2.0.tar.gz from source; removed move-modules-stamp
    target from debian/rules
  * Now produces a proper orig.tar.gz archive and diff. Closes: #175247
  * libpq3 preinst: allow setting of $installed to fail without aborting
    the script. (Messages in Oct 2002 re Sparc buildd, but no bug number.)
  * Simplify cron commands.  Closes: #177855
  * Rename /etc/logcheck/violations.ignore.d/postgresql to
    /etc/logcheck/violations.ignore.d/logcheck-postgresql.  Closes: #177481
  * Change trap in createuser to exit and set return code to 1 if the user
    cancels the script or it is killed.  Closes: #177053
  * odbc: Use signed char explicitly in ConnInfo, to avoid problems on
    architectures where char is unsigned by default.  Closes: #176406
  * libpqpp-dev: pgconnection.h now includes pg_config.h.  Closes: #175841
  * Fixed some typos in debian/control.  Closes: #175273
  * libpqpp: at some stage since December 19, the libpq++.so and libpq++.a
    libraries have been put in the same place (/usr/lib).  Closes: #173695
  * Include the tutorial in postgresql-doc.  Closes: #171828
  * Enable the xml module in contrib.  Closes: #167221

 -- Oliver Elphick <olly@lfix.co.uk>  Fri,  7 Feb 2003 23:00:05 +0000

postgresql (7.3.2-1) unstable; urgency=low

  * New upstream bugfix release.
    -- fixes segfault in pg_restore.  Closes: #177704
  * Change default buffers to 1000 in /etc/postgresql/postgresql.conf.
    This might cause problems on systems with very little memory, but
    will give better performance on most systems.
  * Remove suggestion of pgmonitor from control file and suggest pgaccess
    instead. (pgmonitor is now supplied with pgaccess.)
  * Use $TMPDIR rather than /tmp if $TMPDIR is set; let start-stop-daemon
    run temporary scripts with bash rather than trying to invoke them
    directly.  Closes: #179125
  * In preinst, use 'addgroup --system' rather than 'addgroup', following
    information from Colin Watson that the addgroup manpage is wrong.
    Closes: #179819
  * Changed Build-Depend version of debhelper to 4.1.29.
  * libpgperl: Moved Pg.pm from /usr/lib/perl5 to /usr/share/perl5 per
    lintian message.
  * postgresql-dev: Added a dependency on postgresql-client, because
    pg_config is linked to pg_wrapper.  Closes: #180045
  * libpq3: rebuild has fixed the problem where the shared library had 2
    versions of libcrypto.so linked in.  Closes: #180047
  * Add Tom Lane's patch for deleting dependencies of a temporary table.
  * Add Tom Lane's patch to backend/optimizer/plan/initsplan.c

 -- Oliver Elphick <olly@lfix.co.uk>  Fri,  7 Feb 2003 12:35:36 +0000

postgresql (7.3.1-5) unstable; urgency=low

  * Sorted out problems with createlang and $libdir
  * Changed section for python-pygresql to interpreters; the overrides
    file has also been changed, and there are now no discrepancies
    between debian/control and the overrides.
  * Corrected short description of libpq3

 -- Oliver Elphick <olly@lfix.co.uk>  Fri, 17 Jan 2003 13:58:27 +0000

postgresql (7.3.1-4) unstable; urgency=low

  * Fixed typo in postinst (missing quote).  Closes: #176259
  * If the directory given by upgrade/preserve_location does not exist,
    create it and give its ownership to postgres.  Closes: #176260
  * Chnage the description of initdb/location in postgresql.templates.
    Closes: #176258
  * Change the debconf choice for US date format from nonEuropean to US.
    Both are valid, but US corresponds better to the description.
    Closes: #176257

 -- Oliver Elphick <olly@lfix.co.uk>  Sat, 11 Jan 2003 17:58:11 +0000

postgresql (7.3.1-3) unstable; urgency=low

  * Revised postgresql.conf configuration file to add the
    dynamic_library_path which is needed by many of the contrib modules
    and by some existing installations where language module locations are
    not specified by absolute path.

 -- Oliver Elphick <olly@lfix.co.uk>  Mon,  6 Jan 2003 05:52:35 +0000

postgresql (7.3.1-2) unstable; urgency=low

  * Need to add -fPIC to compilation of .o files in building libpq++.
    Closes: #173084
  * Change postinst and init script to use start-stop-daemon instead of
    su to run processes as the postgres user.  Closes: #

 -- Oliver Elphick <olly@lfix.co.uk>  Fri,  3 Jan 2003 18:22:37 +0000

postgresql (7.3.1-1) unstable; urgency=low

  * New upstream bug-fix version
    - libpq library should have had its soname major number changed with
      the release of 7.3.  It's changed now, so I've made a new binary
      package libpq3.
    - patches 08pg_hba.conf-linecount and 09copy removed because they are
      now in the upstream code.
  * postgresql: preinst reads contents of $PGDATA/PG_VERSION, which may
    not exist.  Append "|| true" to prevent an error abort of the
    installation script.  Closes: #173368
  * Corrected typo in postgresql.templates - per_lcoale should be
    per_locale.  Closes: #173622
  * Change text of debconf templates, so as not to ask a question
    again in the description.
  * Add a debconf question whether to try to run enable_lang.  If
    enable_lang fails we ignore the error.  Closes: #172761
  * Correct error in README.Debian.migration.gz.  pg_dumpall needs the -d
    option (not -i) to dump data as a series of INSERT statements.
  * Move pg_config into postgresql-dev, since it belongs with the
    development files.
  * Moved all shared libraries that need to be seen by ldconfig into
    /usr/lib from /usr/lib/postgresql/lib
  * Correction to error reporting in postgresql-dump.
  * Fix some scripting errors in postgresql-dump; it was calling exit
    inside a sub-shell, which did not exit the main shell.
  * Use two diversions to allow libpgsql2 (< 7.3) to coexist with libpq3.
    libpgsql2 contains the libpq++4.0 shared library, which is now in its
    own package in 7.3.

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 29 Dec 2002 19:51:17 +0000

postgresql (7.3rel-9) unstable; urgency=low

  * debian/rules build-indep target was trying to do a chown, which needs
    root privilege and broke the autobuilders.  Closes: #171857
  * Change -fpic to -fPIC throughout.  Closes: #173084
  * postgresql-dump no longer writes to /dev/tty; the reason for this is
    no longer valid.  Closes: #172993

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 15 Dec 2002 04:11:16 +0000

postgresql (7.3rel-8) unstable; urgency=low

  * Oh no! not again!  -  postgresql-dev needs a dummy prerm to replace
    the bad one in earlier versions.  Simply deleting the prerm was not
    enough.  Closes: #172650, #172759

 -- Oliver Elphick <olly@lfix.co.uk>  Fri, 13 Dec 2002 11:34:47 +0000

postgresql (7.3rel-7) unstable; urgency=low

  * postgresql-dev: get rid of libpq++.H symlink, which is no longer
    required.  Move it to the libpqpp-dev package. Closes: #172615
  * postgresql-client: postinst - wrong sort of quotes in trap command
    Closes: #172677
  * Build with Tk/Tcl 8.4 instead of 8.3.  Closes: #172668
  * Included upstream patch 08pg_hba.conf-linecount to report accurately
    the error line number in pg_hba.conf.  Closes: #172204
  * postgresql-contrib: include the adddepend utility.
  * Mention adddepend in README.Debian.migration
  * The installation scripts mail configuration problems and upgrade
    problems to root.  Therefore we need a dependency on mailx which
    provides /usr/bin/mail.   Closes: #172689

 -- Oliver Elphick <olly@lfix.co.uk>  Thu, 12 Dec 2002 12:03:43 +0000

postgresql (7.3rel-6) unstable; urgency=low

  * Make sure postgresql-dev contains /usr/lib/postgresql/b/libpq.so to
    tie in with pg_config --libdir.  Closes: #172431
  * Fix debconf bug in setting default encoding; this now allows specification
    by the chosen locale.  Closes: #172352
  * Further corrections to postgresql-dump.

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 11 Dec 2002 03:26:24 +0000

postgresql (7.3rel-5) unstable; urgency=low

  * postgresql: postinst also needs to enclose DATESTYLE in single
    quotes (re Bug #171637)
  * do.maintenance now uses full path to invoke-rc.d.  Closes: #171676
  * enable_lang: strip leading space from database names. Closes: #171682, #172316
  * rearrange debian/rules to ensure that commands needing fakeroot
    only happen in binary/* and clean. Closes: #171857
  * Added a warning in postgresql.templates that directories to be used
    for database upgrade must be writable by postgres (not just root).
    Closes: #171723
  * Since postgresql-dev no longer makes a symlink to libpq++.h, do not
    try to delete it in prerm.  Closes: #171794, #172370
  * Revise postgresql-dump; it was getting too convoluted.  A simpler
    script should have fewer bugs.  Closes: #171995, #171916, #171897, #171895, #171723, #171635, #172334
  * Removed an unnecessary check and message from postgresql's preinst.
    Closes: #171992
  * Moved pltcl.so back to libpgtcl and plperl back to libpgperl.  Make
    earlier versions conflict with postgresql.  Closes: #171876
  * In do.maintenance, the FULL option to vacuum, if present, now occurs
    first.  Closes: #171836
  * When initdb modifies postgresql.conf, write the temporary file in
    the same directory.  Closes: #172183
  * Note that from the first release of 7.3, we depend on the Heimdal
    Kerberos libraries to support Kerberos 5 authentication.  This seems
    not to have been mentioned before in this changelog.
  * Note that upstream changes in 7.3 mean that logging to syslog takes
    account of the log levels set in /etc/postgresql/postgresql.conf.
    Closes: #172214

 -- Oliver Elphick <olly@lfix.co.uk>  Mon,  9 Dec 2002 20:48:24 +0000

postgresql (7.3rel-4) unstable; urgency=low

  * libpgtcl: fix bad symlink to libpgtcl.so
  * libecpg, libpqpp: fix bad symlinks
  * libpgpp, libpgeasy: fix bad symlinks
  * postgresql.conf: enclose DATESTYLE value in single quotes.
    Closes: #171637
  * preinsts will not now fail even if there is no postgres user in
    /etc/passwd
  * Removed dh_testroot from inappropriate targets in debian/rules.
    Closes: #171600

 -- Oliver Elphick <olly@lfix.co.uk>  Wed,  4 Dec 2002 01:40:40 +0000

postgresql (7.3rel-3) unstable; urgency=low

  * Don't try to copy /usr/lib/postgresql/dumpall if it is a symlink
    already
  * Removed duplicate debconf dependency
  * Add lintian overrides for spurious errors

 -- Oliver Elphick <olly@lfix.co.uk>  Tue,  3 Dec 2002 16:22:17 +0000

postgresql (7.3rel-2) unstable; urgency=low

  * Build dependency on heimdal-dev, not the library package.
    Closes: #171562
  * Don't assume that /usr/lib/postgresql/dumpall must exist; it does
    not exist on a new installation.  Closes: #171537
  * Debhelper compatibility level = 4.
    Added ${misc:Depends} to control file.

 -- Oliver Elphick <olly@lfix.co.uk>  Tue,  3 Dec 2002 14:11:37 +0000

postgresql (7.3rel-1) unstable; urgency=low

  * Upstream final release of 7.3
  * New release of psqlodbc (7.2.5)
  * New release of pgperl (2.0)
  * New release of libpgeasy (3.0.1)
  * New release of libpq++ (4.0)
  * Since the new modules build in standalone mode, I removed
    the patches that put them inside the main source tree.
  * Bugs fixed upstream:
    - pg_dumpall now uses "WITH OWNER =" option to CREATE DATABASE, so
      that db owners do not need CREATEDB privilege.  Closes: #136574
    - Opaque types are no longer used (except internally) so the bug
      has gone away.  Closes: #160673
    - There is now no problem with database names that contain a space
      (apart from the problems with their creators!) Closes: #113720
    - The use of TIMESTAMP as an operator or a type is now properly
      documented.  Closes: #145645
    - The INSERT documentation has been fixed to remove the idea of
      inserting multiple rows with separate VALUES phrases.
      Closes: #163963
  * The postgresql-client menu entry now runs a script that prompts for
    the database name.  Closes: #111719
  * The debconf template now includes instructions to edit ~/.profile
    if the user chooses manual config changes.  Closes: #118406
  * Debug messages seem to be under control.  Closes: #120352
  * Ignore errors from chown and chmod in postinst, in case these are
    produced by immutable .journal on an ext3 fs. Closes: #127958
  * Use of debconf Closes: #127960
  * Fixed installation problems.  Closes: #171113
  * Revised default postgresql.conf.
  * /etc/init.d/postgresql will not try to start if the postmaster or
    /etc/postgresql/postmaster.conf is missing.  Closes: #152162
  * Added -w (wait) option to pg_ctl stop in /etc/init.d/postgresql
    so that it will not return until the postmaster actually stops.
    This should ensure it doesn't start too soon.  Closes: #155325
  * enable_lang will now crash out if /etc/postgresql/postgresql.env
    is missing.  Closes: #158769
  * Increase frequency of do.maintenance (to do VACUUM ANALYZE on all
    databases) to every 5 hours.  Do a VACUUM FULL every Sunday
    morning.  Be more rigorous in testing whether it is possible to
    run.  Closes: #160967, #123383
  * Expand on error message in enable_lang to explain what needs to
    be done with pg_hba.conf.  Closes: #162022
  * Use invoke-rc.d in preinst and postinst and advise use of file-rc
    or update-rc.d to enable or disable postgresql.  This replaces
    the private system of testing can_i_run. Closes: #162121, #161206
  * postgresql-dump will now search for sub-files of pg_hba.conf and
    copy them into a newly-created PGDATA.  Closes: #162846
  * applied patch from Tuomas Heino <iheino@cc.hut.fi> to
    createlang.sh and to enable_lang, in order for them to cope with
    database names containing spaces.  Closes: #164598
  * Added logcheck ingnore line to ignore "Re-using: Free/Avail  Space..."
    messages in the log.  Closes: #135689
  * README.Debian gives basic instructions on creating new users.
    Closes: #71364
  * postgresql now Suggests other Python packages besides
    python-pygresql.  Closes: #120593
  * Use "su -s /bin/sh - postgres" instead of "su - postgres" in
    order to cope with installations where the default shell for
    postgres is set to /bin/false.  Closes: #143593
  * Moved dumpall directory to /var/lib/postgres.  Closes: #157282
  * Postmaster logs now go in /var/log/postgresql (owned by postgres)
    Closes: #161679
  * Applied upstream patch (09copy) to prevent double freeing of memory
    in COPY.  This will be in upstream version 7.3.1
  * New standards version: 3.5.8

 -- Oliver Elphick <olly@lfix.co.uk>  Mon,  2 Dec 2002 08:07:37 +0000

postgresql (7.3rc2-1) experimental; urgency=low

  * New upstream release candidate.
  * Updated packaging instructions and packaging TODO list.
  * Imported packaging to CVS
  * Added db_stop to postinst
  * Fixed error in converting postgresql.conf
  * Fixed postinst error in setting PGDATA

 -- Oliver Elphick <olly@lfix.co.uk>  Mon, 25 Nov 2002 19:12:46 +0000

postgresql (7.3rc1-1) experimental; urgency=low

  * New upstream beta release
  * Removed pgaccess, which is now a separate source package.
  * postgresql-dev and libpgsql2 no longer include libpq++ and libpgeasy,
    which have been separated from the upstream source.  libpq++ is very
    much unloved and unwanted :-(  The recommended C++ library is now
    libpqxx, which is in a separate source package.
  * Revised packaging
      - now uses dbs to manage multiple upstream tarballs; psqlodbc,
        libpqpp, pgeasy and pgperl are inserted into src/interfaces
        before the build.
      - removed obsolete information from debian/*
      - rewrote debian/rules
      - removed a lot of trace printing.  Important messages are now
        mailed to root.  A few are also sent to stderr.
  * Removed option of entering passwords from do.maintenance.  If a
    password is needed, it should be put in ~postgres/.pgpass
  * Created package maintenance instructions
  * Added information about the location of executables to README.Debian
    Closes: #167366
  * postgresql and postgresql-client isntalls now use debconf.
    Automatic upgrading is optional.

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 9 Nov 2002 23:09:18 +0100

postgresql (7.2.3-2) unstable; urgency=high

  * Used Steve Dunham's configure fix to get rid of int64 problem
    on Sparc.  (Not that the problem is really here, but it will
    clear the current log-jam).  Closes: #165060

 -- Oliver Elphick <olly@lfix.co.uk>  Sat,  2 Nov 2002 21:59:55 +0000

postgresql (7.2.3-1) unstable; urgency=low

  * Adopting NMU changes
  * libpgsql2: Extra test in presinst so as not to try to read
    non-existent PG_VERSION. Closes: #165886
  * libpgtcl: Fixed bad symbolic links.  Closes: #148335
  * libpgtcl: created a pkgIndex.tcl file (and a symbolic link to the
    shared library) in /usr/lib/postgresql, so that in Tcl you can now
    do "package require Pgtcl" and have it work.  Closes: #70430

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 23 Oct 2002 23:09:18 +0100

postgresql (7.2.3-0.2) unstable; urgency=high

  * NMU to fix build failure:
      - Copy /usr/share/misc/config.{guess,sub} to config/

 -- Ivo Timmermans <ivo@debian.org>  Tue, 15 Oct 2002 23:39:59 +0200

postgresql (7.2.3-0.1) unstable; urgency=high

  * NMU, with maintainer's consent.
  * New upstream release:
      - Includes fix for VACUUM problem.  Closes: #163311
  * debian/rules:
      - s/python2.1/python2.2/
      - python2.2-dev doesn't include a Makefile.pre.in.  Instead, compile
        with the included Makefile directly.  Closes: #159261
  * contrib/seg/segparse.y: Remove erroneous ;.

 -- Ivo Timmermans <ivo@debian.org>  Tue, 15 Oct 2002 02:07:49 +0200

postgresql (7.2.2-2) unstable; urgency=low

  * source build, libpgperl: amended the make install in the binary-arch
    target (credits to Rob Browning <rlb@defaultvalue.org>), because the build
    was trying to write to /usr.
  * Now depends on python 2.2 and python-dev
  * Build with perl 5.8.  Closes: #158710 158711

 -- Oliver Elphick <olly@lfix.co.uk>  Thu, 29 Aug 2002 09:45:13 +0100

postgresql (7.2.2-1) unstable; urgency=low

  * Upstream release to fix security issues
  * postgresql: when dumping the databases for possible upgrading, use
    $PGDATA/.. to hold the dump file rather than /usr/lib/postgresql/dumpall
    because /usr may not be large enough or may be a NFS mount.
    Closes: #157272
  * postgresql: include separate files instead of symlinks for each
    /etc/logcheck/ignore.d.* directory.  Closes: #157733
  * postgresql: logrotate file was specifying the wrong log file.  The
    log rotation using copytruncate seems effective and so the log
    rotation bugs can be closed.  Closes: #96326
  * postgresql: in accordance with policy, delete log files when postgresql
    is purged.

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 21 Aug 2002 12:58:25 +0100

postgresql (7.2.1-4) unstable; urgency=low

  * postgresql: logrotate.d/postgresql contained a private set-up that did
    not correspond with the package logging. Closes: #150146
  * postgresql: revised the contents of README.Debian.  Closes: #152454
  * Added "set -e" to all installation scripts.  Closes: #151014
  * Fixed spelling error in postgresql-dump.  Closes: #155259
  * postgresql-dev: change the includes in /usr/include/postgresql/server to
    be <server/...> rather than "...".  Closes: #154429
  * postgresql: the init script now explicitly sets and exports the path,
    to cope with being used in cron with a minimal path.  Closes: #154841
  * postgresql-client: pg_dump was segfaulting on an invalid long option.
    Closes: #150785
  * postgresql: postgresql-dump now sets permission on the directory
    containing the saved database to 700, to prevent unauthorised access
    to the data.  Closes: #150992
  * postgresql: if essential configuration files are missing, the postinst
    will now complain (and also email root) and exit.  The package will
    not work until the administrator restores the files.  Closes: #151013
  * postgresql: preinst now tests for existence of /etc/init.d/postgresql;
    add rude comments about administrators who delete necessary files.
    Closes: #151014
  * pgaccess: removed debian/pgaccess.1 which has long been superseded by
    a manpage from upstream.  Add the upstream man page to the pgaccess
    binary package.
  * pgaccess: pgaccess top-level script was not passing the command line
    parameters on to wish.  Closes: #151030
  * Enable large file support in pg_dump.
  * postgresql: Use pg_ctl -m fast to stop the postmaster rather than
    start-stop-daemon
  * postgresql: Don't use dpkg --compare-version unless we are upgrading
    from a previous version. Closes: #157066

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 18 Aug 2002 08:39:56 +0100

postgresql (7.2.1-3) unstable; urgency=low

  * postgresql: Change the message in the postinst about the consequences
    of choosing a non-C locale.  Previously it had said precisely the
    opposite of what it should have done.
  * postgresql-client: use full icon path in menu entry. Closes: #141626
  * postgresql: /etc/init.d/postgresql will now abort if run by a non-root
    user.
  * python-pygresql: apply patch to fix problem with datetime type; patch
    from Kim Oldfield <debian@oldfield.wattle.id.au>: Closes: #143562
  * postgresql: make sure the pg_hba.conf file is reread at the end of
    the postinst, so that the temporary trust permission is not perpetuated.
    Closes: #143347
  * postgresql: enable-lang - improved the grep regular expression used in
    checking for access rights.
  * postgresql: ensure that /etc/init.d/postgresql has execute permissions.
    relates to bug #144397
  * postgresql: change the default pager from more to /usr/bin/pager.
    Closes: #144152
  * postgresql: install pam and logrotate files
  * postgresql: do_maintenance script now checks for the postmaster's
    Unix socket before trying to connect to the postmaster.
  * postgresql: include a patch from Tom Lane (upstream developer) to solve
    a problem with a string append function in plpgsql.
  * postgresql: made a change suggested by Tom Lane to improve interpretation
    of statistics for multiple-columned keys.
  * postgresql-client: psql tab completion now gets GRANT DELETE right.
    Closes: #146689
  * postgresql-dev: include in /usr/lib/postgresql/src the source makefiles
    that are needed by another package to enable it to build, because it
    assumes the existence of the PostgreSQL source tree.

 -- Oliver Elphick <olly@lfix.co.uk>  Tue, 14 May 2002 16:13:42 +0100

postgresql (7.2.1-2) unstable; urgency=low

  * postgresql-contrib: Spelling and cosmetic corrections to the description
    in debian/control.
  * Removed Task: lines from debian/control; apparently this is not the right
    way to do it!
  * Again remove the -mips2 option from src/template/linux.  Upstream have
    not included the fix in the 7.2 branch.  Closes: #139003

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 31 Mar 2002 21:25:41 +0100

postgresql (7.2.1-1) unstable; urgency=low

  * New upstream bug-correction release (28th Mar 2002)
  * postgresql-client: Correction to postinst script. Closes: #140407 

 -- Oliver Elphick <olly@lfix.co.uk>  Fri, 29 Mar 2002 02:17:31 +0000

postgresql (7.2-9) unstable; urgency=low

  * Added Task: lines to some of the binary packages.
  * postgresql: correction to text in preinst
  * Applied patch for mips and mipsel to src/backend/storage/lmgr/s_lock.c
    Closes: #139003

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 27 Mar 2002 09:48:37 +0000

postgresql (7.2-8) unstable; urgency=low

  * Moved from non-US to main now that openssl has moved there. 

 -- Oliver Elphick <olly@lfix.co.uk>  Sat, 23 Mar 2002 09:43:05 +0000

postgresql (7.2-7) unstable; urgency=low

  * postgresql: moved logcheck files from /etc/logcheck/ignore.d/ to
    /etc/logcheck/ignore.d.paranoid (with symbolic links to ...server
    and ...workstation.  Closes: #138974
  * The correction to symbolic links also needs a tweak in the postinst
    to restore the proper link to /etc/logcheck/ignore.d, since the removal
    of postgresql 7-2-5 or 7.2-6 will also remove that link.
  * in src/template/linux, commented out the lines that add -mips2 to CFLAGS
    which is unnecessary on Linux.  Closes: #139003
  * postgresql: init script now supports reload.  Closes: #139242
  * postgresql-client: postgresql.env conffile was missing from a new copy.
    In these circumstances, the postinst will ask for permission to
    create a new copy.  Closes: #139308

 -- Oliver Elphick <olly@lfix.co.uk>  Thu, 21 Mar 2002 11:05:05 +0000

postgresql (7.2-6) unstable; urgency=low

  * Chasnged reference to 7.1 to 7.2 in README.Debian.
  * postgresql-dump checks it has write permission on /dev/tty.
  * postgresql: fresh install - added extra possibilities for default
    database encoding (LATIN6 to LATIN10, ISO-8859-5 to ISO-8859-8).
  * postgresql: added shared library dependencies.  Closes: #138872
  * postgresql: corrected trap syntax in postgresql-dump. Closes: #138896 

 -- Oliver Elphick <olly@lfix.co.uk>  Mon, 18 Mar 2002 13:00:51 +0000

postgresql (7.2-5) unstable; urgency=low

  * postgresql: enable_lang was checking for trust or peer local
    authentication.  Changed to trust and ident.  Closes: #136415
  * postgresql: some older postmasters opened a socket in /tmp rather than
    /var/run/postgresql.  postgresql-dump will now create a symbolic link from
    the socket in /tmp to /var/run/postgresql (and will delete it on exit) so
    as to ensure that postgresql-dump will actually be able to make a dump.
  * python-pygresql: added dependency on python2.1-egenix-mxdatetime.
    Closes: #131402
  * postgresql: postgresql-dump will now fail if there are still instances of
    'peer' authentication in pg_hba.conf or if it does not have full
    access (i.e. "local all trust").

 -- Oliver Elphick <olly@lfix.co.uk>  Thu,  7 Mar 2002 11:59:25 +0000

postgresql (7.2-4) unstable; urgency=low

  * postgresql: removed unnecessary check on the presence of libpgsql2 from the
    postinst script.  Closes: #136393, #136389
  * Added dependency libpgsql2 to postgresql-client, libpgtcl, libpgperl,
    python-pygresql, postgresql-contrib.

 -- Oliver Elphick <olly@lfix.co.uk>  Sat,  2 Mar 2002 06:33:45 +0000

postgresql (7.2-3) unstable; urgency=low

  * odbc-postgresql: add template files for odbcinst.ini and odbc.ini to
    /usr/lib/postgresql/lib.  Add some documentation about how to set up
    ODBC with unixodbc for access from StarOffice.
  * libpgtcl2: this renaming of packages was getting us nowhere.  Revert to
    original name (libpgsql2); conflict with and provide libpgsql2.1.

 -- Oliver Elphick <olly@lfix.co.uk>  Thu, 28 Feb 2002 10:47:16 +0000

postgresql (7.2-2) unstable; urgency=low

  * odbc-postgresql: weakened dependency on unixodbc to suggestion.
  * libpgsql2.2: remove (for now) the conflict with libpgsql2.1, so as to
    allow other packages to coexist even though they are linked with 2.1
  * postgresql: need to eval the pg_ctl startup line to pass the $OPTIONS
    through to pg_ctl correctly.  Closes: #135954

 -- Oliver Elphick <olly@lfix.co.uk>  Tue, 26 Feb 2002 22:32:31 +0000

postgresql (7.2-1) unstable; urgency=low

  * New upstream release
    - Hacked src/interfaces/perl5/GNUmakefile to force MakeMaker to put
      perl files in the right place.
    - contrib/rserv: specified /usr/bin/perl as executablein perl scripts.
  * Package libpgsql2.1 renamed to libpgsql2.2 to reflect change in the
    shared library number.  It replaces libpgsql2 and libpgsql2.1.
  * Packaging fixes from J.H.M. Dassen (Ray) <jdassen@debian.org>:
    - Install pgperl examples.
    - Put Pg.pm and associated files back in pgperl.
  * Reintroduced checking of pg_ctl command line parameters, and submitted the
    patch upstream.
  * postgresql: built with new PAM authentication option enabled, so that
    someone wanting to use PAM authentication may do so.
  * postgresql: modified pg_hba.conf-sample so that the default authentication
    method is now "ident" on a local connection (meaning checking UNIX socket
    ownerships).  (The "peer" authentication used in 7.1 has been adopted
    upstream but has been renamed "ident".)
  * postgresql: postinst will check for "peer" in pg_hba.conf and offer to
    convert it to "ident".  If this is not converted, the pg_hba.conf file
    will be invalid.
  * odbc-postgresql: applied patch from MichelMeskes <meskes@debian.org> to
    allow the PostgreSQL ODBC to work with unixodbc.
  * odbc-postgresql: make this depend on unixodbc, which is the driver
    manager.  odbcinst.ini is in turn provided by a package on which unixodbc
    depends.
  * postgresql: correct fix to preinst for bug #131900
  * Added unixodbc-dev as a build dependency.
  * postgresql: pg_dump fix to make it write out a line to connect to a
    database that will not fall over on mixed-case database or user names.
    (src/bin/pg_dump/pg_backup_archiver.c).
  * postgresql: tweaks to the database upgrade scripts in postinst and
    postgresql-dump
  * postgresql: postinst no longer attempts to record the automatic
    upgrade; it interfered with the pager's showing the contents of the
    dump, and I considered the latter to be more important.

 -- Oliver Elphick <olly@lfix.co.uk>  Sat, 23 Feb 2002 17:37:43 +0000

postgresql (7.1.3-8) unstable; urgency=low

  * postgresql: Added logcheck filters as conffiles.  Closes: #123935
  * postgresql: Tightened up checking of command line options in pg_ctl; it
    will now complain about missing option parameters. Closes: #132489
  * postgresql: postgresql-startup will not now supply the -l option to
    pg_ctl if no log file has been specified.
  * postgresql: postgresql-startup now uses default value for the log file
    if it is not explicitly defined.  Closes: #130544.
  * libpgtcl: added a symlink from /usr/lib to
    /usr/lib/postgresql/lib/libpgtcl.so
  * postgresql: preinst will no longer try to stop other postmasters than
    the official Debian one for the current environment.  This will avoid
    interference with chrooted environments and so on.  (Previously done by
    NMU to 7.1.3-7).  Closes: #129462
  * postgresql: preinst assigned a long message to a variable (so as to use it
    twice), but this caused it to lose its formatting.  Added extra quotes to
    cure the problem.  Closes: #131900
  * postgresql-doc: fix spelling in lo-interfaces.html. Closes: #131920 

 -- Oliver Elphick <olly@lfix.co.uk>  Sat,  2 Feb 2002 03:59:33 +0000

postgresql (7.1.3-7) unstable; urgency=low

  * postgresql: changed code for setting file-max in the kernel and moved it
    to postgresql.init (because postgresql-startup does not run as root).
  * postgresql: explicitly require /bin/bash in pg_ctl, because ash barfs on
    shift with no parameters (which I think is a bug in ash).
    Closes: #128300, #128849, #128462
  * postgresql: fixed passing of options to pg_ctl from postgresql-startup.
    Closes: #108563
  * postgresql: added a parameter POSTMASTER_OPTIONS to postmaster.conf, to
    enable extra options to be passed by pg_ctl to the postmaster.

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 16 Jan 2002 09:58:39 +0000

postgresql (7.1.3-6) unstable; urgency=low

  * postgresql: fix postgresql-dump so that it doesn't crash out
    unnecessarily if an unneeded file is missing. (Thanks to Thien-Thi
    Nguyen <ttn@giblet.glug.org>.)
  * Build dependencies: changed python-dev to python2.1-dev; added zlibg1-dev.
    Closes: #12166, #126193
  # Build: applied patch to fix other python build problems. Closes: #121666
  * postgresql-client: applied patch to allow a non-superuser in psql to
    delete a large object.  Closes: #121699
  * postgresql-contrib: add man page for pgbench (contributed by
    Anthony DeRobertis <asd@suespammers.org>.  Closes: #121712
  * postgresql: applied patch for policy compliance in /etc/init.d/postgresql.
    Closes: #121944
  * postgresql: fixed inconsistent documentation in postgresql-startup.
    Closes: #122167
  * postgresql: changed scripts containing POSTGRESHOME to use POSTGRES_HOME.
    Closes: #122871
  * postgresql: adduser dependency is now versioned (>= 3.34) to ensure that
    the --shell argument is recognised.  Closes: #123349
  * libpq2.1: modified the README.Debian text.  Closes: #123950
  * postgresql: corrected documentation file reference in
    /etc/postgresql/postgresql.conf.  Closes: #124317
  * postgresql-client: added select call to pg_wrapper to avoid a race
    condition on SMP systems.  Closes: #125772
  * postgresql: fixed spelling mistake in
    /usr/share/doc/postgresql/README.Debian.gz.  Closes: #126440
  * postgresql: declared signed char c in
        src/backend/libpq/hba.c           line 1039
	src/backend/utils/init/miscinit.c line 263
    This is to cope with char defaulting to unsigned on several architectures.
    Closes: #127004
  * postgressql: postgresql-startup no longer echoes the pg_ctl command (to
    avoid unneeded verbosity).  Closes: #127275

 -- Oliver Elphick <olly@lfix.co.uk>  Fri,  7 Dec 2001 01:59:20 +0000

postgresql (7.1.3-5) unstable; urgency=high

  * Removed an unnecessary config option from the ./configure command
    in debian/rules.  Closes: #111245
  * postgresql: delete /var/lib/postgres/automatic_update.log on
    purge.  Closes: #111925
  * postgresql-client: pg_wrapper front-end wrapper now correctly reads
    postgresql.env; patch from Andreas Degert <ad@papyrus-gmbh.de>.
    Closes: #112003.
  * postgresql-contrib: removed references to mSQL-interface, which has
    not been included in the build since 7.1rc-4.  Closes: #112278
  * postgresql, libpgsql2.1: increased the space allocated for the
    username in peer authentication.  This was L_cuserid, which seems
    to default to 8; increased it to 32 which is the maximum allowed
    by the "name" type in PostgreSQL.  Closes: #112372
  * Fixed some lintian errors: conffiles not being generated for
    postgresql-client and odbc-postgresql; libpgsql2.1 listed twice in
    several dependencies.
  * debian/rules now installs conffiles in odbc-postgresql/DEBIAN and
    postgresql-client/DEBIAN; this should have been done by dh_installdeb
    but perhaps there is a bug in it...
  * postgresql: minor editing to README.Debian.migration for spelling
    etc.
  * Added MK_NO_LORDER=true to src/makefiles/Makefile.linux to avoid a
    problem with strip on some systems.  Thanks to Jade Nicoletti
    <nicoletti@nns.ch>.
  * pygresql: changed dependencies for new python policy.
  * postgresql: postinst - now chmods read and write permissions for
    postgres, which may help to deal with permissions errors in dumping
    the previous version's data.

 -- Oliver Elphick <olly@lfix.co.uk>  Sun, 25 Nov 2001 20:23:41 +0000

postgresql (7.1.3-4) unstable; urgency=high

  * postgresql: added a very brief explanation of creating PostgreSQL
    users to README.Debian.  Closes: #88345
  * postgresql: now suggests pgmonitor
  * odbc-postgresql: removed unnecessary dependency on postgresql.

 -- Oliver Elphick <olly@lfix.co.uk>  Tue,  4 Sep 2001 11:50:43 +0100

postgresql (7.1.3-3) unstable; urgency=low

  * postgresql: modified the description of SYSLOG_FACILITY in the
    documentation file, README.postgresql.conf.
  * postgresql: provided a manpage for postgresql.conf. Closes: #105314
  * postgresql: added conflicts with older binary packages, to ensure
    that packages get updated together.
  * postgresql: stripped obsolete code from prerm.  This used to save a
    schema dump for use by pg_upgrade in the postinst of the next
    release, but pg_upgrade no longer works.  Incidentally, there was
    a problem with geting access to the database; this is avoided by
    not going through this obsolete code.  Closes: #109921.
  * postgresql: improved the test for unrestricted access in enable_lang. 

 -- Oliver Elphick <olly@lfix.co.uk>  Sat, 25 Aug 2001 07:32:22 +0100

postgresql (7.1.3-2) unstable; urgency=low

  * postgresql: fixed script error in prerm that gave spurious failure
    and prevented removal.

 -- Oliver Elphick <olly@lfix.co.uk>  Mon, 20 Aug 2001 09:48:07 +0100

postgresql (7.1.3-1) unstable; urgency=high

  * New upstream bugfix release 
  * Marked high urgency because we still have bug-ridden 7.1release-4
    in testing.

 -- Oliver Elphick <olly@lfix.co.uk>  Sat, 18 Aug 2001 10:36:51 +0100

postgresql (7.1.2-5) unstable; urgency=low

  * Suggest pgdocs package for printable documentation.
  * enable_lang will now exit if it does not have unrestricted access.
    Closes: #108617
  * postgresql: prerm needs to read postgresql.env at the very start,
    before running pg_ctl.  Closes: #108622 

 -- Oliver Elphick <olly@lfix.co.uk>  Mon, 13 Aug 2001 21:52:07 +0100

postgresql (7.1.2-4) unstable; urgency=low

  * libpgsql2.1, postgresql, poostgresql-client: preinst calls ls in
    circumstances where it may find no files.  Send the resultant error
    message to /dev/null.  Closes: #108508
  * postgresql: nos suggests ident-server.  Closes: #101608
  * postgresql: changed createdb -help to createdb --help in pg_dumpall
    script used for upgrading.  Closes: #103115
  * postgresql-client: set PAGER to /usr/bin/pager if it is unset.
    Closes: #106654
  * postgresql: added dependency on adduser, which is neded to create
    the postgres user.  Closes: #102704
  * scripts: use getent instead of "grep {passwd,group}".  Closes: #103910 

 -- Oliver Elphick <olly@lfix.co.uk>  Mon, 13 Aug 2001 00:09:30 +0100

postgresql (7.1.2-3) unstable; urgency=low

  * postgresql: changed chown to chmod in postinst.
  * postgresql: ensured that /var/lib/postgres/dumpall and its contents
    are all owned by postgres.postgres so that postgresql-dump can
    function as postgres without ownership problems.  This was
    being done in the wrong place before.  Closes: #108232
  * pgaccess: applied suggested upstream fix to lib/preferences.tcl to
    change default fonts to iso8859 to avoid character display problems.
    The script for making the change is in debian/pgaccess.fonts and the
	 unchanged preferences.tcl is in
    /usr/lib/postgresql/share/pgaccess/lib/preferences.tcl-orig.
    Closes: #77897
  * Provide the pgaccess upstream documentation in /usr/share/doc/pgaccess.

 -- Oliver Elphick <olly@lfix.co.uk>  Fri, 10 Aug 2001 13:58:43 +0100

postgresql (7.1.2-2) unstable; urgency=low

  * Apply patch from Tom Lane (upstream developer) to protect view
    permissions in pg_dump.
  * pgaccess: In main.tcl, change the default host to an empty string, so
    as to force the use of UNIX socket connection rather than TCP/IP as
	 the default option.
  * postgresql: add the -v option to postgresql-dump when run from
    postinst, to give more information in the case of failure.
  * Change top-level doc Makefile to separate installation of html
    documentation from program installation, so as to avoid installing
    duplicate html docs in 2 packages.  Also remove whole hierarchy of
    /usr/lib/postgresql/doc.  Closes: #99310
  * Rewrote README.Debian.migration to help users cope with problems
    of database upgrading.
  * Explicitly set the permissions of temporary files in case of
    problems when suing to another username.  Closes: #101036
  * Disable peer authorisation for the Hurd, which does not support
    credentials on Unix sockets; avoid depending on the definition
    of NOFILE; for Hurd, don't depend on procps.  Closes: #100342
  * Made additional effort to ensure that postmaster.conf exists, even
    if it ends up completely empty.  Closes: #101175.
  * Apply upstream patch to correct errors in pg_dump with comments on
    views.
  * postgresql: prerm - added a delay after ordering postmaster shutdown
    because it was previously trying to start up again too soon.  Also
    added an option to force immediate shutdown if shutdown has not
    occurred after 5 seconds.
  * postgresql: add pg_config to the list of "user" programs to go in
    /usr/bin.  Closes: #108118
  * postgresql: fixed spelling error.  Closes: #101610 

 -- Oliver Elphick <olly@lfix.co.uk>  Thu,  9 Aug 2001 07:19:04 +0100

postgresql (7.1.2-1.1) unstable; urgency=medium

  * Non-maintainer upload.
  * debian/pgaccess.tcl: remove erroneous "`", closes: #100091, #101429.
  * debian/control: add dependency on libssl-dev for postgresql-dev,
    closes: #100048, #101987, #100069, #101507.

 -- James Troup <james@nocrew.org>  Sun, 22 Jul 2001 23:09:03 +0100

postgresql (7.1.2-1) unstable; urgency=low

  * New upstream bugfixing release.
  * postgresql: correct misplaced line in postinst. Closes: #99666

 -- Oliver Elphick <olly@lfix.co.uk>  Mon,  4 Jun 2001 04:56:08 +0100

postgresql (7.1.1-5) unstable; urgency=low

  * postgresql: make sure the old ~postgres login profile is edited if
    the configuration files are transferred from old format to new;
    there were still references to postmaster.init left behind.
    Closes: #97550
  * postgresql: do not specify `initdb --sysid=31' in the postinst.
    This used to make sense when the O/S uid was hardcoded, but now
    that the O/S user is no longer 31, it is triggering an upstream
    bug that leaves half the created items owned by a non-existent
    user.

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 23 May 2001 23:06:53 +0100

postgresql (7.1.1-4) unstable; urgency=low

  * postgresql: specify #!/bin/bash for the maintainer scripts.
	 Closes: #97539
  * pgaccess: check that essential environment variables are set and
    set them if they are not.  Closes: #97547
  * postgresql: further problems with the automatic upgrade because
    pg_options is deleted by the postinst, but its symbolic link
    was not.  Also, it was possible for the dump target file to be
    read-only, which also caused failure.
  * postgresql: removed spurious debconf dependency; I don't know how
    it got there.  Use of debconf is desirable but not even started
    yet.
  * Moved pg_restore from postgresql to postgresql-client and
    made a link to pg_wrapper for it.  Closes: #97934
  * postgresql-client: fixed problem with `psql -V' which tried to write
    to an uninitialised pointer and segfaulted. Closes: #98028
  * postgresql-client: `psql -l' no longer needs to have a database
    specified.
  * postgresql: if the preinst needs to create the postgres user, it
    now specifies /bin/bash as a shell; adduser's default is /bin/false,
    which was causing installation to abort.  Closes: #98049
  * postgresql: modified the call to postgresql-dump to force a user
    check of the dump before destroying the database.
  * postgresql: enclosed potentially unassigned variables in quotes to
    avoid problems with test.  Closes: #98376

 -- Oliver Elphick <olly@lfix.co.uk>  Tue, 22 May 2001 15:19:34 +0100

postgresql (7.1.1-3) unstable; urgency=low

  * postgresql-client: psql -V does not now need a database specified.
  * postgresql: yet another scripting error in postinst - make sure that
    the trap command does not begin with ';'.
  * Revised Conflicts and Replaces dependencies in debian/control ;
    closes: #97361
  * postgresql: installed the upstream HISTORY as /usr/share/doc/changelog.
  * postgresql: removed -X option from postinst call to postgresql-dump.
    This forces a new dump of the database to circumvent the schema-only
    dump done by the prerm of earlier releases to facilitate pg_upgrade.
    (pg_upgrade is not available in 7.1.).  Closes: #96782
  * postgresql: fixed unsafe creation of temporary file in initdb.
    closes: #97256

 -- Oliver Elphick <olly@lfix.co.uk>  Mon, 14 May 2001 18:12:40 +0100

postgresql (7.1.1-2) unstable; urgency=low

  * postgresql: Scripting error in postinst fix to #96782; the new argument
    to trap needed to be in quotes.
  * postgresql: in prerm, move a quote so that a temporary file is read
    by root rather than by postgres user. Closes: #96915
  * postgresql: enable "ident sameuser" access for localhost in the
    default pg_hba.conf.
  * postgresql: postinst has a 'set +e' which was not being cancelled
    when no longer needed.  Introduced a check for the existence of
    psql before trying to enable PL in databases. Closes: #96922
  * Changes to perl module building from a patch supplied by
    Brendan O'Dea" <bod@compusol.com.au>:
    + Pass an argument of INSTALLDIRS=vendor to the invocation of
      Makefile.PL to cause the Makefile to be written with the correct
      paths for modules, manpages and programs for a Debian package.
    + Pass an argument of PREFIX=$(CURDIR)/debian/tmp to make.  All the
      paths set up in the previous step use $(PREFIX) in place of /usr, so
      overriding this on the make command line causes the installation to
      your build tree.
    This has involved rewriting the upstream Makefile in src/interfaces/perl5
	 and removing all the perl tweaks from debian/rules.  Closes: #95517
  * Similar change to building of src/pl/plperl.
  * postgresql-client: postgresql.env now reads postmaster.conf only if
    postmaster.conf exists; this is because postmaster.conf is in postgresql
    which need not be installed.  Closes: #95676 #96926
  * Do not bother to save old binaries if postmaster.conf is not present or
    $PGDATA/base is not a directory; these indicate that postgresql is not
    installed, so there is no database to save.
  * Review postgresql-dump and remove some obsolete stuff (reading variables
    that were set in postmaster.init but are not in postmaster.conf).

 -- Oliver Elphick <olly@lfix.co.uk>  Thu, 10 May 2001 14:59:56 +0100

postgresql (7.1.1-1) unstable; urgency=high

  * New upstream bugfixing release.
  * postgresql: a trap to restore pg_hba.conf after its being changed to
    allow postgresql-dump to work was being executed too soon (on exit
	 from a sub-shell), thus causing automatic data upgrading to fail
	 unless local access policy was already "local all trust".  The trap
	 was instead merged with any already existing, to take effect at the
	 end of postinst.  Closes: #96782
  * postgresql-doc: installed pre-built man pages and HTML documentation
    rather than building it; removed the corresponding build dependencies.
	 This saves much time, avoids the complexities of SGML and docbook, and
	 closes: #96799

 -- Oliver Elphick <olly@lfix.co.uk>  Tue,  8 May 2001 23:45:54 +0100

postgresql (7.1release-4) unstable; urgency=low

  * libpgsql2.1: Fixed shlibs file, because the SONAME of the libraries
    excludes the minor number.  Closes: #96460
  * libecpg3, libpgtcl, odbc-postgresql: similar changes to shlibs. 

 -- Oliver Elphick <olly@lfix.co.uk>  Sun,  6 May 2001 05:43:02 +0100

postgresql (7.1release-3) unstable; urgency=low

  * libpgtcl, libpgperl: now conflict with obsolete package postgresql-pl;
    Closes: #95271
  * postgresql: conflict with obsolete postgresql-test
  * Applied a documentation patch to document the -s option of pg_ctl.
  * Use full path of /etc/postgresql/postmaster.init when reading it in
    to transfer its options to the new configuration files.
    Closes: #95542
  * Use [ -d /usr/lib/locale ] (rather than -f) when checking for the
    presence of locales.
  * Applied a better patch for fixing the readline 4.2 problem.
  * Use 'env -' instead of 'exec -c' in pg_wrapper to avoid unnecessary
    bashism.  Closes: #95578
  * postgresql: if the postgres user and group do not exist, they are now
    created in the system range rather than in the 0-99 range.  There
    will be a concomitant change to base-passwd to remove postgres from
    the mandatory list of users.
  * Moved /etc/postgresql/postgresql.env from postgresql to postgresql-client;
    closes: #95676
  * Added pg_dumpall7.1 to /usr/lib/postgresql/dumpall for dumping version
    7.1 databases and later.  Modified postgresql-dump to use the correct
    pg_dumpall script.
  * Changed text of README.Debian.migration to associate 7.1 with
    Debian 2.3.  Closes: #95811
  * postgreql-dump does not now unset destroy if the target file exists.
    Closes: #95466
  * Remove the dependency on (pident | ident-server) from libpgsql2.1
    and postgresql-client and instead provide a new authentication method
    "peer" that acts like ident but uses a Unix socket.  Closes: #95818
  * Made "peer sameuser" the default access policy instead of "ident sameuser".
    This enables me to remove the dependency on ident-server, which was
	 objected to by some people on security grounds.
  * pgaccess: pgaccess script now uses 'which' rather than 'type -p' (which
    is a bashism) to find the path of wish.  Closes: #96018
  * Moved package into non-us, because of the links to crypto code.
    Closes: #95146
  * Applied patch to set LD_LIBRARY_PATH in postgresql-dump.  Closes: #96068

 -- Oliver Elphick <olly@lfix.co.uk>  Wed,  2 May 2001 16:01:06 +0100

postgresql (7.1release-2) unstable; urgency=low

  * postgresql: made pg_wrapper accept long command line options on behalf of
    psql.  Closes: 95060
  * Removed from /etc/postgresql/postgresql.env a wrong recommendation to
    source that file in  /etc/environment.
  * postgresql: Changed bad filename postmaster.env to postmaster.conf in
    postinst.  Closes: 95156
  * postgresql: removed "set -x" from postinst and forced removal of a
    temporary file. Closes: 95157
  * postgresql: In a new installation, do not try to read LANG from pg_control
    because it won't exist. Closes: 95164
  * Changed build-depends on libssl096-dev to libssl-dev. Closes: 95174
  * Added build-dependencies: jade, jadetex, sp, sgmlspl and docbook2man for the
    documentation building.  Closes: 95177
  * postgresql-contrib: Removed spurious directory
    /usr/share/doc/postgresql-contribusr. Closes: 95191
  * postgresql: Removed unnecessary prompts from preinst and postinst.
    Closes: 95212
  * postgresql: Fixed bug in prerm - was not correctly extracting the default
    encoding from the existing database.
  * postgresql: fixed bug in enable.lang script (run from postinst).
    closes: 95239

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 25 Apr 2001 21:13:16 +0100

postgresql (7.1release-1) unstable; urgency=low

  * Upstream final release of 7.1.  Because of the illogical numbering
    scheme used upstream, this release is named 7.1release in Debian.
  * Incorporated patch to enable use in conjunction with pgmonitor.
  * Changed filename_completion_function to rl_filename_completion_function
    in tab-complete.c, because the function name has changed in libreadline
    4.2.  Versioned build dependency on libreadline-dev (>= 4.2).
  * postgresql-client: psql (pg_wrapper) now requires a database to be
    specified on the command line or in the environment variable PGDATABASE
    The previous behaviour (defaulting to template1) has led to tables' being
    created in the wrong database and unexpectedly copied to every database
    created subsequently.
  * postgresql: corrections to postinst script.
  * postgresql: startup scripts altered to use pg_ctl to start and to remove
    features that no longer need to be set by command line.  The PGECHO and
    PGSTATS options have also been removed, because they are only used
    when starting a stand-alone backend.
  * Bugfixes in 7.1 and its prereleases: many bugs have gone awy through
    upstream fixes or because the packaging has changed substantially or
    are unreproducible; closes: 64666 91346 90359 90428 72023 72084 72577 82016 87842 47596 50708 55325 55479 58689 59153 60303 61312 61720 62164 62833 63258 63661 64166 64455 64963 65026 65074 65079 65122 65163 65338 65650 65758 65894 66233 66647 66764 66914 66966 67365 67436 67871 68648 70427 72229 72245 72249 72255 72790 74050 75545 76050 76057 77354 78109 78319 79247 79341 79715 79756 80723 82219 82267 83949 87274 88760 90874 92705 93261 93529 94152 94340 93471 61850 62850 67754 75741 49580 81292
  * Removed the postgresql-test binary package.  In 7.1, the test environment
    is so completely tied into the source build that I have been unable to
    disentangle it.  If you want to run the tests, download the source and
    build it yourself. Closes: 64716 77369

 -- Oliver Elphick <olly@lfix.co.uk>  Mon, 23 Apr 2001 11:39:22 +0100

postgresql (7.1rc4-2) experimental; urgency=low

  * postgresql-dev: include directory was in wrong place; moved to
    /usr/include/postgresql
  * postgresql, postgresql-dev: some include files were in the wrong package;
    moved to postgresql-dev

 -- Oliver Elphick <olly@lfix.co.uk>  Thu, 12 Apr 2001 12:16:37 +0100

postgresql (7.1rc4-1) experimental; urgency=low

  * New upstream release candidate
  * postgresql-contrib: Removed mSQL-interface from the list of modules to
    build (because it needs a proprietary header file).
  * libpgtcl: libpgtcl library was being installed in /usr/lib rather than
    in /usr/lib/postgresql/lib
  * postgresql-contrib: fixed some install errors in newer modules
  * libpgsql2.1: added dependency on ident-server
  * postgresql: do.maintenance now checks can_i_run
  * postgresql-dev, libecpg3: moved libecpg.so.3* from postgresql-dev to
    a separate library package.
  * postgresql, postgresql-contrib: moved pg_controldata, pg_resetxlog and
    the associated documentation into postgresql.
  * Put the Unix socket back in /var/run/postgresql (as for 7.0.3)

 -- Oliver Elphick <olly@lfix.co.uk>  Tue, 10 Apr 2001 20:56:08 +0100

postgresql (7.1cRC3-1) experimental; urgency=low

  * New upstream release candidate.
  * Fixed errors in enable_lang script.
  * Changed localhost in pg_hba.conf to 127.0.0.1

 -- Oliver Elphick <olly@lfix.co.uk>  Sat,  7 Apr 2001 10:31:03 +0100

postgresql (7.1cRC2-1) experimental; urgency=low

  * Upstream release candidate for 7.1.  The rename (from upstream RCx to
    cRCx) is so that it will supersede 7.1betax in dpkg.
  * Added full stop after init messages per policy. (Bug #91346)
  * Changed the default security policy:  UNIX socket access is now password-
    protected.  Access via TCP/IP from localhost is given only to PostgreSQL
    users with the same name as the Unix login.  Access from other hosts is
    denied.
  * Consequent change to do.maintenance: PGHOST is set to localhost; a new -l
    option is provided to force use of UNIX sockets.
  * Consequent change to /etc/cron.d/postgresql to set PGHOST=localhost.
  * Consequent change to pg_dumpall to warn user to set PGHOST if there is no
    direct access method for local or localhost in pg_hba.conf.
  * Initialisation scripts now make temporary changes to pg_hba.conf to
    ensure that they have full access.
  * Fixed error in debian/rules that was deleting all include files that should
    have gone into postgresql-dev.
  * Fixed some missing dependencies in debian/control.
  * All provided languages are now installed by postinst.  enable-plpgsql is
    renamed enable-lang and will install any available language.
  * Merged the ecpg binary package with postgresql-dev. 

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 28 Mar 2001 22:31:38 +0100

postgresql (7.1beta5-1) experimental; urgency=low

  * New upstream beta
  * postgresql: do not transfer -F (nofsync) option from the old
    configuration files; WAL makes it unnecessary to use this option now,
    and there is a risk of data loss in the case of a crash.
  * added --disable-rpath to the configure command in debian/rules
  * postgresql: minor alteration to do.maintenance for use with passwords.
  * postgresql: fixed odbc installation files
  * odbc-postgresql: restored this binary package 

 -- Oliver Elphick <olly@lfix.co.uk>  Thu,  1 Mar 2001 21:01:10 +0000

postgresql (7.1beta4-3) experimental; urgency=low

  * makelang-pl.sql was not being made correctly
  * Re moved further references to postmaster.init from preinst.
  * Build-depends on libssl096
  * postgresql-dev: Restored missing include files
  * postgresql: Changed do.maintenance so as not to attempt to connect
    to template0

 -- Oliver Elphick <olly@lfix.co.uk>  Wed, 28 Feb 2001 11:55:32 +0000

postgresql (7.1beta4-2) unstable; urgency=low

  * Fixed numerous references to postmaster.init in postinst; change then
    to postmaster.conf.

 -- Oliver Elphick <olly@lfix.co.uk>  Mon,  5 Feb 2001 22:41:15 +0000

postgresql (7.1beta4-1) unstable; urgency=low

  * New upstream beta

 -- Oliver Elphick <olly@lfix.co.uk>  Mon,  5 Feb 2001 22:41:03 +0000

postgresql (7.1beta3-1) unstable; urgency=low

  * New upstream beta version
  * Many changes to the Debian package - notably the removal of
    postgresql-pl and the distribution of its contents among
    postgresql, libpgtcl and libpgperl.

 -- Oliver Elphick <olly@lfix.co.uk>  Fri, 26 Jan 2001 20:27:30 +0000