From: | André José Guergolet <AGuergolet(at)compugraf(dot)com(dot)br> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Invalid Page Header |
Date: | 2006-10-16 13:55:01 |
Message-ID: | 3FFA1818C1550246933DEA311C39B076123175@CGEXC03.compugraf.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi everybody,
I have a Postgres Database Server 8.0 in a Windows 2000 Professional.
I need to migrate this server to 8.1.4 or 8.1.5 Posgresql Version, but, when I execute backup command from pgAdmin III or from a command line (pg_dump [parameters] ) I get this error:
invalid page header in block 4686 of relation "tb_Bilhete"
Details:
==========================
pg_dump: ERROR: invalid page header in block 4686 of relation "tb_Bilhete"
pg_dump: SQL command to dump the contents of table "tb_Bilhete" failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR: invalid page header in block 4686 of relation "tb_Bilhete"
pg_dump: The command was: COPY public."tb_Bilhete" ("inIdBilhete", "dtDataHora", "inDuracao", "vcNumRefPrivado", "vcNumRefPublico", "vcNumPartPrivado", "vcNumPartPublico", "chDirecaoRef", "vcTronco", "chInterno", "chProcessado") TO stdout;
pg_dump: *** aborted because of error
Process returned exit code 1.
==========================
How Can I resolve this problem?
I have other backup, but I need the more recent backup.
I search at the internet about this problem, but I find solutions only for Linux System using Linux tools.
Thanks
André Guergolet
From | Date | Subject | |
---|---|---|---|
Next Message | Ray Stell | 2006-10-16 19:19:49 | pgAdmin install? |
Previous Message | Tobias Brox | 2006-10-15 14:52:12 | Re: [PERFORM] autovacuum on a -mostly- r/o table |