Re: Catalog corruption

2018-08-30 Thread Andrew Gierth
> "Mariel" == Mariel Cherkassky writes: Mariel> Hi Andrew, Mariel> what is the name of the channel ? The name of the channel is #postgresql (including the # character) -- Andrew (irc:RhodiumToad)

Re: Catalog corruption

2018-08-30 Thread Mariel Cherkassky
Hi Andrew, what is the name of the channel ? Thanks , Mariel. ‫בתאריך יום ד׳, 29 באוג׳ 2018 ב-14:31 מאת ‪Andrew Gierth‬‏ <‪ and...@tao11.riddles.org.uk‬‏>:‬ > > "Mariel" == Mariel Cherkassky writes: > > Mariel> Hi, > > Mariel> I sent already an email about this topic to pgsql-admins but

Re: Catalog corruption

2018-08-29 Thread Andrew Gierth
> "Mariel" == Mariel Cherkassky writes: Mariel> Hi, Mariel> I sent already an email about this topic to pgsql-admins but I Mariel> think that it might be more relevant to this mailing list. The -hackers mailing list is about the development of postgresql. Mariel> I'm trying to

Re: Catalog corruption

2018-08-29 Thread Mariel Cherkassky
Yes indeed. I took a cold backup - shutdown the database and copy all the data dir. ‫בתאריך יום ג׳, 28 באוג׳ 2018 ב-22:34 מאת ‪Asim R P‬‏ <‪aprav...@pivotal.io ‬‏>:‬ > On Tue, Aug 28, 2018 at 7:36 AM, Mariel Cherkassky > wrote: > > Afterwards I vacuumed all the databases but nothing helped. I

Re: Catalog corruption

2018-08-28 Thread Asim R P
On Tue, Aug 28, 2018 at 7:36 AM, Mariel Cherkassky wrote: > Afterwards I vacuumed all the databases but nothing helped. I tried to > reindex the databases but I got the next error : > > 2018-08-28 21:50:03 +08 db2 24360 ERROR: could not access status of > transaction 32212695 > 2018-08-28

Catalog corruption

2018-08-28 Thread Mariel Cherkassky
Hi, I sent already an email about this topic to pgsql-admins but I think that it might be more relevant to this mailing list. I'm trying to investigate a corruption that happened on a machine of one of our clients. A little background : -os Centos 6.6 -PostgreSQL v9.2.5 -I was asked to understand