Thread: PG_DUMP - LO PROBLEM

PG_DUMP - LO PROBLEM

From
"omkar prabhu"
Date:
Hi,
 
 
I am trying to dump large object data( from a database containing table consist of 4 lo fields)
I get following error.
I am using postgres 7.2.1 which is installed from rpm
Command use is
   pg_dump -Ft -b test1 > db.tar
 
I get following message
pg_dump: WARNING: function "lo_oid" not dumped
pg_dump: reason: data type name of argument 0 (oid 16584) not found
 
 
 
When i try restore using pg_restore
Blob data is not restored.
 
 
What could be the problem?
Is there anyway by which i can fixed this problem by using postgres which is installed using source code compiling
 
 
Regards
Omkar Prabhu

Re: PG_DUMP - LO PROBLEM

From
Karel Zak
Date:
On Wed, Dec 31, 2003 at 02:07:01PM +0530, omkar prabhu wrote:
> Hi,
>
>
> I am trying to dump large object data( from a database containing table consist of 4 lo fields)
> I get following error.
> I am using postgres 7.2.1 which is installed from rpm
> Command use is
>    pg_dump -Ft -b test1 > db.tar
>
> I get following message
> pg_dump: WARNING: function "lo_oid" not dumped
> pg_dump: reason: data type name of argument 0 (oid 16584) not found

 See and try the "pg_dumplo" from contrib tree. Maybe it help you.

    Karel


--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/