Home > mailing lists

PG_DUMP - LO PROBLEM - Mailing list pgsql-admin

From	omkar prabhu
Subject	PG_DUMP - LO PROBLEM
Date	January 4, 2004 18:05:38
Msg-id	002601c3cf79$430661b0$a30110ac@OMKAR Whole thread Raw
Responses	Re: PG_DUMP - LO PROBLEM (Karel Zak <zakkr@zf.jcu.cz>)
List	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

From: Mturi Elias
Date: 04 January 2004, 18:05:36
Subject: Data Warehousing

From: Kenny Drobnack
Date: 04 January 2004, 18:05:41
Subject: forcing postgresql 7.3 to use crypt passwords