On Wed, 2003-10-29 at 11:24, Andrew Perrin wrote: > 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 ..
So where's your latest pg_dumpall dump file? -- ----------------------------------------------------------------- Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA "Perl is worse than Python because people wanted it worse." Larry Wall, 10/14/1998 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
