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?
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
In response to
pgsql-admin by date
|Next:||From: Greg Sabino Mullane||Date: 2004-08-28 14:28:16|
|Subject: Re: Compatibility between different versions of psql client and postgresql server|
|Previous:||From: Gaetano Mendola||Date: 2004-08-28 10:21:33|
|Subject: Re: vacuum pg_attribute causes high load|