HOMEBREW POSTGRES PGADMIN FULL
The oldest backup will always be a full backup (indicated by an F at the end of the label) but the newest backup can be full, differential (ends with D), or incremental (ends with I). The backups are displayed oldest to newest. The ' backup/expire running' message will appear beside the ' status' information if one of those commands is currently running on the host.
HOMEBREW POSTGRES PGADMIN ARCHIVE
Note that there may be gaps due to archive retention policies or other reasons. The ' wal archive min/max' shows the minimum and maximum WAL currently stored in the archive and, in the case of multiple repositories, will be reported across all repositories unless the -repo option is set.
HOMEBREW POSTGRES PGADMIN CODE
For cases in which an error on a repository occurred that is not one of the known error codes, then an error code of ' other' will be used and the full error details will be provided. If there are multiple repositories, then a status of ' mixed' indicates that the stanza is not in a healthy state on one or more of the repositories in this case the state of the stanza will be detailed per repository. If this is ' ok' then pgBackRest is functioning normally.
The stanza ' status' gives a brief indication of the stanza's health. The JSON output contains far more information than the text output and is kept stable unless a bug is found.Įach stanza has a separate section and it is possible to limit output to a single stanza with the -stanza option. This format is subject to change with any release.įor machine-readable output use -output=json. Text output is the default and gives a human-readable summary of backups for the stanza(s) requested. The info command operates on a single stanza or all stanzas. P00 INFO: expire command begin 2.46: -exec-id=1332-41458450 -log-level-console=info -log-level-stderr=off -no-log-timestamp -repo1-cipher-pass= -repo1-cipher-type=aes-256-cbc -repo1-path=/var/lib/pgbackrest -repo1-retention-full=2 -stanza=demo
P00 INFO: new backup label = 20230522-071846F P00 INFO: full backup size = 23.5MB, file total = 976 P00 INFO: backup command end: completed successfully log-level-console=info backup P00 INFO: backup command begin 2.46: -exec-id=1332-41458450 -log-level-console=info -log-level-stderr=off -no-log-timestamp -pg1-path=/var/lib/postgresql/12/demo -repo1-cipher-pass= -repo1-cipher-type=aes-256-cbc -repo1-path=/var/lib/pgbackrest -repo1-retention-full=2 -stanza=demo -start-fast P00 WARN: no prior backup exists, incr backup has been changed to full P00 INFO: execute non-exclusive backup start: backup begins after the requested immediate checkpoint completes Sudo -u postgres pgbackrest -stanza=demo \ config-path is specified: this setting will override the base path for the default location of the config file and/or the base path of the default config-include-path setting unless the config and/or config-include-path option is explicitly set.config and config-include-path are specified: using the user-specified values, the config file will be loaded and *.conf files in the config include path will be appended.If it is desirable to load only the files in the specified config include path, then the -no-config option can also be passed. The default config file will be be loaded if it exists. config-include-path is specified: *.conf files in the config include path will be loaded and the path is required to exist.config option is specified: only the specified config file will be loaded and is expected to exist.config and config-include-path are default: the default config file will be loaded, if it exists, and *.conf files in the default config include path will be appended, if they exist.There are multiple ways the pgBackRest configuration files can be loaded:
0 kommentar(er)
