Re: Error message during compressed backup

Senthil Kumar S writes:

> $ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v testdb -f /home/db_repository/testdb20031023.sql.tar.gz -u -F c

> WARNING: owner of function "plpgsql_call_handler" appears to be invalid

Run

select proowner from pg_proc where proname = 'plpgsql_call_handler';

which gives you the ID of the user that owns this function.  Then run

select * from pg_user;

to get the list of valid users.  You may want to adjust the owner of the
function to a valid user (use UPDATE).

-- 
Peter Eisentraut   peter_e@gmx.net