[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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: