Re: PostgreSQL 9.3 - reindex problem

On 08/02/2018 04:54 AM, For(at)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.