Problem with PgSqlDump DumpMode.Data

Problem with PgSqlDump DumpMode.Data

Postby blurble » Wed 10 Nov 2010 21:54

I'm using PgSqlDump to dump out my DB to a file. If I use DumpMode.All (or don't specify the DumpMode) then it all works fine. The code I use is like this:

Code: Select all
using (PgSqlDump pgSqlDump = new PgSqlDump())
   pgSqlDump.Connection = connection;
   pgSqlDump.Tables = tableList;
   pgSqlDump.IncludeBlob = true;
   pgSqlDump.IncludeUsers = false;
   pgSqlDump.IncludeDrop = false;
   pgSqlDump.Backup(Path.Combine(saveFolder, "script.backup"));

and I get a complete script containing the table creation statements and the data.

However, if I want to dump out just the data I add

Code: Select all
pgSqlDump.Mode = DumpMode.Data;

but then the output script always only contains the following:

Code: Select all
-- dotConnect for PostgreSQL
-- Server version: PostgreSQL 8.3.9 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.3-5ubuntu4) 4.3.3
-- Script date 11/11/2010 10:15:10 a.m.
-- Server:
-- Database: conductor

SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET default_tablespace = '';
SET default_with_oids = false;

Is there anything I am doing wrong, or is this a bug? I am currently using v4.65.79, but would upgrade to a newer version if I know that this problem is fixed.

Posts: 5
Joined: Wed 17 Jun 2009 04:54

Postby StanislavK » Fri 12 Nov 2010 17:29

Apparently, this is an error fixed in newer builds. I've reproduced this problem with the 4.65.79 version, but couldn't with the latest 5.0.46 Beta build. Please try dotConnect for PostgreSQL Beta 5.0. You can download it from
(the trial version) or from Registered Users' Area (provided that you have an active subscription):
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby blurble » Fri 12 Nov 2010 21:05

Thanks for the info. I will give the newer version a go.
Posts: 5
Joined: Wed 17 Jun 2009 04:54

Return to dotConnect for PostgreSQL