From: | "Kuhn, Dylan K (4520500D)" <Dylan(dot)Kuhn(at)navy(dot)mil> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | problems with pg_restore |
Date: | 2003-07-15 14:55:21 |
Message-ID: | 78ED1F30F0D85B4698FBD6CF2A5AC8F5A576F9@NAWECHLKEX01VA.nadsuswe.nads.navy.mil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
I have a 200GB archive I created like this:
% pg_dump -f db1.pga -Fc -b db1
To check that it is good, I tried to restore to another database:
% pg_restore -d db2 db1.pga
[...quickly restores sequences, then...]
pg_restore: [archiver (db)] could not execute query: ERROR: function plpgsql_call_handler already exists with same argument types
Ok, I had installed PLPGSQL in template1, which has been useful in other situations. I drop db2, recreate it, and drop the PLPGSQL language and call handler, then try again:
% pg_restore -d db2 db1.pga
[...restores seqs, tables, keys, then spends several quiet hours (on blobs I assume)...]
pg_restore: [archiver (db)] could not execute query: ERROR: Database comments may only be applied to the current database
I'm not sure how to get around this one. Can an archived database with comments be restored to a database with a different name? Are the comments the only thing missing from the restored database, or could there be other things?
thanks,
Dylan Kuhn
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-15 16:26:29 | Re: problems with pg_restore |
Previous Message | Nigel Bishop | 2003-07-15 14:21:04 | Installing plpgsql gives error |
From | Date | Subject | |
---|---|---|---|
Next Message | Samuel A Horwitz | 2003-07-15 15:20:17 | CVS compile on AIX 4.3.2 |
Previous Message | Wang Mike | 2003-07-15 13:25:19 | clock_timestamp() and transcation_timestamp() patch |