Package: postgresql-8.3 Version: 8.3.5-1 Severity: normal
Upgrading server from Etch to Lenny (before release of lenny). The Postgres upgrade from 7.4 to 8.3 was well handled and excellently documented (good work by packagers and Postgres developers). However on my system on running "pg_upgradecluster 7.4 main" failed because Postgres was in use by an Apache fastcgi script. In the end I "kill -9" the remaining Postgres 7.4 processes, and found that postgres 8.3 cluster was correctly configured when I started it manually. I would file this as minor, but it is more than cosmetic, but shouldn't be a problem for most users. Last bit of output from "pg_upgradecluster" Stopping target cluster... Stopping old cluster... pg_ctl: postmaster does not shut down Disabling automatic startup of old cluster... Configuring old cluster to use a different port (5433)... Starting target cluster on the original port... Error: Port conflict: cluster 7.4/main is already running on port 5432 Error: Could not start target cluster; please check configuration and log files Probably obvious to more experienced Postgres admins. Should the documentation recommend disabling all clients, or should the script check and be more aggressive closing down the database? In this case I should have disabled all the clients manually before the update to avoid loss of data (but it was only a test server). Either way I'm very impressed, I've had far more difficult upgrades of very expensive proprietary databases. -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.18-6-686 (SMP w/2 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages postgresql-8.3 depends on: ii libc6 2.7-16 GNU C Library: Shared libraries ii libcomerr2 1.41.3-1 common error description library ii libkrb53 1.6.dfsg.4~beta1-4 MIT Kerberos runtime libraries ii libldap-2.4-2 2.4.11-1 OpenLDAP libraries ii libpam0g 1.0.1-4 Pluggable Authentication Modules l ii libpq5 8.3.5-1 PostgreSQL C client library ii libssl0.9.8 0.9.8g-14 SSL shared libraries ii libxml2 2.6.32.dfsg-5 GNOME XML library ii locales 2.7-16 GNU C Library: National Language ( ii postgresql-client-8.3 8.3.5-1 front-end programs for PostgreSQL ii postgresql-common 94 PostgreSQL database-cluster manage ii ssl-cert 1.0.23 simple debconf wrapper for OpenSSL ii tzdata 2008h-2 time zone and daylight-saving time postgresql-8.3 recommends no packages. Versions of packages postgresql-8.3 suggests: ii pidentd [ident-server] 3.0.19.ds1-4 TCP/IP IDENT protocol server with -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org