| From: | "Andreas Lau" <Andreas(dot)Lau(at)vaberlin(dot)de> | 
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> | 
| Subject: | syntax error at or near "PROCEDURAL" | 
| Date: | 2008-02-25 17:40:43 | 
| Message-ID: | 49AA231E9907E940800FB4281B171F184C93F5@v-x2003.vaberlin.de | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hello,
 
I try to restore a dump file on a new Database. But unfortunatly i get this error:
 
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 532; 2612 16386 PROCEDURAL LANGUAGE plpgsql postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  syntax error at or near "PROCEDURAL"
LINE 1: ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;
              ^
    Command was: ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;
 
and I don't know how I can avoid it.
 
My steps:
========== 
First dump the current DB (postgres version 8.2.6) with the following command: 
    pg_dump -h v-oracle-4 -p 5432 -UAdministrator -Fc -o -f C:\test2.backup MyDB
 
Second try to restore Dump on another server with postgres 8.2.6 with the folowing command:
    pg_restore.exe -h 192.168.30.107 -p 5432 -UAdministrator -C -e -d Mirror c:\test2.backup 2>c:\t.txt
 
The script stops and the errormessage mentioned above apears in the file. 
 
Do you have any hints why the error appears and how i can sove it? Please help. 
Thanks Andreas 
 
ps:Another hint perhaps: I get a second password prompt after i entered the first one. So i have to insert the password twice.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | D. Dante Lorenso | 2008-02-25 17:49:54 | Cascading Trigger - changing row on delete does not delete row | 
| Previous Message | hernan gonzalez | 2008-02-25 16:52:17 | Re: text and bytea |