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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 . Closes: #209742 * python2.x: add proper library path for -lpq to setup.py. Closes: #209247 -- Oliver Elphick 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 ), 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 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 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 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 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 : 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 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 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 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 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 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 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 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 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 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 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 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) : - 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 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 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 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 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 .) * 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 . 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 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 . 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 . * 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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" : + 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 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 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 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 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 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 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 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 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 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 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 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 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 Mon, 5 Feb 2001 22:41:15 +0000 postgresql (7.1beta4-1) unstable; urgency=low * New upstream beta -- Oliver Elphick 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 Fri, 26 Jan 2001 20:27:30 +0000