pitrery
pitrery copied to clipboard
dalibo
DEPRECATED. PostgreSQL Point In Time Recovery made easy
I'd like to have some information about the timeline and the WAL location, more or less what comes `pg_controldata` provides: ``` Latest checkpoint location: 1F/BE000060 Latest checkpoint's REDO location: 1F/BE000028...
Archives were previously stored by default in `$BACKUP_DIR/archive_xlog`, now in `$BACKUP_DIR/archive_wal`. So, if `$ARCHIVE_DIR` was not explicitly set, pitrery will put the archives in a different directory than before. Archiving...
As discussed in private: On Debian, with pitrery 3.1 (from apt.dalibo.org or github) and PG 12, the behaviour has changed: * with `pitrery restore`, the `postgresql.conf` is modified (`restore_command `...
The archive_wal script can get stuck, for example, following a network problem: ``` /usr/bin/sss_ssh_knownhostsproxy -p 22 ssh -n -- readlink -m -- /backups/pitr/ /bin/bash /usr/bin/archive_wal pg_wal/000000010000038C00000032 ``` There is no...
pitrery is a set of complex scripts. I think it could be nice to add some basic tests to make sure we don't regress. For me it's the first step...
PostgreSQL 13 now creates backup_manifest JSON files when using pg_basebackup with a pg_verifybackup tool to check the backup consistency. Make pitrery creates a backup_manifest files on backup.
hi, Since we create backup directory with the format : `YYYY.MM.DD_HH.MM.SS` We should filter valid backup directories with the same criteria instead of `[0-9]*` A second criteria should be the...
Store inside the backup: * the pitrery command line * the pitrery configuration file * the postgresql configuration files paths ('config_file' 'hba_file' 'ident_file') * search for extra configuration files (include_if_exists,...
Either add temp files to cleanup to a list in cleanup() or create a unique mktemp directory to save all files and remove this directory in cleanup()