Subject: Re: PostgreSQL 9.3 - reindex problem
To: pgsql-admin@lists.postgresql.org
References: <pjuk85$u34$1@blaine.gmane.org>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <dc7ea056-9d7e-79d1-d8f3-95ff814b2b7e@gmail.com>
Date: Fri, 3 Aug 2018 10:46:06 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <pjuk85$u34$1@blaine.gmane.org>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

On 08/02/2018 04:54 AM, For@ll wrote:
> 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

What object does 157934/12685 refer to?  Maybe you can drop that one thing 
and then recreate it.

>
> 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....


-- 
Angular momentum makes the world go 'round.