dotConnect for PostgreSQL 7.10 : PgSqlDump not work anymore !

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Feneck91
Posts: 50
Joined: Mon 12 Aug 2013 13:52

dotConnect for PostgreSQL 7.10 : PgSqlDump not work anymore !

Post by Feneck91 » Wed 22 Nov 2017 13:23

I use PgSqlDump.Backup function to backup the database. Before this latest version, I could write a database backup, now all entries are empty : PgSqlDump.Backup function will not work anymore with version dotConnect for PostgreSQL 7.10
-- dotConnect for PostgreSQL 7.10.1013.0
-- Server version: PostgreSQL 9.5.2, compiled by Visual C++ build 1800, 64-bit
-- Script date 22/11/2017 14:17:44
-- Server: W267153
-- Database: postgis_geomaps

SET client_encoding = 'UTF8';
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;

CREATE TABLE public."DMGeneral"
(
"GeneralID" bigint,
"SchemaVersion" smallint NOT NULL,
"DataVersion" smallint NOT NULL,
"DataManagerLatestVersion" text NOT NULL,
"MinimalVersionDataManagerForSchema" text NOT NULL
);

INSERT INTO public."DMGeneral" VALUES ();

CREATE TABLE public."DMVerificationConfiguration"
(
"VerificationConfigurationID" bigint,
"MD5" text NOT NULL
);

INSERT INTO public."DMVerificationConfiguration" VALUES ();

CREATE TABLE public.spatial_ref_sys
(
srid integer,
auth_name varchar(256),
auth_srid integer,
srtext varchar(2048),
proj4text varchar(2048)
);

INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();
.... more lines
NSERT INTO public.spatial_ref_sys VALUES ();
INSERT INTO public.spatial_ref_sys VALUES ();

CREATE TABLE public."DMFamille"
(
"FamilleID" bigint,
"Type" smallint NOT NULL,
"NomCourt" varchar(32) NOT NULL,
"NomLong" varchar(64) NOT NULL,
"Tag" varchar(32) NOT NULL,
"ExcelContentString" varchar(1024) NOT NULL
);

INSERT INTO public."DMFamille" VALUES ();
INSERT INTO public."DMFamille" VALUES ();
INSERT INTO public."DMFamille" VALUES ();
INSERT INTO public."DMFamille" VALUES ();
INSERT INTO public."DMFamille" VALUES ();
.... more lines
I
I cut some piece of same lines with ".... more lines" but the backup file has this look !
No way to backup a database with this version now !

A problem with the backup for this version ?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: dotConnect for PostgreSQL 7.10 : PgSqlDump not work anymore !

Post by Pinturiccio » Mon 27 Nov 2017 16:29

There is an issue with empty insert statements in a dump backup script in dotConnect for PostgreSQL 7.10.1013. However, we could not reproduce the issue in the latest dotConnect for PostgreSQL 7.10.1031. You can download the latest dotConnect for PostgreSQL 7.10.1031 from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Customer Portal (for users with valid subscription only).
Try using the latest dotConnect for PostgreSQL version and post here about the results.

Feneck91
Posts: 50
Joined: Mon 12 Aug 2013 13:52

Re: dotConnect for PostgreSQL 7.10 : PgSqlDump not work anymore !

Post by Feneck91 » Thu 14 Dec 2017 09:16

It's work like a charm with the PostgreSQL 7.10.1031 version.
Thanks for all.

Post Reply