Home > mailing lists

PG_DUMP - Mailing list pgsql-admin

From	omkar prabhu
Subject	PG_DUMP
Date	January 4, 2004 18:05:33
Msg-id	000201c3cf74$4db995f0$a30110ac@OMKAR Whole thread Raw
Responses	Starting PostgreSQL on FreeBSD (Eimar Koort <eimar@vykk.vil.ee>)
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 restored.

Same i tried to postgres7.2.1 which is compiled and install it works fine.

What could be the problem?

Is there anyway by which i can fixed this problem by using postgres which is installed using rpm

From: Jan Wieck
Date: 04 January 2004, 18:05:32
Subject: Re: [HACKERS] IEEE 754

From: Grega Bremec
Date: 04 January 2004, 18:05:34
Subject: Re: ERD tool for postgres?