syntax error at or near "PROCEDURAL" - Mailing list pgsql-general

From Andreas Lau
Subject syntax error at or near "PROCEDURAL"
Date
Msg-id 49AA231E9907E940800FB4281B171F184C93F5@v-x2003.vaberlin.de
Whole thread Raw
Responses Re: syntax error at or near "PROCEDURAL"
List 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.


pgsql-general by date:

Previous
From: Colin Wetherbee
Date:
Subject: Deploying PostgreSQL on virtualized hardware
Next
From: "Alexey A. Nalbat"
Date:
Subject: Re: unnesesary sorting after Merge Full Join