No project description provided
Django PostgreSQL Copy
django-pg-copy provides Django management commands for backing up and restoring PostgreSQL databases. These were developed for copying production databases to development, to allow developers to share images with one another, or bring local development databases up to date.
pip install django-pg-copy
'pg_copy', to your
INSTALLED_APPS list. It is recommended that it is used in all environments (development, production) so that you can use it against different instances of your database.
PG_COPY_BACKUP_PATH = 'db_backup'
By default, PostgreSQL backups will be stored in a directory called
db_backup where you run the command. This setting will override that location.
It is also recommended to add this path to your
.gitignore file, if the path falls under your version control repository.
python manage.py pg_backup --settings=config.settings.production --database=default --filename=my_backup.sqlc
This command will create a backup in the same directory as
my_backup.sqlc using the
default settings from
DATABASES using the Django settings file
python manage.py pg_backup
This command will create a backup in the directory
./db_backup/ (or the directory you specified with
[timestamp].sqlc using the
default settings from
DATABASES using the default Django settings file resolved by
python manage.py pg_restore
This command will provide a list of backup files in
PG_COPY_BACKUP_PATH that can be restored. After selecting a backup file, it will confirm that the user wants to overwrite the destination database by showing which server and database will be overwritten from the settings.
python manage.py pg_restore --filename=my_file.sqlc
This command will read the file
my_file.sqlc and confirm that the user wants to overwrite the destination database by showing which server and database will be overwritten from the settings.
- Timothy Allen (https://github.com/FlipperPA)
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size & hash SHA256 hash help||File type||Python version||Upload date|
|django_pg_copy-0.1-py3-none-any.whl (5.3 kB) Copy SHA256 hash SHA256||Wheel||py3|
|django-pg-copy-0.1.tar.gz (3.7 kB) Copy SHA256 hash SHA256||Source||None|