Tomas Berndtsson wrote: >Recently, I upgraded from Postgres 6.5.3 (stable Debian) to Postgres >7.0 (unstable). During the installation, it didn't ask me anything, >besides overwriting the config files. Instead it gladly removed all my >databases which were in /var/lib/postgres/data/base/. The only known case when the database gets removed is in a purge, and then only if you say yes when asked.
>Luckily, I had made a dump myself, prior to the upgrade, so there was >no problem getting them back, but it would've been a good idea to have >it dump and restore the databases itself. I can remember an older >upgrade of postgres (6.0 -> 6.5 perhaps?) doing just this, so I wonder >why this didn't. It should have done; I can't think why it didn't. If you can repeat the operation and capture the whole session with script, I might be able to see what happened. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "For what shall it profit a man, if he shall gain the whole world, and lose his own soul?" Mark 8:36