PgSqlDump and pg_largeobject

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
onish
Posts: 13
Joined: Mon 03 May 2010 11:32

PgSqlDump and pg_largeobject

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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

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

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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

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

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

Post by onish » Wed 09 Jun 2010 10:44

Hi Shalex,

Any inputs on my last reply?

Thanks.

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

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

Post by 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

Post by onish » Tue 06 Jul 2010 08:08

Hi Guys,

Any update on this feature?

Thanks.

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

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

Post by onish » Sat 10 Jul 2010 11:06

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

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

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

Post by 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

Post by onish » Tue 31 Aug 2010 05:59

Hi Guys,

Any updates on this?

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

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?

Post Reply