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.

Files for flush, version 1.0
Filename, size File type Python version Upload date Hashes
Filename, size flush-1.0.tar.gz (2.7 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page