magdenbt / autobackuppg Goto Github PK
View Code? Open in Web Editor NEWAutomatic creation, uploading to the cloud and cleaning of outdated PostgreSQL backups
License: MIT License
Automatic creation, uploading to the cloud and cleaning of outdated PostgreSQL backups
License: MIT License
There are 3 scripts in the package: PostgreSQLBackuper.py - Backup itself, cleaner and synchronizer with Yandex cloud and AWS S3 LauncherPostgreSQLBackupFor1cKiP.py - launcher for creating backups through 1c KIP. Admin Center LauncherPostgreSQLUploadToCloudFor1cKiP.py - launcher for uploading new backups to the cloud via 1c KIP. Admin Center Additionally for 1с KIP. Admin Center python-3.10.8.amd64.for1cKIP.zip - Python 3.10 interpreter with the necessary libraries to run the script LauncherFor1cKiP.yml - configuration file for the so-called. "Dictionary" in KIP. Works on Windows, should work on Linux too The core is a regular utility for creating full archives of the entire PostgreSQL instance - pg_basebackup.exe, located in the bin folder of the PostgreSQL directory. The script does not make incremental backups (i.e. WAL-files or Transaction Logs), since PostgreSQL itself generates them without external influence. However, the script uploads WAL-files to the cloud. Below is a short instruction on configuring PostgreSQL to create WAL-files. Using PostgreSQL 14.4 as an example: The file "C:\Program Files\PostgreSQL\14.4-1.1C\data\postgresql.conf" should have: # - Archiving - archive_mode = on # (change requires restart) archive_command = 'copy "%p" "F:\\pg_log_archive\\%f"' archive_timeout = 1800 INSTEAD: # - Archiving - #archive_mode = off # (change requires restart) #archive_command = '' #archive_timeout = 0 archive_command - tell the server what to do when a new WAL-file is ready/created archive_timeout - Optional. The time after which the server will gratefully create a new WAL-file, regardless of whether changes have accumulated in the database or not. Be careful, each file took 16MB for me, even if it does not contain changes P.S. For the script to work on Linux, you need to slightly tweak the principle of compiling paths to files В пакете 3 скрипта: PostgreSQLBackuper.py - Сам бэкапер, "удалятор" и синхронизатор с облаком Yandex и Yandex S3 ( AWS-like) LauncherPostgreSQLBackupFor1cKiP.py - лончер для создания бэкапов через 1с КИП. Центр администрирования LauncherPostgreSQLUploadToCloudFor1cKiP.py - лончер для выгрузки новых бэкапов в облако через 1с КИП. Центр администрирования Дополнительно для 1с КИП. Центр администрирования python-3.10.8.amd64.for1cKIP.zip - интерпретатор Python 3.10 с нужными библиотеками для запуска скрипта LauncherFor1cKiP.yml - конфигурационный файл для т.н. "Словаря" в КИП. Работает на Windows, должен подойти и для Linux Ядром является штатная утилита создания полных архивов всего инстанса PostgreSQL - pg_basebackup.exe, располагающаяся в папке bin каталога PostgreSQL. Скрипт не делает инкрементальные бэкапы (т.е. WAL-files или Журналы транзакций), поскольку PostgreSQL сам их формирует без внешнего воздействия. Однако скрипт выгружает WAL-files в облако. Ниже короткая инструкция по настройке PostgreSQL, чтобы он создавал WAL-files. На примере PostgreSQL 14.4: В файле "C:\Program Files\PostgreSQL\14.4-1.1C\data\postgresql.conf" должно быть: # - Archiving - archive_mode = on # (change requires restart) archive_command = 'copy "%p" "F:\\pg_log_archive\\%f"' archive_timeout = 1800 ВМЕСТО # - Archiving - #archive_mode = off # (change requires restart) #archive_command = '' #archive_timeout = 0 archive_command - указание серверу что делать, когда готов/создался новый WAL-file archive_timeout - Необязательно. Время, по истечении которого, сервер признательно создаст новый WAL-file, вне зависимости от того, накопились в базе изменения или нет. Будьте аккуратны, у меня каждый файл занимал 16мб, даже если он не содержит изменения P.S. Для работы скрипта на Linux нужно чуток подправить принцип составления путей до файлов
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.