Re: Database consistency check.

Thank you all for your help!

On Thu, Nov 7, 2019, 4:37 PM Grigory Smolkin <g(dot)smolkin(at)postgrespro(dot)ru>
wrote:

> Hello!
>
> pg_probackup has dedicated command for PostgreSQL instance verification,
> which rely on amcheck, page checksum comparison and page header sanity
> checks.
> It can be used on running databases and can be used even if you do not
> use pg_probackup for backup/restore purposes.
>
>
> https://github.com/postgrespro/pg_probackup/blob/master/Documentation.md#checkdb
>
> https://github.com/postgrespro/pg_probackup/blob/master/Documentation.md#verifying-a-cluster
>
> On 11/7/19 10:47 AM, Asomba Djala wrote:
> > Hello,
> >
> > I have a question, SQL Server has a tool DBCC checkdb and I believe
> > Oracle it's VerifyDB. Does Postgres have something similar and if not,
> > does anyone have steps or queries to do a sanity check or database
> > integrity check with PgAdmin4?
> >
> > In advance,
> >
> > Thank you for your help.
> >
> > Aso.
>
> --
> Grigory Smolkin
> Postgres Professional: http://www.postgrespro.com
> The Russian Postgres Company
>
>
>
>