Re: Postgresql 9.3 - problem after crash server

From: Thomas Poty <thomas(dot)poty(at)gmail(dot)com>
To: forall(at)stalowka(dot)info
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql 9.3 - problem after crash server
Date: 2018-08-02 13:52:43
Message-ID: CAN_ctniRSZWSbz-5D6qUb8XdBB=aXV86yX=v_-368kzi0-S5_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

157934 is the oid of your database
if you run => select oid, datname from pg_database where oid =157934;
The result should be oid = 157934 and datname = e200

12685 is the oid of your relation
if you run => select * from pg_class where oid=12685;
it will give you information about the relation

Le jeu. 2 août 2018 à 15:38, For(at)ll <forall(at)stalowka(dot)info> a écrit :

> W dniu 02.08.2018 o 15:18, Thomas Poty pisze:
>
> Hi,
> I don't know if it will help you but you could try this:
> Identify " base/157934/12685"
> If It is an index than drop this index and rebuild it
> if It is a table than drop all indexes and rebuild them all
>
> Hi,
>
> How I can identify base/157934/12685 what is exactly is?
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Debraj Manna 2018-08-02 14:27:44 Postgres 10 disk space requirement compared to postgres 9.5.4
Previous Message Thomas Poty 2018-08-02 13:19:17 Re: Postgresql 9.3 - problem after crash server