Re: Fw: Error message during compressed backup

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>, "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Fw: Error message during compressed backup
Date: 2003-10-23 11:25:23
Message-ID: 200310231225.23602.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thursday 23 October 2003 10:57, Kumar wrote:
> Dear Friends,
>
> While doing compressed backup for one of the database running at Postgres
> Server 7.3.4 on RH Linux 7.2, I got the following error., but it backup
> other items
>
> --Command to backup
> $ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v testdb -f
> /home/db_repository/testdb20031023.sql.tar.gz -u -F c
>
> --Error msg
> WARNING: owner of function "plpgsql_call_handler" appears to be invalid

In psql, do:
\df+ plpgsql*

This will show you the owner (among other details) - it should probably be
"postgres".

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message ext-thierry.templier 2003-10-23 11:37:26 Left outer join and sub queries alias
Previous Message Kumar 2003-10-23 09:57:26 Fw: Error message during compressed backup