Re: Postgresql 9.3 - problem after crash server

Поиск
Список
Период
Сортировка
От Thomas Poty
Тема Re: Postgresql 9.3 - problem after crash server
Дата
Msg-id CAN_ctniRSZWSbz-5D6qUb8XdBB=aXV86yX=v_-368kzi0-S5_Q@mail.gmail.com
обсуждение исходный текст
Ответ на Postgresql 9.3 - problem after crash server  ("For@ll" <forall@stalowka.info>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Poty
Дата:
Сообщение: Re: Postgresql 9.3 - problem after crash server
Следующее
От: Debraj Manna
Дата:
Сообщение: Postgres 10 disk space requirement compared to postgres 9.5.4