Skip site navigation (1) Skip section navigation (2)

PostgreSQL v9.0.3 Database Import Error: language "plpgsql" already exists

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL v9.0.3 Database Import Error: language "plpgsql" already exists
Date: 2011-03-30 13:44:33
Message-ID: 007201cbeee0$9c9d9890$d5d8c9b0$@com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

We're planning to upgrade our PostgreSQL database from v8.2.3 to v9.0.3.
Before upgrading our Production server, we're trying out this complete
upgrade process in a separate database server that is just exactly the
replica of the production server.

I already took a dump of our database using pg_dump command in v8.2.3:
"/usr/local/pgsql/bin/pg_dump -D -f dbdump.sql -S mydbuser mydb"

Now, after upgrading PostgreSQL to v9.0.3, I'm trying to import the database
dump using: "psql -f dbdump.sql -o dbdump.log -d mydb -U mydbuser".  I'm
getting the following errors while importing:

psql:dbdump.sql:38: ERROR:  language "plpgsql" already exists
psql:dbdump.sql:102646: ERROR:  attempt to redefine parameter
"plpgsql.variable_conflict"
psql:dbdump.sql:102649: ERROR:  function public.plpgsql_call_handler() does
not exist

I also read from 9.0 release notes that PL/pgSQL is now installed by
default.
http://www.postgresql.org/docs/current/interactive/release-9-0.html 

My question is, how do I prevent/fix this error during import.  Are all
these 3 errors one and the same or are they different errors that each has
to be fixed separately?

NOTE: We've multiple onsite customer servers that has to be upgraded to
v9.0.3, hence I need to address this issue in general.

Regards,
Gnanam


Responses

pgsql-admin by date

Next:From: Achilleas MantziosDate: 2011-03-30 14:12:48
Subject: Re: PostgreSQL v9.0.3 Database Import Error: language "plpgsql" already exists
Previous:From: Igor NeymanDate: 2011-03-30 13:40:20
Subject: Re: odbc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group