dist-upgrade deletes postgresql data!
I did a dist-upgrade yesterday in order to move to sarge, which I needed
for various reasons. Part of the upgrade included a postgresql upgrade,
which was fine; the dialog asked if I wanted to save backups, I said yes,
and put them in /data0/backups/postgres. Now none of my databases are
there:
aperrin@perrin:~$ psql auth
psql: FATAL: Database "auth" does not exist in the system catalog.
and nothing's in the backup location:
perrin:/var/log/postgresql# ls -la /data0/backups/postgres/
total 12
drwxrwxrwx 3 root root 4096 Oct 28 10:46 .
drwxrwxrwx 9 root root 4096 Oct 28 10:45 ..
drwxrwxrwx 2 root root 4096 Oct 28 10:46 preserve
perrin:/var/log/postgresql# ls -la /data0/backups/postgres/preserve/
total 8
drwxrwxrwx 2 root root 4096 Oct 28 10:46 .
drwxrwxrwx 3 root root 4096 Oct 28 10:46 ..
HELP! Can anyone shed light on what's happened?
Thanks.
----------------------------------------------------------------------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
clists@perrin.socsci.unc.edu * andrew_perrin (at) unc.edu
Reply to: