error in pgsqldumb class to restore large object

shilpa24 · Post by **shilpa24** » Mon 06 Jun 2011 11:17

hi,
i am using pgsqldump class to backup and restore my postgre database
using method backup and restore but when i restore large object (some what 46MB in size) i got the exception
"Exception of type 'System.OutOfMemoryException' was thrown."
while creting backup file i had made IncludeBlob = true

for backup i had write this code

Dim pgdumb As New PgSqlDump
pgdumb.Connection = Connection
pgdumb.Mode = Devart.Data.PostgreSql.DumpMode.Data
pgdumb.IncludeBlob = True
pgdumb.Backup("D:\testbackup.backup")
Connection.Close()

for restore
Dim pgDump As PgSqlDump = New PgSqlDump
pgDump.Connection = conn
pgDump.Restore("D:\testbackup.backup")
conn.close

ANY SuGESSTION PLZ HELP

[/code]

Shalex · Post by **Shalex** » Wed 08 Jun 2011 09:29

We have reproduced the problem. We will investigate it and notify you about the results as soon as possible.

shilpa24 · Post by **shilpa24** » Thu 09 Jun 2011 04:36

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

shilpa24 · Post by **shilpa24** » Sat 11 Jun 2011 06:03

hello shalex,
i had check this backup and restore method on two different pc (with file of size 300 mb in my database ) of same configuration (2 GB RAM,250 GB Hard Drive,os windows 7 ) ,
error remains same (out of memory) but two different size backup file created ,
on one pc error appears after 460mb backup file created and in another it appear after 14 mb backup file created , and this time error appears on backup method of pgsqldump class.

Any update from ur side on this issue

Shalex · Post by **Shalex** » Thu 16 Jun 2011 13:17

We have reproduced System.OutOfMemoryException with both Backup() and Restore() methods of the PgSqlDump class. We will investigate the problem and notify you about the results as soon as possible.

shilpa24 · Post by **shilpa24** » Wed 29 Jun 2011 07:51

Hi,

Any update on this issue ?

Shalex · Post by **Shalex** » Mon 04 Jul 2011 11:58

We are investigating the problem.

shilpa24 · Post by **shilpa24** » Wed 27 Jul 2011 10:32

hi shalex ,
is there any hope that this issue will get solved, my poject is getting delayed only for this issue. i hope that i get positive response from your side as soon as possible

Shalex · Post by **Shalex** » Thu 28 Jul 2011 15:54

We have implemented the PgSqlDump.BlockSize property to control the size of data block when making dump of a large object. This allows to avoid System.OutOfMemoryException because a particular "SELECT lowrite(...)" for a big "large object" will be divided into several "SELECT lowrite(...)" commands depending on the value of PgSqlDump.BlockSize. The feature will be included in the next public build of dotConnect for Postgresql (in 2-3 weeks). Is this timeframe suitable for you?

shilpa24 · Post by **shilpa24** » Fri 29 Jul 2011 05:14

hi shalex,
This issue is important and urgent for me ,but i truly appreciate your efforts ,so i will wait for your next release, hopping that your next build get release as early as possible

Shalex · Post by **Shalex** » Fri 12 Aug 2011 14:25

New build of dotConnect for PostgreSQL 5.30.202 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ . For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21729 .

This build includes the PgSqlDump.BlockSize property. We recommend you to dump data directly to the file PgSqlDump.Backup(string fileName) (not to PgSqlDump.DumpText) because this can be the reason of System.OutOfMemoryException. Also set the "Default Command Timeout=0;" connection string parameter - lo_unlink can take a lot of time.

shilpa24 · Post by **shilpa24** » Thu 15 Sep 2011 11:27

Hi shalex ,
Thanxs for you efforts we have registered version of dotConnect for PostgreSQL 4.95.152 and you provide this PgSqlDump.BlockSize property in version 5.30.202 so if we upgrade our license version ,will we able to use this property in upgraded version or not

Shilpa Mehta

Shalex · Post by **Shalex** » Thu 15 Sep 2011 11:36

The PgSqlDump.BlockSize property is available in 5.30.202 and higher versions of dotConnect for PostgreSQL. Please contact our Sales department (sales at devart*com) to check your subscription status.