KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have multiple errors with my postgresql db, which resulted after a power surge: I cannot access most tables from my database. When I try for example select * from ac_cash_collection , I get the foolowing error: ERROR: missing chunk number 0 for toast value 118486855 in pg_toast_2619 when I try pg_dump I get the following error: Error message from server: ERROR: relation "public.st_stock_item_newlist" does not exist pg_dump: The command was: LOCK TABLE public.st_stock_item_newlist IN ACCESS SHARE MODE I went ahead and tried to run reindex of the whole database, I actually I left it runnng, went to sleep, and I found it had not done anything in the morning, so I had to cancel it. I need some help to fix this as soon as possible, Please help.
Tags (comma-separated)
Save Edits
Cancel