PG_DUMP - LO PROBLEM

From: "omkar prabhu" <oprabhu(at)phildigital(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: PG_DUMP - LO PROBLEM
Date: 2003-12-31 08:37:01
Message-ID: 002601c3cf79$430661b0$a30110ac@OMKAR
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Phillip Harrington 2003-12-31 09:07:11 Re: service postgresql start Fails, Can't su
Previous Message omkar prabhu 2003-12-31 08:01:18 PG_DUMP