| From: | Tulqin Navruzov <tulqin(dot)navruzov(at)finnetlimited(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Fwd: Postgresql Data corruption |
| Date: | 2020-01-14 20:44:48 |
| Message-ID: | CANb6iOF68v34C+WcQiQQ=HRrjz-bpYP3cZcbREQaXSxU7UU0Hw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi team
Could you help us to sort this out please?
We had some hardware problems with Datacenter and could not using
postgresql from restored snapshots it showing "Structure needs to be
cleaning " during startup
, on centos7 did xfs_repair and postgresql started successfully. But could
not select datas from it . showing below message .
This is when want to login to db with postgres user .
psql: PANIC: could not open critical system index 2662
but can logged in with another user and trying to select from some tables ,
showing this message :
ERROR: catalog is missing 11 attribute(s) for relid 113971
Could you help us to solve this problem? or could you give contact who can
help with this?
Thanks in advance.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2020-01-14 20:45:17 | Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) |
| Previous Message | David G. Johnston | 2020-01-14 20:43:51 | Re: Multiple Aggregations Order |