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

It was CentOS release 3.8 and ext2 (I switched it to ext3 after the
disaster).

HW is HP Array P400, with HP DG146ABAB4 Disks.

Status of one of the disk switched from OK to predictive failure, I guess
the array didn't recognize the failure and didn't park it in time.

Filip

======================================

On Mon, 9 Jun 2008, Alvaro Herrera
wrote:

> Filip Krška wrote:
>> 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(?!).
>
> Ugh. For the record, what operating system and filesystem are you
> using? Oh, the underlying storage may be useful too.
>
>
> --
> 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 Tue Jun 10 08:20:49 2008
Received: from localhost (unknown [200.46.204.183])
by developer.postgresql.org (Postfix) with ESMTP id 023202E0060
for <pgsql-admin-postgresql(dot)org(at)developer(dot)postgresql(dot)org>; Tue, 10 Jun 2008 08:20:49 -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 14275-05
for <pgsql-admin-postgresql(dot)org(at)developer(dot)postgresql(dot)org>;
Tue, 10 Jun 2008 08:20:41 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from swip.net (mailfe06.tele2.it [212.247.154.173])
by developer.postgresql.org (Postfix) with ESMTP id A94A82E0056
for <pgsql-admin(at)postgresql(dot)org>; Tue, 10 Jun 2008 08:20:45 -0300 (ADT)
X-Cloudmark-Score: 0.000000 []
X-Cloudmark-Analysis: v=1.0 c=1 a=nd9pq3UZPq4A:10 a=zBtazHSgq_sA:10 a=Y4xYv2_f_KlqPSz4q0MA:9 a=W0Q0wkfP6-tQkYaMdnIA:7 a=lCc08YjtoD-ljeRBZldCOUfjOtsA:4 a=XF7b4UCPwd8A:10
Received: from [88.149.254.239] (account cxu-8rf-htj(at)tele2(dot)it HELO [192.168.1.103])
by mailfe06.swip.net (CommuniGate Pro SMTP 5.2.4b)
with ESMTPA id 968916674; Tue, 10 Jun 2008 13:20:43 +0200
Message-ID: <484E6387(dot)4040008(at)geologyx(dot)it>
Date: Tue, 10 Jun 2008 13:20:39 +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: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
CC: pgsql-admin(at)postgresql(dot)org
Subject: Re: Connecting from xp to linux server
References: <484D11CC(dot)3050806(at)geologyx(dot)it> <484D4097(dot)4070807(at)Sheeky(dot)Biz> <484D9D62(dot)8050705(at)geologyx(dot)it> <484DCE85(dot)5080800(at)Sheeky(dot)Biz>
In-Reply-To: <484DCE85(dot)5080800(at)Sheeky(dot)Biz>
Content-Type: text/plain; charset=ISO-8859-1; 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/68
X-Sequence-Number: 29406

Thanks everybody! In fact it was a syntax problem. Now it works fine.

Cheers

Simone

Shane Ambler ha scritto:
> Simone Gadenz wrote:
>> Shane,
>>
>> I attached the pg_hba.conf I have on the server. I can use pgadmin3
>> when I connect from the server itself, so I think the pg_hba on the
>> server is correct.
>>
>> From the client machine I cannot connect through pgadmin3. Is there
>> another way to test connection client server? Has pg a textual client
>> to send sql statements?
>>
>> Thanks a lot
>>
>> Simone
>>
>>
>
> # connections for all the pcs on the subnet
> #
> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
> host all all 192.168.148.0 255.255.255.0
> host all all 192.168.159.0 255.255.255.0
>
>
> try adding the method to the end of these lines.
>
>
> # METHOD can be "trust", "reject", "md5", "crypt", "password", "gss",
> "sspi",
> # "krb5", "ident", "pam" or "ldap". Note that "password" sends passwords
> # in clear text; "md5" is preferred since it sends encrypted passwords.
>
>

--

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.