EMS DB Extract for PostgreSQL is a utility designed to create backups of PostgreSQL databases in the form of SQL scripts. It allows users to extract both the metadata of all database objects and the actual table data, generating a database snapshot. The tool provides a graphical wizard for step-by-step extraction and a command-line utility for automated or scheduled backups. Users can select specific objects and tables for extraction, define constraints, and customize many extraction parameters, ensuring that scripts are generated in the correct order according to object dependencies. The utility supports Unicode data, offers flexible output options (including script compression and charset selection), and can access databases securely via SSH tunnels.

Key Features

Support for Unicode Data Handles multilingual data and ensures accurate extraction of all character sets.

• Extracts and preserves Unicode characters
• Ensures compatibility with international databases

User-Friendly Wizard Interface Guides users through the extraction process step by step.

• Simplifies backup creation for all experience levels
• Reduces risk of configuration errors

Selective Extraction of Database Objects Allows users to choose which objects and tables to extract.

• Extracts only relevant data or structures
• Minimizes backup size and time

Data Constraints and Table Preparation Supports defining constraints and preparing tables before data insertion.

• Enables emptying tables before inserting new data
• Maintains data integrity during restores

Order-Aware Script Generation Ensures scripts are generated in dependency order.

• Prevents errors during database restoration
• Maintains referential integrity

Script Compression and Splitting Compresses output scripts and splits them into volumes if needed.

• Eases handling of large backups
• Facilitates storage and transfer

Command-Line Utility Automates extraction using configuration files.

• Supports scheduled and unattended backups
• Integrates with scripts and automation tools

SSH Tunnel Support Secures database connections during extraction.

• Protects data in transit
• Enables remote database extraction

Benefits

Reliable and Flexible Backup Creation Ensures comprehensive and customizable database backups.

• Reduces risk of data loss by capturing both structure and data
• Adapts to various backup and migration scenarios

Time-Saving and Automation Streamlines and automates backup processes.

• Minimizes manual intervention with wizard and CLI
• Enables scheduled or one-touch backup creation