PgSqlDump and pg_largeobject

onish · Post by **onish** » Wed 02 Jun 2010 07:23

Hi Guys,

How can I dump the blob values stored in pg_largeobject sytem table using PgSqlDump Class? and restore the same.

Thanks,

OnisH

Shalex · Post by **Shalex** » Wed 02 Jun 2010 18:10

The PgSqlDump class includes the IncludeBlob property that allows to include field values of ByteA type into database dump. Have you tried using this property? Please describe the problem.

onish · Post by **onish** » Wed 02 Jun 2010 19:31

Hi,

Yes, I did tried after setting IncludeBlob to True but I am trying to dump the large objects which are stored in a system table named pg_largeobject.

Using IncludeBlob will dump only the data of type bytea? or will it also go to the system table "pg_largeobject" and dump the data from it?

I hope I was able to explain the scenario. Thanks.

Shalex · Post by **Shalex** » Thu 03 Jun 2010 15:24

PgSqlDump with enabled IncludeBlob works only with the data of type bytea. We will investigate the possibility of implementing the PgSqlDump support for PostgreSQL large objects. Currently, the PgSqlLargeObject class is available (it represents a PostgreSQL large object).

onish · Post by **onish** » Fri 04 Jun 2010 06:17

Hi,

Currently I am using PgSqlLargeObject class to save large objects to database, which works great by the way, but now I would also like to backup the same data, the large objects i.e.

It would be great if PgDump supports Large Object too, or please let me know if I can achieve this using some other way.

Thanks.

onish · Post by **onish** » Wed 09 Jun 2010 10:44

Hi Shalex,

Any inputs on my last reply?

Thanks.

Shalex · Post by **Shalex** » Thu 10 Jun 2010 15:12

We are investigating the possibility of implementing the PgSqlDump support for PostgreSQL large objects. Currently only manual retrieving and writing separate PostgreSQL large objects with PgSqlLargeObject is possible.

onish · Post by **onish** » Fri 11 Jun 2010 07:44

Understood, Thanks for your effort. I will be waiting for the update.

Regards.

onish · Post by **onish** » Tue 06 Jul 2010 08:08

Hi Guys,

Any update on this feature?

Thanks.

Shalex · Post by **Shalex** » Wed 07 Jul 2010 09:12

We are working on this feature. We plan to add this functionality in a month or so. I will post here when it is available.

onish · Post by **onish** » Sat 10 Jul 2010 11:06

Fantastic, I really appreciate. I had almost lost the hope. Thanks Guys.

Shalex · Post by **Shalex** » Tue 13 Jul 2010 16:16

We have implemented support for PgSqlLargeObject in PgSqlDump. I will post here when the corresponding build is available.

onish · Post by **onish** » Tue 20 Jul 2010 13:09

Fantastic, I really appreciate your support. Thanks a lot.

onish · Post by **onish** » Tue 31 Aug 2010 05:59

Hi Guys,

Any updates on this?

Shalex · Post by **Shalex** » Tue 31 Aug 2010 15:51

Support for PgSqlLargeObject in PgSqlDump is available in the 4.95.152 and 5.0.10 versions. Please refer to the updated documentation on this property. But we are still working on it. Please give us your feedback. What should be changed or improved from your point of view?