X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 594975E46E7 for ; Sat, 28 Aug 2004 09:32:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 64507-07 for ; Sat, 28 Aug 2004 12:32:10 +0000 (GMT) Received: from web52809.mail.yahoo.com (web52809.mail.yahoo.com [206.190.39.173]) by svr1.postgresql.org (Postfix) with SMTP id B84FB5E40BA for ; Sat, 28 Aug 2004 09:32:07 -0300 (ADT) Message-ID: <20040828123211.46039.qmail@web52809.mail.yahoo.com> Received: from [68.227.223.161] by web52809.mail.yahoo.com via HTTP; Sat, 28 Aug 2004 05:32:11 PDT Date: Sat, 28 Aug 2004 05:32:11 -0700 (PDT) From: kris pal Subject: Re: vacuum pg_attribute causes high load To: Gaetano Mendola , pgsql-admin@postgresql.org In-Reply-To: <41305CAD.3000501@bigfoot.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2108192525-1093696331=:45889" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200408/295 X-Sequence-Number: 14690 --0-2108192525-1093696331=:45889 Content-Type: text/plain; charset=us-ascii Before to do it be sure that your pg_dump is non affected by not well ordered objects, if yes you have to reorder the order creation ( manually ) in the dump, some times happen. >>>>>>>>>>>>>>>>>>>> I used the dump from the production database(bgms) and imported it into a test database (test). It went through fine with in few minutes. So I guess the ordering of the objects is fine. My only concern is abt the system catalog. Do we need anything else from the original database "bgms" other than the Dump file to recreate it? thanks, Kris Pal. --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! --0-2108192525-1093696331=:45889 Content-Type: text/html; charset=us-ascii

 

 Before to do it be sure that your pg_dump is non affected by not well ordered
objects, if yes you have to reorder the order creation ( manually ) in the dump,
some times happen.

>>>>>>>>>>>>>>>>>>>>

I used the dump from the production database(bgms) and imported it into a test database (test). It went through fine with in few minutes. So I guess the ordering of the objects is fine.  My only concern is abt the system catalog.

Do we need anything else from the original database "bgms"  other than the Dump file to recreate it?

thanks,
Kris Pal.


Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage! --0-2108192525-1093696331=:45889--