Thread: Error message during compressed backup

Error message during compressed backup

From
"Senthil Kumar S"
Date:
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: Error message during compressed backup

From
Peter Eisentraut
Date:
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



Re: Error message during compressed backup

From
"Kumar"
Date:
Hi Peter Eisentraut,

>>select proowner from pg_proc where proname = 'plpgsql_call_handler';
It gives me an id '101'

While I search for the users in the pg_user, there is no user of id 101
select * from pg_user where usesysid = 101;
No result was fetched.

While I search this way   select * from pg_user where usename like 'postgres'
This give me a result username = postgres usesysid = 1

In comments you said
>> You may want to adjust the owner of the function to a valid user (use
UPDATE).
Do u mean I need to update the table pg_proc, with the following statement   UPDATE pg_proc SET proowner = 1 where
proname= 'plpgsql_call_handler';
 

I am asking this because to ensure not any wrong impact gets into the live
database. Pls advise.

Regards
Kumar
----- Original Message ----- 
From: "Peter Eisentraut" <peter_e@gmx.net>
To: "Senthil Kumar S" <ssakkaravel@ivesia.com>
Cc: "psql" <pgsql-sql@postgresql.org>
Sent: Friday, October 24, 2003 6:01 PM
Subject: Re: [SQL] 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
>



Re: Error message during compressed backup

From
"Senthil Kumar S"
Date:
Hi Peter Eisentraut,

>>select proowner from pg_proc where proname = 'plpgsql_call_handler';
It gives me an id '101'

While I search for the users in the pg_user, there is no user of id 101
select * from pg_user where usesysid = 101;
No result was fetched.

While I search this way   select * from pg_user where usename like 'postgres'
This give me a result username = postgres usesysid = 1

In comments you said
>> You may want to adjust the owner of the function to a valid user (use
UPDATE).
Do u mean I need to update the table pg_proc, with the following statement   UPDATE pg_proc SET proowner = 1 where
proname= 'plpgsql_call_handler';
 

I am asking this because to ensure not any wrong impact gets into the live
database. Pls advise.

Regards
Kumar

----- Original Message ----- 
From: "Peter Eisentraut" <peter_e@gmx.net>
To: "Senthil Kumar S" <ssakkaravel@ivesia.com>
Cc: "psql" <pgsql-sql@postgresql.org>
Sent: Friday, October 24, 2003 6:01 PM
Subject: Re: [SQL] 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
>