Is it possible to do a full backup and restore of the database?

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Wodzu
Posts: 23
Joined: Thu 01 Sep 2011 08:35

Is it possible to do a full backup and restore of the database?

Post by Wodzu » Mon 25 Jan 2016 09:36

Hi guys,

I am evaluating TpgDump component and I would like to know is it possible to do a full backup and restore of the database.

I've found this old topic: http://forums.devart.com/viewtopic.php? ... it=restore
But I am not sure is it possible to do this or not. My database is not complex.
After trying a TpgDump.BackupToFile I see that in the created file there is no instructions for creating a database. So it would suggest that there is no such possibility, is that correct?

Best regards.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Is it possible to do a full backup and restore of the database?

Post by AlexP » Tue 26 Jan 2016 09:03

Hello,

In order to add a create database instruction to the backup script, you should enable the doDatabase option: https://www.devart.com/pgdac/docs/?deva ... object.htm .

Post Reply