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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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