Thread:

From
pck
Date:
Hi,

I've got PgSQL 7.4 on FreeBSD 4.

When I try to dump database:
/usr/local/bin/pg_dump database --username=user -d > database.sql

It shows me these errors and stops:
pg_dump: dumpClasses(): SQL command failed
pg_dump: Error message from server: ERROR:  invalid page header in
block 9869 of relation "tabstats"
pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor


How can i repair this table?

--
Przemysław Ciesielski

Re: ERROR: invalid page header in block 9869

From
pck
Date:
Sorry, i've forgot the subject...

On Apr 4, 2005 11:14 AM, pck <peceka@gmail.com> wrote:
> Hi,
>
> I've got PgSQL 7.4 on FreeBSD 4.
>
> When I try to dump database:
> /usr/local/bin/pg_dump database --username=user -d > database.sql
>
> It shows me these errors and stops:
> pg_dump: dumpClasses(): SQL command failed
> pg_dump: Error message from server: ERROR:  invalid page header in
> block 9869 of relation "tabstats"
> pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor
>
> How can i repair this table?
>
> --
> Przemysław Ciesielski
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>


--
Przemysław Ciesielski
[GG:721013 T:pck JID:pck@chrome.pl]
[GSM:+48661443319][SKYPE: przemyslaw.ciesielski]
[HTTP:www.ciesielski.net]