Re: Postgredb issue

On Sat, 9 May 2020 at 09:18, Thusitha Maheepala <thusitha@onsys.com.au> wrote:

Hi Team,

     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