| 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: | Whole Thread | Raw Message | 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?
>
>
>
| 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 |