parameter, as follows:

</para>

<programlisting>

archive_command = '<replaceable>install_dir</replaceable>/pg_probackup archive-push -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --wal-file-name=%f [<replaceable>remote_options</replaceable>]'

archive_command = '"<replaceable>install_dir</replaceable>/pg_probackup" archive-push -B"<replaceable>backup_dir</replaceable>" --instance <replaceable>instance_name</replaceable> --wal-file-name=%f [<replaceable>remote_options</replaceable>]'

</programlisting>

</listitem>

</itemizedlist>

specified timestamp, run this command:

</para>

<programlisting>

pg_probackup validate -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> -i PT8XFX --recovery-target-time='2017-05-18 14:18:11+03'

pg_probackup validate -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> -i PT8XFX --recovery-target-time="2017-05-18 14:18:11+03"

</programlisting>

<para>

If you specify the <replaceable>backup_id</replaceable> of an incremental backup,

timestamp format. For example:

</para>

<programlisting>

pg_probackup restore -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --recovery-target-time='2017-05-18 14:18:11+03'

pg_probackup restore -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --recovery-target-time="2017-05-18 14:18:11+03"

</programlisting>

</listitem>

<listitem>

point, use <option>--recovery-target-name</option> option:

</para>

<programlisting>

pg_probackup restore -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --recovery-target-name='before_app_upgrade'

pg_probackup restore -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --recovery-target-name="before_app_upgrade"

</programlisting>

</listitem>

<listitem>

with <literal>latest</literal> value:

</para>

<programlisting>

pg_probackup restore -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --recovery-target='latest'

pg_probackup restore -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --recovery-target="latest"

</programlisting>

</listitem>

<listitem>

Provided arguments will be used to construct the <command>restore_command</command>:

</para>

<programlisting>

restore_command = '<replaceable>install_dir</replaceable>/pg_probackup archive-get -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --wal-file-path=%p --wal-file-name=%f --remote-host=192.168.0.3 --remote-port=2303 --remote-user=backup'

restore_command = '"<replaceable>install_dir</replaceable>/pg_probackup" archive-get -B"<replaceable>backup_dir</replaceable>" --instance <replaceable>instance_name</replaceable> --wal-file-path=%p --wal-file-name=%f --remote-host=192.168.0.3 --remote-port=2303 --remote-user=backup'

</programlisting>

<para>

Alternatively, you can use the <option>--restore-command</option>

option to provide the entire <parameter>restore_command</parameter>:

</para>

<programlisting>

pg_probackup restore -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --remote-user=postgres --remote-host=192.168.0.2 --remote-port=2302 --restore-command='<replaceable>install_dir</replaceable>/pg_probackup archive-get -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --wal-file-path=%p --wal-file-name=%f --remote-host=192.168.0.3 --remote-port=2303 --remote-user=backup'

pg_probackup restore -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> --remote-user=postgres --remote-host=192.168.0.2 --remote-port=2302 --restore-command='"<replaceable>install_dir</replaceable>/pg_probackup" archive-get -B"<replaceable>backup_dir</replaceable>" --instance <replaceable>instance_name</replaceable> --wal-file-path=%p --wal-file-name=%f --remote-host=192.168.0.3 --remote-port=2303 --remote-user=backup'

</programlisting>

<note>

<para>

using the <option>--expire-time</option> option. For example:

</para>

<programlisting>

pg_probackup set-backup -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> -i <replaceable>backup_id</replaceable> --expire-time='2020-01-01 00:00:00+03'

pg_probackup set-backup -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> -i <replaceable>backup_id</replaceable> --expire-time="2020-01-01 00:00:00+03"

</programlisting>

<para>

Alternatively, you can use the <option>--ttl</option> and

</para>

<programlisting>

pg_probackup backup -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> -b FULL --ttl=30d

pg_probackup backup -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> -b FULL --expire-time='2020-01-01 00:00:00+03'

pg_probackup backup -B <replaceable>backup_dir</replaceable> --instance <replaceable>instance_name</replaceable> -b FULL --expire-time="2020-01-01 00:00:00+03"

</programlisting>

<para>

To check if the backup is pinned,

This option will be ignored unless the <option>-R</option> flag is specified.

</para>

<para>

Example: <literal>--primary-conninfo='host=192.168.1.50 port=5432 user=foo password=foopass'</literal>

Example: <literal>--primary-conninfo="host=192.168.1.50 port=5432 user=foo password=foopass"</literal>

</para>

</listitem>

</varlistentry>

If the time zone offset is not specified, the local time zone is used.

</para>

<para>

Example: <literal>--recovery-target-time='2020-01-01 00:00:00+03'</literal>

Example: <literal>--recovery-target-time="2020-01-01 00:00:00+03"</literal>

</para>

</listitem>

</varlistentry>

If the time zone offset is not specified, the local time zone is used.

</para>

<para>

Example: <literal>--expire-time='2020-01-01 00:00:00+03'</literal>

Example: <literal>--expire-time="2020-01-01 00:00:00+03"</literal>

</para>

</listitem>

</varlistentry>

Provides a string of SSH command-line options. For example,

the following options can be used to set <parameter>keep-alive</parameter> for SSH

connections opened by <application>pg_probackup</application>:

<literal>--ssh-options='-o ServerAliveCountMax=5 -o ServerAliveInterval=60'</literal>.

<literal>--ssh-options="-o ServerAliveCountMax=5 -o ServerAliveInterval=60"</literal>.

For the full list of possible options, see

<ulinkurl="https://man.openbsd.org/ssh_config.5">ssh_config

manual page</ulink>.

<stepid="pbk-add-instance-pg-11-to-backup-catalog">

<title>Add instance <literal>pg-11</literal> to the backup catalog:</title>

<programlisting>

[backupman@backup_host]$ pg_probackup-11 add-instance -B /mnt/backups --instance'pg-11' --remote-host=postgres_host --remote-user=postgres -D /var/lib/postgresql/11/main

[backupman@backup_host]$ pg_probackup-11 add-instance -B /mnt/backups --instance pg-11 --remote-host=postgres_host --remote-user=postgres -D /var/lib/postgresql/11/main

INFO: Instance 'node' successfully inited

</programlisting>

</step>

<stepid="pbk-take-full-backup">

<title>Take a FULL backup:</title>

<programlisting>

[backupman@backup_host] pg_probackup-11 backup -B /mnt/backups --instance'pg-11' -b FULL --stream --remote-host=postgres_host --remote-user=postgres -U backup -d backupdb

[backupman@backup_host] pg_probackup-11 backup -B /mnt/backups --instance pg-11 -b FULL --stream --remote-host=postgres_host --remote-user=postgres -U backup -d backupdb

INFO: Backup start, pg_probackup version: 2.2.0, instance: node, backup ID: PZ7YK2, backup mode: FULL, wal mode: STREAM, remote: true, compress-algorithm: none, compress-level: 1

INFO: Start transferring data files

INFO: Data files are transferred

<stepid="pbk-lets-take-a-look-at-the-backup-catalog">

<title>Let's take a look at the backup catalog:</title>

<programlisting>

[backupman@backup_host] pg_probackup-11 show -B /mnt/backups --instance'pg-11'

[backupman@backup_host] pg_probackup-11 show -B /mnt/backups --instance pg-11

BACKUP INSTANCE 'pg-11'

==================================================================================================================================

<stepid="pbk-take-incremental-backup-in-delta-mode">

<title>Take an incremental backup in the DELTA mode:</title>

<programlisting>

[backupman@backup_host] pg_probackup-11 backup -B /mnt/backups --instance'pg-11' -b delta --stream --remote-host=postgres_host --remote-user=postgres -U backup -d backupdb

[backupman@backup_host] pg_probackup-11 backup -B /mnt/backups --instance pg-11 -b delta --stream --remote-host=postgres_host --remote-user=postgres -U backup -d backupdb

INFO: Backup start, pg_probackup version: 2.2.0, instance: node, backup ID: PZ7YMP, backup mode: DELTA, wal mode: STREAM, remote: true, compress-algorithm: none, compress-level: 1

INFO: Parent backup: PZ7YK2

INFO: Start transferring data files

<title>Let's add some parameters to <application>pg_probackup</application>

configuration file, so that you can omit them from the command line:</title>

<programlisting>

[backupman@backup_host] pg_probackup-11 set-config -B /mnt/backups --instance'pg-11' --remote-host=postgres_host --remote-user=postgres -U backup -d backupdb

[backupman@backup_host] pg_probackup-11 set-config -B /mnt/backups --instance pg-11 --remote-host=postgres_host --remote-user=postgres -U backup -d backupdb

</programlisting>

</step>

<stepid="pbk-take-another-incremental-backup-in-delta-mode-omitting-some-of-the-previous-parameters">

<title>Take another incremental backup in the DELTA mode, omitting

some of the previous parameters:</title>

<programlisting>

[backupman@backup_host] pg_probackup-11 backup -B /mnt/backups --instance'pg-11' -b delta --stream

[backupman@backup_host] pg_probackup-11 backup -B /mnt/backups --instance pg-11 -b delta --stream

INFO: Backup start, pg_probackup version: 2.2.0, instance: node, backup ID: PZ7YR5, backup mode: DELTA, wal mode: STREAM, remote: true, compress-algorithm: none, compress-level: 1

INFO: Parent backup: PZ7YMP

INFO: Start transferring data files

<stepid="pbk-lets-take-a-look-at-instance-config">

<title>Let's take a look at the instance configuration:</title>

<programlisting>

[backupman@backup_host] pg_probackup-11 show-config -B /mnt/backups --instance'pg-11'

[backupman@backup_host] pg_probackup-11 show-config -B /mnt/backups --instance pg-11

# Backup instance information

pgdata = /var/lib/postgresql/11/main

<stepid="pbk-lets-take-a-look-at-the-backup-catalog-1">

<title>Let's take a look at the backup catalog:</title>

<programlisting>

[backupman@backup_host] pg_probackup-11 show -B /mnt/backups --instance'pg-11'

[backupman@backup_host] pg_probackup-11 show -B /mnt/backups --instance pg-11

====================================================================================================================================

Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status