Re: verifying database integrity - fsck for pg? - Mailing list pgsql-general

From Guido Neitzer
Subject Re: verifying database integrity - fsck for pg?
Date
Msg-id 73E4CE23-9248-4229-BB99-87AD970C5618@pharmaline.de
Whole thread Raw
In response to Re: verifying database integrity - fsck for pg?  (Rich Doughty <rich@opusvl.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: PostgreSQL 8.1 without readline and zlib
Next
From: Chris Kratz
Date:
Subject: OID question