Horton

Re: How to determine a database is intact?

Wes <wespvp@syntegra.com>

View thread View on postgr.es
From: Wes <wespvp@syntegra.com>
To: Jan Wieck <JanWieck@yahoo.com>
Cc: Richard Huxton <dev@archonet.com>, Postgres General <pgsql-general@postgresql.org>
Date: 2004-09-08T12:59:09Z
Lists: pgsql-general 
On 9/5/04 9:04 AM, "Jan Wieck" <JanWieck@yahoo.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