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
Release history Release notifications
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
| 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 |
