TPGDump generate error on Postgresql 10.2
TPGDump generate error on Postgresql 10.2
I called the method PGDump.BackupToFile.
When it tries to save the sequences it gives the following error:
"Column increment_by does not exists!"
The postgresql version of the database is 10.2.
I have the last version by this time of this set of components: PgDac 5.3.8.
How should I save correctly the entire database (including sequences), using this component?
When it tries to save the sequences it gives the following error:
"Column increment_by does not exists!"
The postgresql version of the database is 10.2.
I have the last version by this time of this set of components: PgDac 5.3.8.
How should I save correctly the entire database (including sequences), using this component?
Re: TPGDump generate error on Postgresql 10.2
You can see the sample of using TPgDump in PgDacDemo project, which is located in the folder '\Demos\PgDacDemo' relatively the path where PgDAC demos were installed.
More details about TPgDump in our online documentation: https://www.devart.com/pgdac/docs/pgdump.htm
If the error persists, create a dump of the test database using the standard utility pg_dump. Then use the contact form at our site: https://www.devart.com/company/contactform.html and send this dump.
More details about TPgDump in our online documentation: https://www.devart.com/pgdac/docs/pgdump.htm
If the error persists, create a dump of the test database using the standard utility pg_dump. Then use the contact form at our site: https://www.devart.com/company/contactform.html and send this dump.
Re: TPGDump generate error on Postgresql 10.2
Thanks for answering. In the PgDacDemo project, tPgDump is used only for tables (and not for SEQUENCES). So this demo is not helping me at all.
Maybe it's a bug, because sequences are saved correctly in a Postresql 9 database. The error is generated on a Postgresql 10 database.
Until this error is resolved, I'm back at using the classic pg_dump command for saving the entire database.
Best regards,
Leonard
PS: I cannot send the dump in the contact form because it's very large database.
Maybe it's a bug, because sequences are saved correctly in a Postresql 9 database. The error is generated on a Postgresql 10 database.
Until this error is resolved, I'm back at using the classic pg_dump command for saving the entire database.
Best regards,
Leonard
PS: I cannot send the dump in the contact form because it's very large database.
Re: TPGDump generate error on Postgresql 10.2
Please provide us with CREATE table script (PostgreSQL 10.2) to reproduce the 'Column increment_by does not exists!' error using TPgDump.
Re: TPGDump generate error on Postgresql 10.2
Currently i don't have access to the postgresql 10.2 database, but there is no need to send you this script. Just create a sequence in any postgresql 10.2 database, and then try to dump the entire database (including sequences).
Here is an example of a create sequence script:
Thanks.
Here is an example of a create sequence script:
Code: Select all
CREATE SEQUENCE test_serial;
Re: TPGDump generate error on Postgresql 10.2
In order for TPgDump to back up SEQUENCE in the database, set the doSequences property to True. For example:
More about TPgDump.ObjectTypes: https://www.devart.com/pgdac/docs/devar ... types.htm
Code: Select all
PgDump.ObjectTypes := PgDump.ObjectTypes + [doSequences];
Re: TPGDump generate error on Postgresql 10.2
I have the same error by my database is running on 64bit windows Postgresql version 11
if options sequences is disabled then entire schema seems to finalize work, also the on error event is not working...
i have not test the restore option yet
with this command my backup is working
@echo off
for /f "tokens=1-4 delims=/ " %%i in ("%date%") do (
set dow=%%i
set month=%%j
set day=%%k
set year=%%l
)
set datestr=%month%_%day%_%year%
echo datestr is %datestr%
set BACKUP_FILE=D:\Lis.backup_%datestr%.backup
echo backup file name is %BACKUP_FILE%
SET PGPASSWORD=*****
echo on
bin\pg_dump -h localhost -p 5432 -U postgres -F c -b -v -f %BACKUP_FILE% postgres
if options sequences is disabled then entire schema seems to finalize work, also the on error event is not working...
i have not test the restore option yet
with this command my backup is working
@echo off
for /f "tokens=1-4 delims=/ " %%i in ("%date%") do (
set dow=%%i
set month=%%j
set day=%%k
set year=%%l
)
set datestr=%month%_%day%_%year%
echo datestr is %datestr%
set BACKUP_FILE=D:\Lis.backup_%datestr%.backup
echo backup file name is %BACKUP_FILE%
SET PGPASSWORD=*****
echo on
bin\pg_dump -h localhost -p 5432 -U postgres -F c -b -v -f %BACKUP_FILE% postgres
Re: TPGDump generate error on Postgresql 10.2
We reproduced the issue and fixed this error. The fix will be included in the next PgDAC build.