Re: Fwd: Postgresql Data corruption

2020-01-14 Thread Michael Paquier
On Tue, Jan 14, 2020 at 02:34:04PM -0800, Adrian Klaver wrote: > On 1/14/20 12:44 PM, Tulqin Navruzov wrote: >> 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

Re: Postgresql Data corruption

2020-01-14 Thread Rene Romero Benavides
Can't help you personally right now due to work, but try these guys: https://pgexperts.com/services/emergency_help/ On Tue, Jan 14, 2020 at 4:08 PM Rene Romero Benavides < rene.romer...@gmail.com> wrote: > On Tue, Jan 14, 2020 at 2:55 PM Tulqin Navruzov < > tulqin.navru...@finnetlimited.com>

Re: Postgresql Data corruption

2020-01-14 Thread Rene Romero Benavides
On Tue, Jan 14, 2020 at 2:55 PM Tulqin Navruzov < tulqin.navru...@finnetlimited.com> wrote: > > > 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 >

Fwd: Postgresql Data corruption

2020-01-14 Thread Tulqin Navruzov
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