Re: How to determine a database is intact?

From: Wes <wespvp(at)syntegra(dot)com>
To: Jan Wieck <JanWieck(at)yahoo(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to determine a database is intact?
Date: 2004-09-08 12:59:09
Message-ID: BD646C4D.92CE%wespvp@syntegra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/5/04 9:04 AM, "Jan Wieck" <JanWieck(at)yahoo(dot)com> wrote:

> 24 hours to do what? The pg_dumpall, the restore or both?

There's more than 250 million rows. If I remember right, it's ballpark 25%
data reload, 75% index/foreign constraint rebuild. Pg_dumpall is something
like 3 hours or so.

Wes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tore Halset 2004-09-08 13:02:31 Re: ERROR: canceling query due to user request
Previous Message Oliver Elphick 2004-09-08 11:51:55 Re: Function caches wrong OID of temporary table?