From: | Dinesh Bhandary <dbhandary(at)iii(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Problems with pg_restore (plpgsql already exists) |
Date: | 2012-02-24 23:44:08 |
Message-ID: | 4F4820C8.2000703@iii.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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';
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Weaver | 2012-02-25 03:12:02 | Re: Problems with pg_restore (plpgsql already exists) |
Previous Message | Brian Weaver | 2012-02-24 22:30:58 | Problems with pg_restore (plpgsql already exists) |