Обсуждение: Error after power failure
Hello!
I accidentally unplugged my computer and after restarting it my postgresql gives me this error:
ERROR: invalid page header in block 45 of relation base/16395/2608
What does it mean and how can I fix my db?
I don't have any backups and I'm not really good with databases in general(I use it for personal use and I'm not an IT specialist).
It would be really good if someone could help me because that database is really important(even though I don't have a backup for it).
Thanks,
Robert
I accidentally unplugged my computer and after restarting it my postgresql gives me this error:
ERROR: invalid page header in block 45 of relation base/16395/2608
What does it mean and how can I fix my db?
I don't have any backups and I'm not really good with databases in general(I use it for personal use and I'm not an IT specialist).
It would be really good if someone could help me because that database is really important(even though I don't have a backup for it).
Thanks,
Robert
Hello maybe this article helps to you http://blog.endpoint.com/2010/06/tracking-down-database-corruption-with.html Regards Pavel Stehule 2010/8/30 Roberts Staltmanis <staltmanis@gmail.com>: > Hello! > I accidentally unplugged my computer and after restarting it my postgresql > gives me this error: > ERROR: invalid page header in block 45 of relation base/16395/2608 > > What does it mean and how can I fix my db? > I don't have any backups and I'm not really good with databases in general(I > use it for personal use and I'm not an IT specialist). > > It would be really good if someone could help me because that database is > really important(even though I don't have a backup for it). > > Thanks, > Robert >