I need big support in my postgresql server suddenly shutdown.But again didn't start I attached here with log can you give solution i search community also i didn't find solution.I attached here with log.can you give solution for me.Fix this issue.I really appericate,
It appears all errors are related to the c_acctprocessorlog_pkey index? Run the below to ditch the current index and rebuild with data from the table files.
REINDEX INDEX c_acctprocessorlog_pkey;
It could be a bug in Pg but it's most likely a filesystem corruption or a hardware issue (bad memory, bad disk controller, bad disk itself). You might find some additional useful messages in the kernel logs.
Since you don't mention a version, upgrade to the most recent minor version of Pg very soon.
regards,
Rod
--
Thusitha Mahipala M.Sc-IT,B.Sc,OCP,OCS,OCE,MCP Country Manager/Head of Database Services Onsys Technologies M: +94716326751 E: thusitha@onsys.com.au W: www.onsys.com.au No 30, Deanston Place Colombo 03, Sri Lanka