| 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: | Whole Thread | Raw Message | 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
| 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 |