Re: Postgres removing old database
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 Oliver.Elphick@lfix.co.uk
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