Re: testing database consistency

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Scott Ribe *EXTERN*" <scott_ribe(at)elevated-dev(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: testing database consistency
Date: 2013-11-04 13:56:17
Message-ID: A737B7A37273E048B164557ADEF4A58B17C55745@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Scott Ribe wrote:
>> There is no safe way (unless you were running on 9.3 with checksums).
>
> It would be cool though, for those of us doing that, to have some new command to verify the checksum
> on all pages...

How about
pg_dumpall -f /dev/null

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alejandro Brust 2013-11-04 19:16:07 Re: testing database consistency
Previous Message Albe Laurenz 2013-11-04 13:52:29 Re: Connecting to Oracle from Postgresql 9.2 on Windows