Re: Fw: Error message during compressed backup - Mailing list 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