Re: Error message during compressed backup

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Senthil Kumar S <ssakkaravel(at)ivesia(dot)com>
Cc: psql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Error message during compressed backup
Date: 2003-10-24 12:31:26
Message-ID: Pine.LNX.4.44.0310241429100.17076-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message scott.marlowe 2003-10-24 16:37:15 Re: Regular expression problem
Previous Message Alexander Vlasenko 2003-10-23 21:00:00 extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax