Re: Postgresql 9.3 - problem after crash server

Поиск
Список
Период
Сортировка
От Thomas Poty
Тема Re: Postgresql 9.3 - problem after crash server
Дата
Msg-id CAN_ctniMgULeg9b7MM3U5A+fXvAvour3gY14scpmHYkQNxQUGA@mail.gmail.com
обсуждение исходный текст
Ответ на Postgresql 9.3 - problem after crash server  ("For@ll" <forall@stalowka.info>)
Список pgsql-admin
Are you connected to the database "e200"?

Le jeu. 2 août 2018 à 16:05, Albert <forall@stalowka.info> a écrit :
W dniu 02.08.2018 o 15:52, Thomas Poty pisze:
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

select oid, datname from pg_database where oid =157934;
  oid   | datname
--------+---------
 157934 | e200
(1 row)

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

 select * from pg_class where oid=12685;
 relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey |
relhasrules | relhastriggers | relhassubclass | relispopulated | relfrozenxid | relminmxid | relacl | reloptions
---------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-
------------+----------------+----------------+----------------+--------------+------------+--------+------------
(0 rows)

reindexdb -d e200
NOTICE:  table "pg_catalog.pg_class" was reindexed
reindexdb: reindexing of database "e200" failed: ERROR:  invalid page in block 101 of relation base/157934/12685

I still have that error when I run reindexdb -d e200...




В списке pgsql-admin по дате отправления:

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