Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1flIJZ-0002Sp-BN
	for pgsql-admin@arkaria.postgresql.org; Thu, 02 Aug 2018 18:27:09 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1flIJX-0005CF-6J
	for pgsql-admin@arkaria.postgresql.org; Thu, 02 Aug 2018 18:27:07 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <sql-pgsql-admin@m.gmane.org>)
	id 1flAJR-0002I8-L7
	for pgsql-admin@lists.postgresql.org; Thu, 02 Aug 2018 09:54:29 +0000
Received: from [195.159.176.226] (helo=blaine.gmane.org)
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <sql-pgsql-admin@m.gmane.org>)
	id 1flAJO-0004dD-9p
	for pgsql-admin@postgresql.org; Thu, 02 Aug 2018 09:54:28 +0000
Received: from list by blaine.gmane.org with local (Exim 4.84_2)
	(envelope-from <sql-pgsql-admin@m.gmane.org>)
	id 1flAHD-00088c-NP
	for pgsql-admin@postgresql.org; Thu, 02 Aug 2018 11:52:11 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-admin@postgresql.org
From: "For@ll" <forall@stalowka.info>
Subject: PostgreSQL 9.3 - reindex problem
Date: Thu, 2 Aug 2018 11:54:16 +0200
Lines: 26
Message-ID: <pjuk85$u34$1@blaine.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@blaine.gmane.org
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
X-Mozilla-News-Host: news://news.gmane.org:119
Content-Language: pl
X-Host-Lookup-Failed: Reverse DNS lookup failed for 195.159.176.226 (failed)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

Hi,

I have problem with postgresql-9.3 in our clients. They suddenly lost 
power connection and all servers halt.. I repiar xfs filesystem on 
CentOS7 postgresql partition. Now when I want run reindex database I 
receive error:

reindexdb -d ex200
NOTICE:  table "pg_catalog.pg_class" was reindexed
reindexdb: reindexing of database "ex200" failed: ERROR:  invalid page 
in block 101 of relation base/157934/12685

I want to try run dump and save database on plaintext but when I start 
pg_dump it's hang...

pg_dump -a -v -d ex200 > ex200.sql
pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading user-defined functions

Any ideas what can I do.. Client told me they have a backup from 2 
montgs ago....