Postgres Pro
Downloads
Home   >   mailing lists

Re: testing database consistency - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: testing database consistency
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C55745@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: testing database consistency  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Connecting to Oracle from Postgresql 9.2 on Windows
Next
From: Alejandro Brust
Date:
Subject: Re: testing database consistency