PG_DUMP

From: "omkar prabhu" <oprabhu(at)phildigital(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: PG_DUMP
Date: 2003-12-31 08:01:18
Message-ID: 000201c3cf74$4db995f0$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 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message omkar prabhu 2003-12-31 08:37:01 PG_DUMP - LO PROBLEM
Previous Message vidhya 2003-12-31 05:32:06 Fw: FTP