Records are missing from backup or restore

Records are missing from backup or restore

Postby bbmu2000 » Tue 30 Nov 2010 22:48

The database have following several tables.

There are 29547 rows in DeviceData table.

I used following code to backup the database.

using( PgSqlConnection conn = new PgSqlConnection( ConnectionStringBuilder.ConnectionString ) )
{
conn.Open();
PgSqlDump pgSqlDump = new PgSqlDump();
pgSqlDump.Connection = conn;
pgSqlDump.IncludeDrop = true;
pgSqlDump.Mode = DumpMode.All;
pgSqlDump.Backup( @"C:\backup.bak");
}

The process succeeded, and the backup file size is 67.4Mb

After that I create an empty database, and used following code to restore

using( PgSqlConnection conn = new PgSqlConnection( ConnectionStringBuilder.ConnectionString ) )
{
conn.Open();
PgSqlDump pgSqlDump = new PgSqlDump();
pgSqlDump.Connection = conn;
pgSqlDump.Mode = DumpMode.All;
pgSqlDump.Restore( @"C:\backup.bak" );
}

The restore process succeeded, but there are only 2563 rows in the DeviceData Table.

Any ideas? Thanks.
bbmu2000
 
Posts: 3
Joined: Tue 30 Nov 2010 00:21

Postby StanislavK » Thu 02 Dec 2010 17:17

Please specify the version of dotConnect for PostgreSQL you are using. I've tried backing up a database of similar size with the latest 5.0.58 version, and couldn't reproduce the issue.

If possible, please send us ( support * devart * com ) a backup (please create it with a standard tool like PgAdmin) of the database with which the problem can be reproduced. In this case, please also notify us here.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for PostgreSQL