On Friday 11 August 2006 00:05, you wrote: > Ah, it might explain a bit more now. Did you actually see the > 'Unclean transition' debconf note? Judging from the output you > shouldn't have at that attempt, but at some point in the past.
Errr, yeah, I might have. The actual upgrade I did a few months back... I was getting deluged by spam, and needed desperately a Spamassassin upgrade, which depended on Pg 8.x, and at the same time, I had just gotten a new dual-CPU box. So I just grabbed the HD from my older server, that were running sarge, put a few new ones in the new box, stuffed this into an older box that I was given that I wanted to make a pure spamd server, and massaged Pg 8.1 in as fast as I could... > Can you please give me the output of > > dpkg -s postgresql > > ? [EMAIL PROTECTED]:~> dpkg -s postgresql Package: postgresql Status: deinstall ok config-files Priority: optional Section: misc Installed-Size: 9580 Maintainer: Martin Pitt <[EMAIL PROTECTED]> Architecture: i386 Version: 7.4.7-6sarge1 Config-Version: 7.4.7-6sarge1 Replaces: postgresql-pl, libpgtcl (<< 7.3rel-5), libpgperl (<< 1:2.0.1-1) Depends: libc6 (>= 2.3.2.ds1-21), libcomerr2 (>= 1.33-3), libkrb53 (>= 1.3.2), libpam0g (>= 0.76), libperl5.8 (>= 5.8.4), libreadline4 (>= 4.3-1), libssl0.9.7, python2.3 (>= 2.3), zlib1g (>= 1:1.2.1), debconf (>= 0.5) | debconf-2.0, dpkg (>= 1.10.3), procps, debianutils (>= 1.13.1), postgresql-client (>= 7.4), libpq3 (>= 7.4), mailx, ucf (>= 0.28) Pre-Depends: adduser (>= 3.34) Suggests: libpg-perl, libpgjava, libpgtcl, postgresql-doc, postgresql-dev, postgresql-contrib, pidentd | ident-server, pgdocs, pgaccess Conflicts: postgres95, libpq1, postgresql-pl, postgresql-test, postgresql-contrib (<< 7.2), ecpg (<< 7.2), libpgtcl (<< 7.3rel-5), libpgperl (<< 1:2.0.1-1), postgresql-client (<< 7.4.6-5) Conffiles: /etc/cron.d/postgresql 361b4b47a5ec640fd90e5f32b2b9e7d8 /etc/init.d/postgresql 2b4cca6a806c550a2c0e4faa342d3a6f /etc/logrotate.d/postgresql 8822ce30bcea0aad31febb60793fe7bc /etc/logcheck/ignore.d.server/postgresql 3baad38bef168f2e265fdbb10ef96039 /etc/logcheck/violations.ignore.d/logcheck-postgresql 56140ea2fefe72cc34b461267f8dc975 /etc/logcheck/ignore.d.paranoid/postgresql 3baad38bef168f2e265fdbb10ef96039 /etc/logcheck/ignore.d.workstation/postgresql 3baad38bef168f2e265fdbb10ef96039 /etc/postgresql/pg_ident.conf 13315f01db0ad8a8638326b9f035c896 /etc/postgresql/pg_hba.conf 2ec14365922bdbe4add9b83e342bd402 Description: object-relational SQL database management system [...] > If it still has config files installed, then this installation > breakage is supposed to stop you from uninstalling (but not purging) > the Sarge postgresql packages and then installing postgresql-8.1, > instead of doing a proper dist-upgrade (which will pull in the > transitional postgresql 7.5.21 package, which will move things around > and clean up). Aha, I don't quite remember what I did, but since the only db I needed to preserve was the SA db, and sa-learn has a clean upgrade path for that, I might have deleted stuff by hand too... But you can probably draw your conclusions from what you see here :-) > > It seems I should always display the debconf note instead of just > once, to reduce this kind of confusion. Yeah, perhaps... :-) Cheers, Kjetil -- Kjetil Kjernsmo Programmer / Astrophysicist / Ski-orienteer / Orienteer / Mountaineer [EMAIL PROTECTED] Homepage: http://www.kjetil.kjernsmo.net/ OpenPGP KeyID: 6A6A0BBC