0

We had an issue with our Hard drive so we copied the data directory into a new hard and we are facing some issues now the issue is I can't read data from three tables for example if I query Select * from table_name limit 10 it returns me 10 rows but when I try to get a count with Select count(*) from table name; it does not return anything and gets stuck. I tried to recover it according to this fix but when I try to vaccume the table I get error ERROR: uncommitted xmin 60148772 from before xid cutoff 60165118 needs to be frozen. The data is very important to us if any one can help please let me know what extra details required I have also posted some questions here and here but now the situation is above at the moment.

Asnad Atta
  • 3,855
  • 1
  • 32
  • 49
  • Asking three times doesn't make it better. My advice stands: hire a consultant and pay the price for your negligence. If you are not willing to do that, the data obviously isn't all that important. Be warned, though, that not even an expert can guarantee to rescue your data. – Laurenz Albe Apr 30 '20 at 20:19
  • Thanks for suggestion @LaurenzAlbe but my client doesn't like the suggestion he needs the data off-course but wants me to try. – Asnad Atta May 01 '20 at 06:04
  • Then spend a few years working with PostgreSQL, follow the hackers list, read into the source, solve problems, and I'm sure you will be up to the task. – Laurenz Albe May 01 '20 at 07:01

0 Answers0