Thread: Fw: Error message during compressed backup

Fw: Error message during compressed backup

From

"Kumar"

Date:

23 October 2003, 09:52:56

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

Could anyone tell me why I am getting this. I could able to do normal back and restore.

Please shed some light.

Regards

Kumar

Re: Fw: Error message during compressed backup

From

Richard Huxton

Date:

23 October 2003, 11:25:59

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