Could Not Execute Query Error Language Plpgsql Already Exists
Contents |
| Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ ERROR IN RESTORE DATABASE I made a backup of my database and a restore in pg_restore error from toc entry relation does not exist a different PC and I am getting the following error message: Â pg_restore:
Pg_restore Error While Processing Toc
[archiver (db)] Error while PROCESSING TOC:pg_restore: [archiver (db)] Error from TOC entry 369; 2612 16386 PROCEDURAL LANGUAGE plpgsql postgrespg_restore: [archiver (db)] pg_restore error relation does not exist could not execute query: ERROR: language "plpgsql" already exists    Command was: CREATE PROCEDURAL LANGUAGE plpgsql;  When I open the restored database I can see all of the objects in it: schema,
Could Not Execute Query: Error: Relation Does Not Exist
tables, keys, etc. so I do not know what this error means; it seems that everything is fine. I will appreciate any advice. Â With respect, Jorge Maldonado Sean Davis Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: ERROR IN RESTORE DATABASE On Tue, Jun 2, 2009 at 12:18 PM, JORGE MALDONADO <[hidden email]> wrote: pg_restore: [archiver (db)] could not execute query: error: must be owner of extension plpgsql > I made a backup of my database and a restore in a different PC and I am > getting the following error message: > > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 369; 2612 16386 PROCEDURAL > LANGUAGE plpgsql postgres > pg_restore: [archiver (db)] could not execute query: ERROR:Â language > "plpgsql" already exists > Â Â Â Command was: CREATE PROCEDURAL LANGUAGE plpgsql; > > When I open the restored database I can see all of the objects in it: > schema, tables, keys, etc. so I do not know what this error means; it seems > that everything is fine. I will appreciate any advice. It looks like the database to which you restored already had plpgsql in place. The error just states that. So, I don't think there is any problem and you can assume that you got your database restored. Sean -- Sent via pgsql-novice mailing list ([hidden email]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice Alan Hodgson Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: ERROR IN RESTORE DATABASE In reply to this post by J
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations
Could Not Execute Query Error Role Does Not Exist
User groups Project lists Inactive lists IRC Local User
Command Was: Comment On Extension Plpgsql Is 'pl/pgsql Procedural Language';
Groups Featured Users International Sites Propaganda Resources Weekly News Re: pg_restore issue From: Jerry pg_dump Sievers
hour [ DST ]
Buster No Limit Leak Buster Limit Leak Buster Pot Limit Omaha HM Cloud Register Help Remember Me? What's New? Forum New Posts FAQ Calendar Community Member List Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders Advanced Search Forum Holdem Manager 1.0 Manager General Database restore fault errors Results 1 to 2 of 2 Thread: Database restore fault errors Thread Tools Show Printable Version Email this Page… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-24-2010,07:19 AM #1 Beffa Junior Member Join Date Sep 2008 Posts 18 Database restore fault errors I get these errors when trying to restore my database, this is some of it: pg_restore: kopplar upp mot databas för återställning pg_restore: skapar SCHEMA public pg_restore: skapar COMMENT SCHEMA public pg_restore: skapar PROCEDURAL LANGUAGE plpgsql pg_restore: [arkiverare (db)] Fel vid HANTERING AV TOC: pg_restore: [arkiverare (db)] Fel på TOC-post 432; 2612 16386 PROCEDURAL LANGUAGE plpgsql postgres pg_restore: [arkiverare (db)] could not execute query: ERROR: language "plpgsql" already exists Command was: CREATE PROCEDURAL LANGUAGE plpgsql; pg_restore: skapar TYPE responetype3_month_response pg_restore: [arkiverare (db)] Fel på TOC-post 430; 1247 221230 TYPE responetype3_month_response postgres pg_restore: [arkiverare (db)] could not execute query: ERROR: relation "responetype3_month_response" already exists Command was: CREATE TYPE responetype3_month_response AS ( player_id integer, compiledplayerresults_id integer, totalplayedhands intege... pg_restore: skapar TYPE responetype3_response pg_restore: [arkiverare (db)] Fel på TOC-post 428; 1247 221226 TYPE responetype3_response postgres pg_restore: [arkiverare (db)] could not execute query: ERROR: relation "responetype3_response" already exists Command was: CREATE TYPE responetype3_response AS ( player_id integer, compiledplayerresults_id integer, totalplayedhands smallint ); pg_restore: skapar FUNCTION getmatchingcompiledplayerresults(integer, integer, timestamp without time zone, timestamp without time zone, integer[]) pg_restore: [arkiverare (db)] Fel på TOC-post 20; 1255 221227 FUNCTION getmatchingcompiledplayerresults(integer, integer, timestamp without time zone, timestamp without time zone, integer[]) postgres pg_restore: [arkiverare (db)] could not execute query: ERR