Skip to main content

Archive PostgreSQL tables to S3

Project description

flush

Archive PostgreSQL tables to S3.

CLI tool that flushes (exports and deletes) all database rows of a PostgreSQL table into a CSV in a specified S3 bucket. Useful for archiving data and saving money in small infrastructure environments.

Usage

Ensure you are using correct AWS credentials (as if you were using BOTO: https://boto3.amazonaws.com/v1/documentation/api/latest/guide/quickstart.html#configuration).

Then:

pip install flush
flush postgres://localhost:5432/mydatabase tablename mybucket --truncate

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

flush-1.0.tar.gz (2.7 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page