Devart.Data.PostgreSql version: 7.4.543.0
dotConnect for PostgreSQL Professional version: 7.4.543.0
PostgreSQL version: 10.3
Backup code:
Code: Select all
using (var conn = new PgSqlConnection(connectionstring))
{
conn.Open();
var pgSqlDump = new PgSqlDump
{
Connection = conn
};
pgSqlDump.ObjectTypes |= PgSqlDumpObjects.Views;
pgSqlDump.Backup(stream);
conn.Close();
}
Restore code:
Code: Select all
using (var conn = new PgSqlConnection(connectionString))
{
conn.Open();
var pgSqlDump = new PgSqlDump
{
Connection = conn
};
pgSqlDump.Restore(fileName);
conn.Close();
}
Stack trace:
Code: Select all
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Devart.Data.PostgreSql.PgSqlDataReader.f(Int32 A_0)
at Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteNonQuery()
at Devart.Common.DbScript.ExecuteSqlStatement(SqlStatement sqlStatement, Boolean forceExecute)
at Devart.Common.DbScript.a(SqlStatement A_0, Boolean A_1)
at Devart.Common.DbScript.a(Boolean A_0, IDataReader& A_1)
at Devart.Common.DbScript.Execute()
at Devart.Data.PostgreSql.PgSqlDump.InternalRestore(TextReader reader)
at Devart.Common.DbDump.b(String A_0)
at Devart.Common.DbDump.Restore(String fileName)
at PostgreSQLExpImp.MakeImport(String fileName, String database, String connectionString) in ...
An exception occurs during recovery database. Any suggestions how to fix this? Thanks.