On Mon, Jul 19, 2010 at 5:57 PM, tuanhoanganh wrote:
> I have checked SHOW fsync, It is ON.
> When I view table dmvt on PgAdmin, it only has 1332 rows, but command
> "SELECT count(*) FROM dmvt" return 2449 rows.
By default pgAdmin shows the number of rows listed in pg_class, which
is not always a
I have checked SHOW fsync, It is ON.
When I view table dmvt on PgAdmin, it only has 1332 rows, but command
"SELECT count(*) FROM dmvt" return 2449 rows.
My postgresql.conf is default of EnterpriseDB Postgres 8.3.9.
Please help me. Sorry for my English.
Tuan Hoang Anh.
On Mon, Jul 19, 2010 at 9:
On 19/07/10 18:37, tuanhoanganh wrote:
> When I use pgadmin to view data of table dmvt, it have data. But when I
> "select * from dmvt" there is error on log
>
> 2010-07-19 17:32:17 ICTWARNING: invalid page header in block 207 of
> relation "dmvt"; zeroing out page
> 2010-07-19 17:32:35 ICTLOG:
On 19/07/10 19:02, Jayadevan M wrote:
>> Yesterday my server is power off, when i start server, some of table is
> blank. Is there anyway to rescue it.
> The "Power Off" - is it a planned/regular one? If yes, it makes sense to
> have a normal shutdown of the database before the "Power Off".
...
started PostgreSQL
server etc might give a better idea to those in forum who are in a
position to help.
Regards,
Jayadevan
From: tuanhoanganh
To: pgsql-general@postgresql.org
Date: 07/19/2010 02:45 PM
Subject: [GENERAL] Rescue data after power off
Sent by:pgsql-general
When I use pgadmin to view data of table dmvt, it have data. But when I
"select * from dmvt" there is error on log
2010-07-19 17:32:17 ICTWARNING: invalid page header in block 207 of
relation "dmvt"; zeroing out page
2010-07-19 17:32:35 ICTLOG: server process (PID 3480) was terminated by
excepti
Yes, I don't have backup.
On Mon, Jul 19, 2010 at 4:24 PM, A. Kretschmer <
andreas.kretsch...@schollglas.com> wrote:
> In response to tuanhoanganh :
> > Is there anyway to rescue data afer power off.
> > I have postgres database version 8.3.9 on windows 2003.
> > Yesterday my server is power off,
In response to tuanhoanganh :
> Is there anyway to rescue data afer power off.
> I have postgres database version 8.3.9 on windows 2003.
> Yesterday my server is power off, when i start server, some of table is blank.
> Is there anyway to rescue it.
Restore the data from your backup. You haven't a
Is there anyway to rescue data afer power off.
I have postgres database version 8.3.9 on windows 2003.
Yesterday my server is power off, when i start server, some of table is
blank. Is there anyway to rescue it.
Please help me. I am very confuse.
Tuan Hoang Anh
