{"id":3809,"date":"2023-03-29T11:46:41","date_gmt":"2023-03-29T11:46:41","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=3809"},"modified":"2023-03-31T11:07:27","modified_gmt":"2023-03-31T11:07:27","slug":"setting-up-and-configuring-pgbarman","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbarman\/","title":{"rendered":"Setting up and Configuring pgBarman"},"content":{"rendered":"\n

As discussed on the Postgres Backup for Peeps blog<\/a>, here are the basic steps to install and configure Barman for backing up a production PostgreSQL server:<\/p>\n\n\n\n

S.No<\/td>Hostname<\/td>IP<\/td>Role<\/td><\/tr>
1<\/td>Node1<\/td>192.168.113.155<\/td>Barman Server (Backup Server)<\/td><\/tr>
2<\/td>Node2<\/td>192.168.113.156<\/td>PostgreSQL Database Server<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Steps to be performed in Node1:<\/strong><\/h2>\n\n\n\n

 Install Barman:<\/strong> Use OS command yum install barman<\/code> to install Barman package in Backup Server.<\/p>\n\n\n\n

 [root@localhost ~]# yum install barman<\/code><\/p>\n\n\n\n

Verify barman package installation: yum install barman<\/code> will create Barman account in Server.
Use the command barman \u2013-version<\/code> to verify installed Barman version in Backup Server.<\/p>\n\n\n\n

[root@localhost ~]# barman --version<\/code><\/p>\n\n\n\n

Set Password for OS Account barman:<\/strong> Use the OS command passwd barman to reset the Barman OS account in Backup Server.<\/p>\n\n\n\n

[root@localhost tmp]# passwd barman<\/code><\/p>\n\n\n\n

Changing password for user barman<\/code>.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.<\/p>\n\n\n\n

Configure Passwordless Authentication in Barman Server:<\/strong> Use OS command ssh-keygen<\/code> to generate public and private keys. Once keys are generated, use OS command ssh-copy-id<\/code> to transfer the public key to PostgreSQL Database Server.<\/p>\n\n\n\n

[root@localhost ~]# su - barman\n-bash-4.2$ ssh-keygen -t rsa\n-bash-4.2$ ls -ltr .ssh\n-bash-4.2$ ssh-copy-id -i ~\/.ssh\/id_rsa.pub postgres@node1\n-bash-4.2$ ssh 'postgres@node1'\n-bash-4.2$ exit<\/code><\/pre>\n\n\n\n
Configure Global Configuration File in Barman Server<\/strong>: The main configuration file (set to \/etc\/barman.conf<\/code> by default) contains general options such as main directory, system user, log file, and so on. Edit \/etc\/barman.conf<\/code> to set global parameters. Set the below parameters and save the file.<\/p>\n\n\n\n
[root@localhost ~]# cd \/etc\/barman.conf \n[root@localhost ~]# cp \/etc\/barman.conf \/etc\/barman_bkp.conf\n[root@localhost ~]# vi \/etc\/barman.conf\nbarman_user = barman\nconfiguration_files_directory = \/etc\/barman.d\nbarman_home = \/var\/lib\/barman\nlog_file = \/var\/log\/barman\/barman.log\nlog_level = INFO\ncompression = gzip (make sure that gzip utility is installed on both servers)\nbasebackup_retry_sleep = 30\nbasebackup_retry_times = 3\nminimum_redundancy =3\nretention_policy = RECOVERY WINDOW OF 4 WEEKS\npath_prefix = \/usr\/pgsql-15\/bin\/<\/code><\/pre>\n\n\n\n
Create the configuration file for the server in barman.d directory like below:<\/strong><\/p>\n\n\n\n
[root@localhost ~]# cd \/etc\/barman.d\n[root@localhost ~]#cp streaming-server.conf-template streaming-pg.conf\n[root@localhost barman.d]$ vi streaming-pg.conf\n[streaming-pg]\ndescription =  \"Example of PostgreSQL Database (Streaming-Only)\"\nconninfo = host=192.168.113.156 user=barman dbname=postgres password=postgres\nstreaming_conninfo = host=192.168.113.156 user=streaming_barman password=postgres\nbackup_method = postgres\nstreaming_archiver = on\nslot_name = barman\nbackup_directory = \/var\/lib\/barman\/backups\n;backup_options = concurrent_backup\nretention_policy = RECOVERY WINDOW OF 7 DAYS\nwal_retention_policy = main\nretention_policy_mode = auto\nminimum_redundancy=2<\/code><\/pre>\n\n\n\n
Steps to be followed<\/strong> on Node2 (PostgreSQL DB Server):<\/strong><\/p>\n\n\n\n
Configure Passwordless Authentication in PostgreSQL Database Server:<\/strong> Use OS command ssh-keygen<\/code> to generate public and private keys. Once keys are generated using the OS command ssh-copy-id<\/code> to transfer the public key to Barman Server. <\/p>\n\n\n\n
[root@localhost ~]# su - postgres\n-bash-4.2$ ssh-keygen -t rsa\n-bash-4.2$ ls -ltr .ssh\n-bash-4.2$ ssh-copy-id -i ~\/.ssh\/id_rsa.pub barman@node1\n-bash-4.2$ ssh 'barman@node1'\n-bash-4.2$ exit<\/code><\/pre>\n\n\n\n
Create two users like below:<\/strong><\/p>\n\n\n\n
  1. barman<\/li><\/ol>\n\n\n\n
    [root@localhost ~]# adduser barman<\/code><\/p>\n\n\n\n
    [root@localhost ~]# passwd barman<\/code><\/p>\n\n\n\n
    2. streaming_barman<\/p>\n\n\n\n
    [root@localhost ~]# adduser streaming_barman<\/code><\/p>\n\n\n\n
    [root@localhost ~]# passwd streaming_barman<\/code><\/p>\n\n\n\n
    set parameters in postgresql.conf file:<\/strong><\/p>\n\n\n\n
    [root@localhost ~]# su \u2013 postgres\n[postgres@localhost ~]$ cd \/var\/lib\/pgsql\/15\/data\/\n[postgres@localhost data]$ vi postgresql.conf\nlisten_addresses = '*'\nwal_level=replica\nmax_wal_senders=10\nmax_replication_slots=10\narchive_mode = on  \narchive_command = 'cp %p \/var\/lib\/pgsql\/15\/archivedir\/%f'\nhot_standby = on\nsynchronous_standby_names = 'barman_receive_wal'<\/code><\/pre>\n\n\n\n
    Set parameters in pg_hba.conf.conf file:<\/strong><\/p>\n\n\n\n
    [postgres@localhost ~]$ cd \/var\/lib\/pgsql\/15\/data\/\n[postgres@localhost data]$ vi pg_hba.conf\n#ip4\nhost all all 0.0.0.0\/0 md5\n#replication privilege\nhost  replication  streaming_barman  192.168.113.156  md5<\/code><\/pre>\n\n\n\n
    systemctl restart postgresql-15.service<\/code><\/p>\n\n\n\n
    Perform backups using Barman :<\/strong><\/p>\n\n\n\n
    Verify Server setup in Barman Server: Use the command barman list-server<\/code> to Server list configured in barman. Command barman show-server streaming-pg<\/code> to get server configuration setting  & command barman check streaming-pg<\/code> to validate the setup.
    [root@localhost ~]# su \u2013 barman<\/code>
    -bash-4.2$ barman list-server<\/strong><\/code><\/p>\n\n\n\n
    <\/p>\n\n\n\n
    [barman@localhost~]$barman switch-xlog --force --archive streaming-pg<\/strong><\/code><\/p>\n\n\n\n
    <\/p>\n\n\n\n
    [barman@localhost ~]$ barman check streaming-pg<\/strong><\/code><\/p>\n\n\n\n
    <\/p>\n\n\n\n
    [barman@localhost ~]$ barman backup streaming-pg --wait<\/strong><\/code><\/p>\n\n\n\n
    <\/strong><\/p>\n\n\n\n
    [barman@localhost ~]$ barman list-backups streaming-pg<\/strong><\/code><\/p>\n\n\n\n
    <\/p>\n\n\n\n
    Point-in-time recovery (PITR)<\/h3>\n\n\n\n
    Let us now perform a recovery up to the restore point we have created.
    **Note:** we need to have at least a backup completed before the creation of the restart point.<\/p>\n\n\n\n
    On the backup<\/code> server as the barman<\/code> user:<\/p>\n\n\n\n
    1. Check the existence of at least a backup for the pgprimary<\/code> server<\/p>\n\n\n\n
    barman@backup:~$ barman list-backup pgprimary\npgprimary 20230329T100114 - Wed Mar 29 10:01:14 2023 - Size: 31.5 MiB - WAL Size: 30.2 KiB<\/code><\/pre>\n\n\n\n
    1. Perform the recovery<\/p>\n\n\n\n
    barman@backup:~$ barman recover \\\n                  --remote-ssh-command=\"ssh postgres@pgrecovery\" \\\n                  pgprimary \\\n                  20230329T100114 \\\n                  \/opt\/postgres\/data \\\n                  --target-name restore_point \\\n                  --target-action pause\n  Starting remote restore for server pgprimary using backup 20230329T100114\n  Destination directory: \/opt\/postgres\/data\n  Doing PITR. Recovery target name: 'restore_point'\n  Copying the base backup.\n  Generating recovery.conf\n  \n  Recovery completed (start time: Wed Mar 29 12:01:00 2023, elapsed time: 3 seconds)\n  \n  Your PostgreSQL server has been successfully prepared for recovery!\n<\/code><\/pre>\n\n\n\n
    Analyzing the above command:<\/p>\n\n\n\n