Re: verifying database integrity - fsck for pg?

[Guido Neitzer <guido.neitzer@xxxxxxxxxxxxx>]

On 31.01.2006, at 17:38 Uhr, Rich Doughty wrote:

> I'm not too fussed about a row-by-row comparison between the source  
> and the
> copy. It's rather a case of a tool to check the datafiles'  
> integrity (such
> as fsck, myisamchk, svnadmin verify etc).
>
> If the fact that pg_dumpall returned successfully, then i would  
> hope that
> all the data is present and correct.

As I moved my content from another DBMS to PostgreSQL that was no  
option for us. We had to check table by table and row by row.

cug

--
PharmaLine Essen, GERMANY and
Big Nerd Ranch Europe - PostgreSQL Training, Feb. 2006, Rome, Italy
http://www.bignerdranch.com/classes/postgresql.shtml

Attachment: smime.p7s
Description: S/MIME cryptographic signature