From: | Fabricio Peñuelas <fabrixio1(at)hotmail(dot)com> |
---|---|
To: | Thomas Poty <thomas(dot)poty(at)gmail(dot)com> |
Cc: | Forall <forall(at)stalowka(dot)info>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Postgresql 9.3 - problem after crash server |
Date: | 2018-08-02 19:04:23 |
Message-ID: | CY4PR20MB20077AFA4AA0821F6597E219FE2C0@CY4PR20MB2007.namprd20.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Maybe with relfilenode if not working with oid.
Saludos.
El 2 ago. 2018 10:55 AM, Thomas Poty <thomas(dot)poty(at)gmail(dot)com> escribió:
I am pretty sure the database is corrupted.
Unfortunately, i am not able to help you more. Sorry
The only advices I have are :
Invest in a battery between power and server (UPS)
Have backups (logical and physical) more recent
Maybe community will able to help you...
Good luck
Le jeu. 2 août 2018 à 18:12, Forall <forall(at)stalowka(dot)info<mailto:forall(at)stalowka(dot)info>> a écrit :
Yes, I connected to the database e200 but still select results nothing select * from pg_class where oid=12685;
I think database is corrupted...
W dniu 2018-08-02 o 16:33, Thomas Poty pisze:
Are you connected to the database "e200"?
Le jeu. 2 août 2018 à 16:05, Albert <forall(at)stalowka(dot)info<mailto:forall(at)stalowka(dot)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...
From | Date | Subject | |
---|---|---|---|
Next Message | Debraj Manna | 2018-08-03 03:57:26 | Re: Postgres 10 disk space requirement compared to postgres 9.5.4 |
Previous Message | Rui DeSousa | 2018-08-02 18:29:34 | Re: Errors from archive restore from S3 and wrong size archive file |