Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Date: 2018-06-11 13:28:10
Message-ID: 1528723690634-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I'm searching a way to detect postgresql corruption on a daily basis. Please
provide me

1) a script which detects the corruption in postgres database/instance,

2) and the remedy steps to fix the issue

Searched in lot of links and blogs but unable to find a concrete solution

And also it will be a very great help to me if I can get in the same way
for fragmentation.

Please help me regarding this, since it has been a very long time working on
this.

Thanks in advance.

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fabio Pardi 2018-06-11 13:36:54 Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Previous Message Stéphane KANSCHINE 2018-06-11 09:14:00 Re: Temporarily disable a role