Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 48B0C2E0096 for ; Mon, 9 Jun 2008 05:16:58 -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 76094-02-4 for ; Mon, 9 Jun 2008 05:16:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.metron.cz (mail.metron.cz [90.183.235.36]) by developer.postgresql.org (Postfix) with ESMTP id 3723C2E0063 for ; Mon, 9 Jun 2008 05:09:32 -0300 (ADT) Received: from fkrska.pha.comstar.cz (unknown [90.183.234.162]) by mail.metron.cz (Postfix) with ESMTP id C8F394C38A; Mon, 9 Jun 2008 10:09:32 +0200 (CEST) Received: from fkrska.pha.comstar.cz (localhost.localdomain [127.0.0.1]) by fkrska.pha.comstar.cz (8.14.2/8.14.1) with ESMTP id m5989T9g004987; Mon, 9 Jun 2008 10:09:29 +0200 Received: from localhost (filip.krska@localhost) by fkrska.pha.comstar.cz (8.14.2/8.14.2/Submit) with ESMTP id m5989SgY004982; Mon, 9 Jun 2008 10:09:28 +0200 X-Authentication-Warning: fkrska.pha.comstar.cz: filip.krska owned process doing -bs Date: Mon, 9 Jun 2008 10:09:27 +0200 (CEST) From: =?ISO-8859-15?Q?Filip_Kr=A8ka?= X-X-Sender: filip.krska@fkrska.pha.comstar.cz To: Alvaro Herrera cc: pgsql-admin@postgresql.org Subject: Re: invalid page header in block 29 of relation "pg_type" In-Reply-To: <20080606211940.GF16502@alvh.no-ip.org> Message-ID: References: <20080606211940.GF16502@alvh.no-ip.org> User-Agent: Alpine 1.10 (LFD 962 2008-03-14) MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: Content-Type: TEXT/PLAIN; CHARSET=ISO-8859-2; FORMAT=flowed Content-Transfer-Encoding: 8BIT Content-ID: X-Archive-Number: 200806/51 X-Sequence-Number: 29389 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > From pgsql-admin-owner@postgresql.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 ; 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 ; 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 ; 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@tele2.it HELO [192.168.1.103]) by mailfe13.swip.net (CommuniGate Pro SMTP 5.1.13) with ESMTPA id 579254902 for pgsql-admin@postgresql.org; Mon, 09 Jun 2008 13:19:46 +0200 Message-ID: <484D11CC.3050806@geologyx.it> Date: Mon, 09 Jun 2008 13:19:40 +0200 From: Simone Gadenz User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: pgsql-admin@postgresql.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.