| From: | Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de> |
|---|---|
| To: | Rich Doughty <rich(at)opusvl(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: verifying database integrity - fsck for pg? |
| Date: | 2006-02-01 13:07:55 |
| Message-ID: | 73E4CE23-9248-4229-BB99-87AD970C5618@pharmaline.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mott Leroy | 2006-02-01 14:14:24 | Re: help with locked table(s)/transactions(s) |
| Previous Message | Richard Huxton | 2006-02-01 12:52:18 | Re: PostgreSQL 8.1 without readline and zlib |