Re: invalid page header in block 29 of relation "pg_type"

I hope, I've solved it.

I found 512 damaged bytes on the 29th 8k page of the pg_type's datafile
($PGDATA/base/16390/1247), it was overwritten by text from some log(?!).

When I had dropped the whole 8k page (dd of=/tmp/head count=29 bs=8192,
dd of=/tmp/tail skip=30 bs=8192, then cat /tmp/head /tmp/tail), the
pg_dumpall utility was able to dump the DB instance then.

I compared schemas (pg_dumpall -s), fortunately only several empty, not
used tables were affected.

Then I imported the dump, and now the DB instance seems to work properly,
also the pg_dumps, vacuum anylysis.

Best regards,

Filip Krska

--

ComSTAR spol. s r. o.
Třebohostická 14
100 31 Praha 10

HotLine (pev.): 274 016 000
HotLine (mob.): 777 343 857

On Fri, 6 Jun 2008, Alvaro Herrera wrote:

> Filip Krška wrote:
>> Hello,
>>
>> we have (maybe due to temporary Disk Array HW failure, which occurred on
>> the same day the pg_dump started to complain - array is now successfully
>> rebuilt) problem with consistency of pg_catalog.pg_type table.
>
> Did you solve this problem?
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>From pgsql-admin-owner(at)postgresql(dot)org Mon Jun 9 08:19:56 2008
Received: from localhost (unknown [200.46.204.183])
by developer.postgresql.org (Postfix) with ESMTP id 68C032E0035
for <pgsql-admin-postgresql(dot)org(at)developer(dot)postgresql(dot)org>; Mon, 9 Jun 2008 08:19:54 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
with ESMTP id 62170-01
for <pgsql-admin-postgresql(dot)org(at)developer(dot)postgresql(dot)org>;
Mon, 9 Jun 2008 08:19:46 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from swip.net (mailfe13.tele2.it [212.247.155.141])
by developer.postgresql.org (Postfix) with ESMTP id 26EEA2E0032
for <pgsql-admin(at)postgresql(dot)org>; Mon, 9 Jun 2008 08:19:49 -0300 (ADT)
X-Cloudmark-Score: 0.000000 []
X-Cloudmark-Analysis: v=1.0 c=1 a=Y4xYv2_f_KlqPSz4q0MA:9 a=o9DRAFmFE2JGraQ64hMA:7 a=_AXKxNSVHTDbA4C6wee0gfDQ5nYA:4 a=50e4U0PicR4A:10
Received: from [88.149.236.151] (account cxu-8rf-htj(at)tele2(dot)it HELO [192.168.1.103])
by mailfe13.swip.net (CommuniGate Pro SMTP 5.1.13)
with ESMTPA id 579254902 for pgsql-admin(at)postgresql(dot)org; Mon, 09 Jun 2008 13:19:46 +0200
Message-ID: <484D11CC(dot)3050806(at)geologyx(dot)it>
Date: Mon, 09 Jun 2008 13:19:40 +0200
From: Simone Gadenz <s(dot)gadenz(at)geologyx(dot)it>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
To: pgsql-admin(at)postgresql(dot)org
Subject: Connecting from xp to linux server
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level:
X-Archive-Number: 200806/52
X-Sequence-Number: 29390

Hi all,

this is the problem I am facing.

I have PG 8.3 running on a KUBUNTU installation running on a virtual
machine. From inside the virtual machine I can use PGADMIN to manage PG
but when I try to connect from the xp machine I have this error: "Error
connecting to the server:FATAL: missing or erroneous pg_hba.conf file" .

I set the permission in the pg_hba.conf on the server.

The machine talk each oher, I can ping and use telnet on the 5432 port.

The log on the server does not report any problem.

Ideas?

--

Dr. Simone Gadenz

via P. Togliatti 69, 50051

Castelfiorentino (FI)

+39 339 6053660

*INFORMATIVA PRIVACY (ex D.lgs. 196/03)*

Le inormazioni contenute in questo documento e nei relativi allegato

possono essere riservate e sono destinate esclusivamente alla persona

od alla Societŕ indicata come destinatario.

La diffusione e la distribuzione del presente documento a soggetti

diversi da quelli indicati, od in genere qualsivoglia utilizzo illecito

dei dati ivi contenuti, e proibita sia ai sensi dell'art. 616 del

Codice Penale che dal D.Lgs 196/03 in materia di protezione dei dati

personali (Privacy).

Se avete ricevuto per errore questo documento siete pregati di

distruggerlo e di comunicarcelo prontamente tramite e-mail o fax.