Re: Error message during compressed backup - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Error message during compressed backup
Date
Msg-id Pine.LNX.4.44.0310241429100.17076-100000@peter.localdomain
Whole thread Raw
In response to Error message during compressed backup  ("Senthil Kumar S" <ssakkaravel@ivesia.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: yusuf0478@netscape.net
Date:
Subject: Re: Query Help
Next
From: Manuel Sugawara
Date:
Subject: Re: Regular expression problem