From: Dinesh Bhandary <dbhandary@iii.com>
To: pgsql-admin@postgresql.org
Subject: Re: Problems with pg_restore (plpgsql already exists)
Date: Fri, 24 Feb 2012 15:44:08 -0800
Message-ID: <4F4820C8.2000703@iii.com> (raw)
In-Reply-To: <EB254343-461B-4B6B-93A1-3065BA902CF3@gmail.com>
References: <EB254343-461B-4B6B-93A1-3065BA902CF3@gmail.com>
one way to get over this issue is to do pg_dump of postgres 8.4 db
using postgres 9.1.2 binaries.
Here is a note from postgres 9.1.2 documentation
"In a default PostgreSQL installation, the handler for the PL/pgSQL
language is built and installed into the "library" directory;
furthermore, the PL/pgSQL language itself is installed in all databases.
If Tcl support is configured in, the handlers for PL/Tcl and PL/TclU are
built and installed in the library directory, but the language itself is
not installed in any database by default. Likewise, the PL/Perl and
PL/PerlU handlers are built and installed if Perl support is configured,
and the PL/PythonU handler is installed if Python support is configured,
but these languages are not installed by default."
hope this helps.
Thanks.
Dinesh
On 2/24/2012 2:30 PM, Brian Weaver wrote:
> CREATE DATABASE foo WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dbhandary@iii.com
Subject: Re: Problems with pg_restore (plpgsql already exists)
In-Reply-To: <4F4820C8.2000703@iii.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox