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

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: