Re: Postgredb issue

Hi Team,
      Problem is database service also not started.how to start and index
this situation

On Sat, May 9, 2020 at 8:36 PM Rod Taylor <rbt@rbt.ca> wrote:

> 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
>


-- 
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