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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
