Database lost after reboot

From: Diego Manilla Suárez <diego(dot)manilla(at)xeridia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Database lost after reboot
Date: 2006-04-06 17:14:50
Message-ID: 44354C8A.1080907@xeridia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. I have PostgreSQL 7.4.8 installed on a SuSE Enterprise Server 9.
When I create a database, everything works fine until I restart the
computer. When I do that, and I try to connect to the database, I get
the following message;

psql: FATAL: database "mydb" does not exist
DETAIL: The database subdirectory "/var/lib/pgsql/data/base/1964658" is
missing.

No dir is removed during the reboot, (I checked that, and the subdirs on
/var/lib/pgsql/data/base were exactly the same before and after the
reboot), and 1964658 does not exist (didn't exist before the reboot,
either), so it seems that postgres loses the reference to the dir where
data is stored. It doesn't happen all the time. The rest of the software
on that computer is working fine.

Does anyone know what can be causing this behaviour?

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message lmyho 2006-04-06 17:27:36 Debian package for freeradius_postgresql module
Previous Message Dawid Kuroczko 2006-04-06 17:13:20 Re: "Upcalls" (sort of) from the database