Hi Jeff! Jeff Williams [2005-06-20 15:00 +0200]: > I can't still see the output as I did the upgrade on Saturday after > being away for two weeks. But thinking back, I remember that the upgrade > of postgresql failed. But I'm pretty sure it gave the message: > > "Not migrating invalid PostgreSQL data directory /usr/lib/postgres/data > (no PG_VERSION)."
That's understandable, I assume that your data directory is actually /var/lib/postgres/data. Did you manually change this at some time? Do you still happen to have the original /etc/postgresql/postmaster.conf file? (maybe with a .dpkg-old suffix)? Does it configure /usr/lib/postgres/data as data directory? This seriously worries me, the data directory is read from postmaster.conf, and if that fails, it falls back to the default /var/lib/postgres/data. > >Actually the package installation is supposed to fail if the file > >cannot be installed, and leave the original file where it is. I'll try > >to reproduce this condition and introduce additional checks. I did various tests, the package installation indeed fails if the installation is running out of space. But the actual reason was your wrong data path, so I assume that was just a side effect. > I just copied /usr/share/postgresql/7.4/postgresql.conf.sample to > /etc/postgresql/7.4/main/postgresql.conf which I assume does more or > less the same thing. Not exactly, since initdb and pg_createcluster do some tweaking, but if it works for you, that's fine. > Sorry about being so vauge, but everything seemed to work after the > second "apt-get upgrade" on Saturday so I didn't take much notice at the > time. Are you really sure that it works? I. e. did the upgrade eventually migrate your cluster in /var/lib/postgres/data? Can you please check with pg_lsclusters and psql -l and confirm to me? Thanks, Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org
signature.asc
Description: Digital signature
