Editing Patroni Cluster (section)

=== PGBackRest ===

Setup the repository on Debian3. </br>
Install pgbackrest on all the servers … </br>
<pre>
sudo apt install pgbackrest
sudo mkdir -p -m 770 /var/log/pgbackrest
sudo chown postgres:postgres /var/log/pgbackrest
sudo mkdir -p /etc/pgbackrest
sudo touch /etc/pgbackrest/pgbackrest.conf
sudo chmod 640 /etc/pgbackrest/pgbackrest.conf
sudo chown postgres:postgres /etc/pgbackrest/pgbackrest.conf
</pre>

On debian3, create the directory that will hold the backups … </br>
<pre>
sudo mkdir -p /etc/pgbackrest/conf.d
sudo mkdir -p /var/lib/pgbackrest
sudo chmod 750 /var/lib/pgbackrest
sudo chown postgres:postgres /var/lib/pgbackrest
</pre>

==== Setup SSH ====
We will need a passwordless SSH connection between the repository and the database servers. </br>
For this setup I was using postgres as the user that controls pgbackrest. </br>
<pre>
# debian1
ssh-keygen
scp id_ras.pub postgres@debian3
ssh postgres@debian3
# debian3
ssh-keygen
scp ./.ssh/id_ras.pub postgres@debian1
ssh postgres@debian1
</pre>

==== Configuration ====

As the postgres user create the configuration file on the repository. </br>
<pre>
vi /etc/pgbackrest/pgbackrest.conf

[cybertec]
pg1-host=debian1
pg1-path=/var/lib/postgresql/17 

[global]
repo1-cipher-pass=zWaf6XtpjIVZC5444yXB+cgFDFl7MxGlgkZSaoPv
repo1-cipher-type=aes-256-cbc
repo1-path=/var/lib/pgbackrest
repo1-retention-full=2
start-fast=y
</pre>

As the postgres user create the configuration file on the database server. </br>
<pre>
[cybertec]
pg1-path=/var/lib/postgresql/17
 
[global]
log-level-file=detail
repo1-host=debian3 
repo1-host-user=postgres
</pre>

Alter the archive_command parameter so that it uses the pgbackrest executable. </br>
<pre>
patronictl edit-config --pg archive_command="pgbackrest --stanza=cybertec archive-push %p"
</pre>

Create a Stanza on the repository server and confirm it is working. </br>
<pre>
pgbackrest --stanza=cybertec stanza-create
pgbackrest --stanza=cybertec check
</pre>

Also check if the Stanza is correct on the database servers. </br>
<pre>
pgbackrest --stanza=cybertec check
</pre>