英文:
index "pg_authid_oid_index" contains unexpected zero page at block 1
问题
"İndex "pg_authid_oid_index" contains unexpected zero page at block 1 this.
İ can't login because of this error.
Even though i trust the settings in pg_hba.conf, i still get the same error.
Has anyone ever encountered such an error before?
Can I take a backup while the db is in this state?"
"İndex "pg_authid_oid_index" 包含意外的零页面，位于块1处。由于这个错误，我无法登录。
尽管我信任pg_hba.conf中的设置，但我仍然遇到相同的错误。
有人曾经遇到过这样的错误吗？
在数据库处于这种状态时，我能够进行备份吗？"
英文:
İndex "pg_authid_oid_index" contains unexpected zero page at block 1 this.
İ can't login because of this error.
Even though i trust the settings in pg_hba.conf, i still get the same error.
Has anyone ever encountered such an error before?
Can I take a backup while the db is in this state?
答案1
得分: 0
你有数据损坏。
假设那是唯一损坏的文件，你需要以一种不尝试使用系统索引的模式启动数据库。类似 pg_ctl start -o -P 应该能做到这一点。然后，以超级用户身份连接后，重建索引 reindex table pg_authid;
如果你的数据损坏不止一个地方，而且没有备份，那么情况可能相当糟糕。
英文:
You have corruption.
Assuming that that is the only corrupted file, you need to start the database in a mode where it doesn't try to use the system indexes. Something like pg_ctl start -o -P should do that. Then once connected as a superuser, rebuild the index reindex table pg_authid;
If you have corruption through more places than just that file and you don't have a backup, then you are pretty much screwed.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论