what happend to my database

From: "Medi Montaseri" <montaseri(at)gmail(dot)com>
To: postgresql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: what happend to my database
Date: 2008-05-29 01:37:06
Message-ID: 8078a1730805281837y1ed331bey4e7db16a63423cfa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am faced with a database disapperance and seeking some explanations
outside of gremlins.
I had a database running at

cat /etc/sysconfig/pgsl/postmaster
PGDATA=/qmsvol/pg_8.1.9/data
PGLOG=/var/log/pgsql/pgstartup.log

Where /qmsvol is an iSCSI block device
A couple of days ago, my server was rebooted and by the time I got to it my
database was deleted, gone, zapped, not there any more.

I looked at my pgstartup.log where I see the following....

postmaster cannot access the server configuration file
"/qmsvol/pg_8.1.9/postgresql.conf": Permission denied
over 17 times and then following by...
The database cluster will be initialized with locale en_US.UTF-8.

I think the following happend...
Since my PGDATA was on an iSCSI device, by the time /etc/rc3.d/S64postgresql
was executed, the device below it was not available.....question...why the
error says "permission denied" vs "file not found". In the meantime, pg_ctl
kept trying and finally concluded that the data directory is blank, and
hence this must be a out-of-box case and he is good to initdb the PGDATA and
as it called initdb to do the job... the iSCSI volume below it came online
and by then the bomb had already been dropped.

Now I need to find some facts to support this...
Where else can I look for forensics

Thanks
Medi

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Holdoway 2008-05-29 01:52:35 Re: what happend to my database
Previous Message Scott Marlowe 2008-05-29 00:36:11 Re: statistics collector Log message