Postgres Pro
Downloads
Home   >   mailing lists

Problem with restoring a 7.1 dump - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Problem with restoring a 7.1 dump
Date
Msg-id GNELIHDDFBOCMGBFGEFOCEGFCCAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: Problem with restoring a 7.1 dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Hi all,

I'm having problems restoring a dump.  I get this:

You are now connected as new user chriskl.
ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.       Pre-installed languages are SQL, C, and
internal.      Additional languages may be installed using 'createlang'.
 
ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.       Pre-installed languages are SQL, C, and
internal.      Additional languages may be installed using 'createlang'.
 

I've done a "createlang plpgsql template1" before starting my restore, but I
just cannot get it to recognise the language.

The dump format is the complete one that first tries to drop each database
and then recreates it from scratch, so each of my databases is being dropped
and then totally recreated.

How do I get this to work?

Chris

pgsql-hackers by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [INTERFACES] Schemas: status report, call for developers
Next
From: "Magnus Naeslund(f)"
Date:
Subject: Re: Problem with restoring a 7.1 dump