PG_DUMP - LO PROBLEM

Поиск
Список
Период
Сортировка
Искать

PG_DUMP - LO PROBLEM

От:
"omkar prabhu" <oprabhu@phildigital.com>
Дата:
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

От:
Karel Zak <zakkr@zf.jcu.cz>
Дата:
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  
 http://home.zf.jcu.cz/~zakkr/
FAQ