Re: dist-upgrade deletes postgresql data!
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:
>
> 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 ..
So where's your latest pg_dumpall dump file?
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA
"Perl is worse than Python because people wanted it worse."
Larry Wall, 10/14/1998
Reply to: