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:
[EMAIL PROTECTED]:~$ 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 [EMAIL PROTECTED] * andrew_perrin (at) unc.edu -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
