Keith wrote:

Sounds like apt thinks that postgresql is already installed at the latest release. You could try;

1. doing and uninstall followed by an installl (but I'm a bit

wary of that as uninstall can also clobber other packes you don't want uninstalled)

2. try reconfiguring the package with dpkg --configure

[package name] - check the syntax of that via the man page

3. I think there's an apt-get option that will force a

re-install of an existing package, again check the apt-get man page.

Keith ____________

Yes, the full story is that I had postgresql v7.2 installed, and when I upgraded to testing from stable postgresql attempted to upgrade to v7.4. Halfway through the upgrade it failed becuase it couldn't upgrade the data from 7.2 to the latest format. I apt-get removed postgresql and ripped out the existing data directory. Now it keeps giving this error when i try to install, as in your option (1). I get the same error with option (2). Re. option (3) - I've just done and apt-get clean, an apt-get check and tried using the f to force option, but with the same error.

Any option (4) suggestions? :-))

I shudder to think what would have happened if this was my live box and not the playpen. Thanks, Jen

______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________