It is tempting to name the stanza just after the key cluster but a much better name describes the databases contained during the cluster. Since the stanza title is going to be used for the key and all replicas it is much more suitable to choose a name that describes the actual perform of the cluster, including app or dw, in lieu of the nearby cluster identify, which include primary or prod. case in point: --stanza=key
The unix socket directory which was specified when PostgreSQL was started off. pgBackRest will mechanically seem during the common place in your OS so there is often no need to specify this setting Except the socket Listing was explicitly modified With all the unix_socket_directory setting in postgresql.conf. example: --pg1-socket-route=/var/operate/postgresql
Clients are authorized to the server by verifying their certification and examining the certification CN (Typical identify) in opposition to an inventory about the server configured Along with the tls-server-auth.
Defines the person that could be used for operations to the repository host. If possible it's not the postgres consumer but somewhat Another person like pgbackrest.
Sets the timeout, in seconds, the nearby or distant approach will look ahead to a different message to generally be received over the protocol layer. This stops processes from waiting around indefinitely for a concept.
The pg-route possibility is analyzed against the worth noted by PostgreSQL on just about every online backup so it ought to usually be recent. case in point: --pg1-path=/info/db
A stanza will be the configuration for a PostgreSQL databases cluster that defines exactly where it is located, how It'll be backed up, archiving options, and so on.
This should be the same as the data_directory environment in postgresql.conf. Regardless that this value is often browse from postgresql.conf or PostgreSQL it can be prudent to set it in the event that Individuals resources are not obtainable during a restore or offline backup circumstance.
Make certain that dependable SSH authentication is configured involving the PostgreSQL host plus the repository host.
Following, enter the Business office 365 account login credential facts like user title and password. You are able to possibly pick out The one mailbox or A number of mailbox alternative based upon your preference. Then, simply click the “Include†choice to include it.
Defines the user that can be employed for operations to the repository host. If possible this is not the postgres consumer but relatively Various other consumer like pgbackrest.
Permits the timestamp in console and file logging. This option is disabled in Exclusive predicaments for example generating documentation. default: y
Sets the network compression degree when compress-variety=none as well as the command is not really operate on original site the exact same host given that the repository. Compression is employed to reduce network targeted traffic but can be disabled by placing compress-stage-network=0.
Specifies the level of time (in seconds) without any network action after which the functioning process really should send out a TCP retain-alive concept.