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

RE: pg_dump & pg_dumpall problem.

From: Jeff Eckermann <jeckermann(at)verio(dot)net>
To: 'Luis Magaña' <joe666(at)gnovus(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: RE: pg_dump & pg_dumpall problem.
Date: 2001-05-31 22:58:01
Message-ID: 08CD1781F85AD4118E0800A0C9B8580B094ACC@NEZU (view raw or flat)
Thread:
Lists: pgsql-general
I was bitten by the same problem recently.  It means that the owner of the
pgsql call handler no longer exists.  To find out the id of the owner, do a
select like:
select * from pg_proc where proname like 'plpg%';
Then create a user having that id.  You may need to edit pg_shadow to get
the desired result.

> -----Original Message-----
> From:	Luis Magaña [SMTP:joe666(at)gnovus(dot)com]
> Sent:	Thursday, May 31, 2001 12:26 PM
> To:	pgsql-hackers(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
> Subject:	[GENERAL] pg_dump & pg_dumpall problem.
> 
> Hi there:
> 
> Would like to know how to fix this:
> 
> Everytime I do a pg_dump or pg_dumpall I get this error message:
> 
> dumpProcLangs(): handler procedure for language plpgsql not found
> 
> Any help would be appreciated.
> 
> Thank you in advanced.
> --
> Ing. Luis Magaña
> Gnovus Networks & Software
> www.gnovus.com
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

pgsql-general by date

Next:From: Steve WolfeDate: 2001-05-31 23:04:05
Subject: Re: Compiling to RPM setup/filesystem layout
Previous:From: Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=Date: 2001-05-31 22:42:14
Subject: Re: Compiling to RPM setup/filesystem layout

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