Search Postgresql Archives

pgbackrest info of encrypted seems broken

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




This is on Postgresql 9.6, if it matters.  Attached is a text file showing the pgbackrest version, config, backup log and "pgbackrest info" output.

I followed the instructions in https://pgbackrest.org/user-guide.html#quickstart/configure-encryption, and successfully ran these commands before the first encrypted backup, but they aren't in the text file:
rm -r /Database/9.6/backups/pgbackrest
pgbackrest stanza-create --stanza=localhost

Have I misconfigured something?

--
Angular momentum makes the world go 'round.
$ pgbackrest version
pgBackRest 2.27

$ cat /etc/pgbackrest.conf
[global]
repo1-path=/Database/9.6/backups/pgbackrest
[localhost]
db-path=/var/lib/pgsql/9.6/data
resume=n
start-fast=y
stop-auto=y
compress=y
log-level-console=info
log-level-file=info
log-path=/var/lib/pgsql/logs/pgbackrest
retention-full=2
process-max=2
repo-cipher-pass=<redacted>
repo-cipher-type=aes-256-cbc
[localhost:archive-push]
compress=n

$ head logs/pgbackrest/localhost-backup.log
-------------------PROCESS START-------------------
2021-05-19 09:13:38.409 P00   INFO: backup command begin 2.27: --compress --log-level-console=info --log-level-file=info --log-path=/var/lib/pgsql
/logs/pgbackrest --pg1-path=/var/lib/pgsql/9.6/data --process-max=2 --repo1-cipher-pass=<redacted> --repo1-cipher-type=aes-256-cbc --repo1-path=/Database/9.6/backups/pgbackrest --repo1-retention-full=2 --no-resume --stanza=localhost --start-fast --stop-auto --type=full
2021-05-19 09:13:39.020 P00   INFO: execute non-exclusive pg_start_backup(): backup begins after the requested immediate checkpoint completes
2021-05-19 09:13:39.522 P00   INFO: backup start archive = 0000000100000010000000C8, lsn = 10/C8000028
2021-05-19 09:14:19.113 P01   INFO: backup file /var/lib/pgsql/9.6/data/base/244222/252451 (1GB, 6%) checksum 645d65a24dedc42829cebdedbfeded382f58d1d3
2021-05-19 09:14:24.381 P02   INFO: backup file /var/lib/pgsql/9.6/data/base/244222/248144.7 (1GB, 12%) checksum 7f4cd97319738cb9cba0e654bbcffd8e471d51e6
[snip]


-bash-4.2$ pgbackrest info
ERROR: [029]: unable to load info file '/Database/9.6/backups/pgbackrest/backup/localhost/backup.info' or '/Database/9.6/backups/pgbackrest/backup/localhost/backup.info.copy':
▒▒˺▒▒˖▒o▒@{▒▒Jr▒u▒▒9\▒V▒Յalue found outside of section at line 1: Salted__
▒▒˺▒▒˖▒o▒@{▒▒Jr▒u▒▒9\▒V▒Յalue found outside of section at line 1: Salted__
       HINT: backup.info cannot be opened and is required to perform a backup.
       HINT: has a stanza-create been performed?
-bash-4.2$

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux