Backwork plug-in for PostgreSQL backups.
Project description
backwork-backup-postgresql
Add support for PostgreSQL backups on backwork
.
Requirements
This plug-in is build on top of pg_dump
,
so you will need to it installed.
pg_dump
is part of the postgresql
client.
Installing
You can use pip
to install this plug-in:
$ pip install backwork-backup-postgresql
Using
After installing the plug-in you will be able to use the backup mysql
command
on backwork
.
backwork backup postgresql -h
usage: backwork backup postgresql [-h] [--gzip] [-o OUTPUT] -P PASSWORD
Backup a PostgreSQL database. It uses `pg_dump` so it's required to have it
installed and added to the system's PATH. You can use any of the arguments
supported by `pg_dump`. Use `pg_dump --help` for more information.
optional arguments:
-h, --help show this help message and exit
--gzip compress output file (requires gzip to be installed)
-o OUTPUT, --output OUTPUT
output file path
-P PASSWORD, --password PASSWORD
PostgreSQL connection password
You can pass any option that you would normally use on mysqldump
:
$ backwork backup postgresql -P password --host=192.168.99.1 --username=root --port=32769 --dbname=MY_DATABASE
As shown in the --help
message, there are two extra arguments you can use in
your backup process --gzip
and -o
.
--gzip
will compress the output and requires the gzip
command to be
available in your system.
-o OUTPUT
or --output OUTPUT
will save the output of pg_dump
into a
file.
Important: There is a conflict with the -h
argument since it is reserved
for the help/usage message. User --host
to pass the hostname.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for backwork-backup-postgresql-0.2.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | dd7433e349f09d2e3c1b46b5071de333a7f3f865be2ea93e65991c2f9244c9b2 |
|
MD5 | 571d6b679f7f7633e98c2aa25e5c888b |
|
BLAKE2b-256 | 19b29f33fe6972b3efbdec5594c61c4f63dd90545150b603e6b6c26e26f64a8d |
Hashes for backwork_backup_postgresql-0.2.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 694ecdd0516332c5115e429f4008fc86f76b50fd0358fbf3f5af09dd5766b6ba |
|
MD5 | b410b068fef1510e42fda8e71f068b01 |
|
BLAKE2b-256 | b1920437889f55fe9caf21f6471661a3cc99ea00f5432b4c8ba14dce268fc71c |