On 9/5/04 9:04 AM, "Jan Wieck" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org