Bryan White wrote:
I am trying to load a data base using pg_restore...... Is there a known problem with using parallel loading in 8.4 from a file created with an 8.1 database?
It was unclear from your email how you are creating the dump. Did you create the dump with the 8.1 or the 8.4 version of pg_dump? When upgrading, the docs recommend using the newer version of the dump utility: "It is recommended that you use the pg_dump and pg_dumpall programs from the newer version of PostgreSQL, to take advantage of any enhancements that might have been made in these programs. Current releases of the dump programs can read data from any server version back to 7.0."
How many cores are available on the new server? Cheers, Steve -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
