Skip site navigation (1) Skip section navigation (2)

Re: verifying database integrity - fsck for pg?

From: Harry Jackson <harryjackson(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: verifying database integrity - fsck for pg?
Date: 2006-01-31 10:30:52
Message-ID: 45b42ce40601310230p70491821qd050bc4d0fa96dd8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On 1/31/06, Rich Doughty <rich(at)opusvl(dot)com> wrote:
> We are currently migrating a cluster between hosts. I'd like to
> verify that the new database has been transferred reliably and
> that the datafiles are in tact.
>
> What's the recommended way to do this? We're using
> pg_start/stop_backup so an md5 check is out of the question.
>
> pg version 8.0

I would doubt if it is a full test but in the past when I have had
corruptions in the database its been a full vacuum that has spotted
them.

--
Harry
http://www.hjackson.org
http://www.uklug.co.uk

In response to

pgsql-general by date

Next:From: Howard ColeDate: 2006-01-31 10:33:31
Subject: How to enumerate/drop user sessions in windows
Previous:From: Myatluk AndreyDate: 2006-01-31 10:28:07
Subject: Re: PostgreSQL + hibernate

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group