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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
