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
1 maintainer
Metadata
1 maintainer
Release files for flush 1.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| flush-1.0.tar.gz | 2.7 kB | Details |
Release files / flush-1.0.tar.gz
| Download URL | flush-1.0.tar.gz |
|---|---|
| Size | 2.7 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
202691d249b4673cde0d8708ef8f1b77f6224f0563cda92cb64f0a5f5fd1dbc4
|
|
BLAKE2b-256 checksum How to use checksums |
64c775fb9b004341b734fee590e7120490f0910fd2d8c068620fb423bdee0843
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.7.0
|
