pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedError message during compressed backup
6+ messages / 4 participants
[nested] [flat]
* Error message during compressed backup
@ 2003-10-23 09:19 Senthil Kumar S <ssakkaravel@ivesia.com>
2003-10-24 12:31 ` Re: Error message during compressed backup Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Senthil Kumar S @ 2003-10-23 09:19 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error message during compressed backup
2003-10-23 09:19 Error message during compressed backup Senthil Kumar S <ssakkaravel@ivesia.com>
@ 2003-10-24 12:31 ` Peter Eisentraut <peter_e@gmx.net>
2003-10-28 08:54 ` Re: Error message during compressed backup Senthil Kumar S <ssakkaravel@ivesia.com>
2003-10-28 09:15 ` Re: Error message during compressed backup Kumar <sgnerd@yahoo.com.sg>
0 siblings, 2 replies; 6+ messages in thread
From: Peter Eisentraut @ 2003-10-24 12:31 UTC (permalink / raw)
To: Senthil Kumar S <ssakkaravel@ivesia.com>; +Cc: 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error message during compressed backup
2003-10-23 09:19 Error message during compressed backup Senthil Kumar S <ssakkaravel@ivesia.com>
2003-10-24 12:31 ` Re: Error message during compressed backup Peter Eisentraut <peter_e@gmx.net>
@ 2003-10-28 08:54 ` Senthil Kumar S <ssakkaravel@ivesia.com>
1 sibling, 0 replies; 6+ messages in thread
From: Senthil Kumar S @ 2003-10-28 08:54 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-sql
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error message during compressed backup
2003-10-23 09:19 Error message during compressed backup Senthil Kumar S <ssakkaravel@ivesia.com>
2003-10-24 12:31 ` Re: Error message during compressed backup Peter Eisentraut <peter_e@gmx.net>
@ 2003-10-28 09:15 ` Kumar <sgnerd@yahoo.com.sg>
1 sibling, 0 replies; 6+ messages in thread
From: Kumar @ 2003-10-28 09:15 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-sql
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Fw: Error message during compressed backup
@ 2003-10-23 09:57 Kumar <sgnerd@yahoo.com.sg>
2003-10-23 11:25 ` Re: Fw: Error message during compressed backup Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 6+ messages in thread
From: Kumar @ 2003-10-23 09:57 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fw: Error message during compressed backup
2003-10-23 09:57 Fw: Error message during compressed backup Kumar <sgnerd@yahoo.com.sg>
@ 2003-10-23 11:25 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 6+ messages in thread
From: Richard Huxton @ 2003-10-23 11:25 UTC (permalink / raw)
To: Kumar <sgnerd@yahoo.com.sg>; pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2003-10-28 09:15 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-23 09:19 Error message during compressed backup Senthil Kumar S <ssakkaravel@ivesia.com>
2003-10-24 12:31 ` Peter Eisentraut <peter_e@gmx.net>
2003-10-28 08:54 ` Senthil Kumar S <ssakkaravel@ivesia.com>
2003-10-28 09:15 ` Kumar <sgnerd@yahoo.com.sg>
2003-10-23 09:57 Fw: Error message during compressed backup Kumar <sgnerd@yahoo.com.sg>
2003-10-23 11:25 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox