expanso-nightly-backup

Automate nightly database backups to Google Cloud Storage by running a scheduled pipeline that exports tables like orders and inventory directly into compressed Parquet files. This process supports both incremental and full backups with automatic date partitioning.

Backing up PostgreSQL tables for disaster recovery is best handled by exporting critical data to compressed Parquet format in cloud storage. This approach includes checksum verification to ensure backup integrity and supports date partitioning for efficient data archival.

Yes, the database backup pipeline supports incremental exports alongside full backups. It includes checksum verification for every run to guarantee data integrity, ensuring your date-partitioned Parquet files in cloud storage remain reliable for disaster recovery.

Yes, you can back up multiple database tables in a single pipeline run. The automated backup process handles multi-table support, capturing daily changes from tables like orders, inventory, and order items simultaneously to streamline your nightly data archival.

Compressed Parquet files with date partitioning are used for cloud storage backups to optimize storage costs and query performance. This format efficiently organizes incremental and full database snapshots, making disaster recovery archives easier to manage and retrieve.

Run the nightly backup pipeline for your database tables by executing the provided shell script. This script automates the extraction of tables like orders and inventory, outputting them as compressed Parquet files directly to Google Cloud Storage.