Re: Postgresql 9.3 - problem after crash server - Mailing list pgsql-admin

From Thomas Poty
Subject Re: Postgresql 9.3 - problem after crash server
Date
Msg-id CAN_ctniRSZWSbz-5D6qUb8XdBB=aXV86yX=v_-368kzi0-S5_Q@mail.gmail.com
Whole thread Raw
In response to Postgresql 9.3 - problem after crash server  ("For@ll" <forall@stalowka.info>)
List 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@ll <forall@stalowka.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?


pgsql-admin by date:

Previous
From: Thomas Poty
Date:
Subject: Re: Postgresql 9.3 - problem after crash server
Next
From: Debraj Manna
Date:
Subject: Postgres 10 disk space requirement compared to postgres 9.5.4