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