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

Re: dist-upgrade deletes postgresql data!



Never mind -- somehow I got the directory wrong; it was in
/data0/postgres.

ap

----------------------------------------------------------------------
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


On Wed, 29 Oct 2003, 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 ..
>
>
>
>
> 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
>
>
> --
> To UNSUBSCRIBE, email to debian-user-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>
>



Reply to: