PgSqlDump and pg_largeobject

PgSqlDump and pg_largeobject

Postby 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
onish
 
Posts: 13
Joined: Mon 03 May 2010 11:32

Postby 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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Postby 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.
onish
 
Posts: 13
Joined: Mon 03 May 2010 11:32

Postby 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).
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Postby 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
 
Posts: 13
Joined: Mon 03 May 2010 11:32

Postby onish » Wed 09 Jun 2010 10:44

Hi Shalex,

Any inputs on my last reply?

Thanks.
onish
 
Posts: 13
Joined: Mon 03 May 2010 11:32

Postby 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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Postby onish » Fri 11 Jun 2010 07:44

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

Regards.
onish
 
Posts: 13
Joined: Mon 03 May 2010 11:32

Postby onish » Tue 06 Jul 2010 08:08

Hi Guys,

Any update on this feature?

Thanks.
onish
 
Posts: 13
Joined: Mon 03 May 2010 11:32

Postby 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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Postby onish » Sat 10 Jul 2010 11:06

Fantastic, I really appreciate. I had almost lost the hope. Thanks Guys.
onish
 
Posts: 13
Joined: Mon 03 May 2010 11:32

Postby 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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Postby onish » Tue 20 Jul 2010 13:09

Fantastic, I really appreciate your support. Thanks a lot.
onish
 
Posts: 13
Joined: Mon 03 May 2010 11:32

Postby onish » Tue 31 Aug 2010 05:59

Hi Guys,

Any updates on this?
onish
 
Posts: 13
Joined: Mon 03 May 2010 11:32

Postby 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?
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Next

Return to dotConnect for PostgreSQL