5 Simple Techniques For online backup options
Wiki Article
Defines the person that could be utilized for functions to the repository host. If possible it's not the postgres person but rather A few other person like pgbackrest.
Three amounts of assistance are supplied. If no command is specified then standard support are going to be displayed. If a command is specified (e.g. pgbackrest assistance backup) then a full description with the command are going to be displayed along with a list of legitimate options.
Sets the timeout, in seconds, the regional or remote method will wait for a brand new concept to get obtained over the protocol layer. This prevents procedures from ready indefinitely for your concept.
It is going to take a handful of seconds to make the “Archive mailbox.” At the time it truly is established, the person should be able to see the archive mailbox.
Just about every approach will carry out compression and transfer for making the command run a lot quicker, but Do not set course of action-max so significant that it impacts database performance. default: 1
The log route supplies a area for pgBackRest to shop log files. Be aware that if log-degree-file=off then no log path is required. default: /var/log/pgbackrest
It go to this website may be difficult to estimate in advance exactly how much House You'll have. The best matter to perform is get some backups then report the scale of different types of backups (whole/incr/diff) and measure the her explanation quantity of WAL produced per day.
Take note that all the read/publish operation doesn't will need to finish within just this timeout but some development should be manufactured, whether or not it is just one byte. default: sixty
WAL segments pushed from a standby server might be logically similar to WAL segments pushed from the primary but have distinctive checksums. Disabling archiving from various resources is recommended to stay away from conflicts.
If this occurs then the archive log stream will likely be interrupted and PITR won't be doable previous that point. A new backup is going to be required to regain comprehensive restore ability.
Help file logging for almost any subprocesses produced by this method utilizing the log stage specified by log-amount-file. default: n
Whenever a entire backup expires, all differential and incremental backups linked to the complete backup can even expire. When the option just isn't described a warning will be issued. If indefinite retention is ideal then set the choice to your max worth. permitted: one-9999999
The log route presents a location for pgBackRest to shop log files. Observe that if log-degree-file=off then no log path is needed. default: /var/log/pgbackrest
Port that PostgreSQL is running on. This commonly does not need to be specified as most PostgreSQL clusters run about the default port. default: 5432