| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'AL-Temimi, Muthana *EXTERN*'" <muthana(dot)al-temimi(at)tu-harburg(dot)hamburg(dot)de>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: database server crash und how can i check all tables |
| Date: | 2015-06-19 11:03:06 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B50F66606@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
AL-Temimi, Muthana wrote:
> i have Postgresql Version 9.1 installed on SuSu Linux Server and the system of database server is
> crashed. Because the Harddisk(SAN). Now I restarted it and the system work again. But I want to check
> all the tables if everything is ok. Is there a command for such problem (check).
>
> Because I have the following problem some tables filled with NULL and in normally case that should be
> not happened.
That looks a lot like the file system check, while restoring file system integrity,
ate some of your data. It has happened to me before.
You should restore from a backup.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shih Théo | 2015-06-20 10:11:56 | The Problem of Applying Point-in-time Recovery |
| Previous Message | Albe Laurenz | 2015-06-19 11:00:55 | Re: database server crash und how can i check all tables |