EMS logo

Products Navigation

SQL Backup for PostgreSQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Backup for PostgreSQL

Product FAQs

Table of contents

Q:
What versions of PostgreSQL server does EMS SQL Backup for PostgreSQL support?
A:
EMS SQL Backup for PostgreSQL works with all server versions starting with 7.4 up to the latest version.
Q:
Must EMS SQL Backup for PostgreSQL be installed on each server which I want to work with?
A:
No, you need to install the console on the PC, which you want to administer tasks from. You can register all your servers and manage them from a single console.
Q:
Must EMS SQL Backup for PostgreSQL be installed on each server which I want to work with?
A:
Servers can be located anywhere: in the local or remote network.
Q:
Can EMS SQL Backup for PostgreSQL reduce backup size?
A:
You can compress backup files for plain SQL and GZIP archives.
Q:
Can I restore a backup file with EMS SQL Backup for PostgreSQL?
A:
No, you cannot. However, you can use standard PostgreSQL tools or SQL Manager for PostgreSQL to restore backup files.
Q:
Can I only backup database structure?
A:
In the Backup task wizard you can select either to backup data, metadata or both.
Q:
Can I filter database objects and exclude some objects from backup?
A:
Yes, you can filter objects by schema or name using wildcards. Either you could add objects to the black list to exclude them from backup.
Q:
My servers are located in different time zones. At what time zone will tasks be launched?
A:
By default tasks are created and launched in local console time, but you can change it to UTC for any server in the Create schedule wizard. In this case all tasks will be performed in UTC time zone.
Q:
Can backup tasks have their own execution schedules?
A:
Yes, each task can have one or more schedules.
Q:
Is it possible to launch quick backup without defining any options?
A:
Yes, you need to select the required database and click the Quick backup icon on the main pages to launch backup process with pre-defined options for this server. Backup file will be sent to the default target assigned for the server.
Q:
Can I send backup files to several destinations simultaneously?
A:
Yes, you can select several storages and backup files will be sent to each of them.
Q:
Where can I see the list of the created backup files?
A:
You can see the list of all created backup files for each backup storage on the Backup storages tab.
Q:
Can I see the backup files created by other software in the backup files list?
A:
You can only see the files with BACKUP extension in the files list, created with our software.
Q:
Can I assign default storages to the server?
A:
You need to set at least one default storage for each server to be able to perform Quick backup. The storages can be selected in the Server registration info dialog.
Q:
How can I monitor task execution?
A:
You can view task status and info about launches on the main page of the program.
Q:
What are the differences between different versions of EMS SQL Backup for PostgreSQL?
A:
You can view the list of all functional differences between EMS SQL Backup for PostgreSQL versions in the Feature Matrix.
Q:
May I not pay the program maintenance?
A:
The basic price of EMS SQL Backup for PostgreSQL includes 1 Year Maintenance. Once the Maintenance term expires, you will be able to continue using the software without any limitations; however, you won’t have access to any product updates released after your maintenance expiration date.