Skip to content

naanur/psql_corrupt

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 

Repository files navigation

IF FOLLOWING POSTGRESQL ERRORS OCCURS: "missing chunk number x for toast value xxxxxxx in pg_toast_xxxxxxx"

OR

"unexpected chunk number xxx (expected x) for toast value xxxxxx in pg_toast_xxxxx"

TRY FIRST:

  • "select reltoastrelid::regclass from pg_class where relname ='tablename';" THEN
  • "REINDEX INDEX indexname_idx" of corrupted table.

uncomment this line #87 "# delete_by(id)" to delete corrupted This script is used when another methods can't help. !DATA WILL BE LOST!

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages