The <xref linkend="pgarchivecleanup"> module

is often used in <varname>archive_cleanup_command</> for

single-standby configurations, for example:

<programlisting>archive_cleanup_command = 'pg_archivecleanup /mnt/server/archivedir %r'</programlisting>

<programlisting>archive_cleanup_command = 'pg_archivecleanup /mnt/server/archivedir %r'</programlisting>

Note however that if multiple standby servers are restoring from the

same archive directory, you will need to ensure that you do not delete

WAL files until they are no longer needed by any of the servers.

To create a base backup of the server at <literal>mydbserver</literal>

and store it in the local directory

<filename>/usr/local/pgsql/data</filename>:

<screen>

<prompt>$</prompt> <userinput>pg_basebackup -h mydbserver -D /usr/local/pgsql/data</userinput>

</screen>

<screen>

<prompt>$</prompt> <userinput>pg_basebackup -h mydbserver -D /usr/local/pgsql/data</userinput>

</screen>

</para>

<para>

To create a backup of the local server with one maximum compressed

tar file for each tablespace, and store it in the directory

<filename>backup</filename>, showing a progress report while running:

<screen>

<prompt>$</prompt> <userinput>pg_basebackup -D backup -Ft -Z9 -P</userinput>

</screen>

<screen>

<prompt>$</prompt> <userinput>pg_basebackup -D backup -Ft -Z9 -P</userinput>

</screen>

</para>

<para>

To create a backup of a single-tablespace local database and compress

this with <productname>bzip2</productname>:

<screen>

<prompt>$</prompt> <userinput>pg_basebackup -D - -Ft | bzip2 &gt; backup.tar.bz2</userinput>

</screen>

<screen>

<prompt>$</prompt> <userinput>pg_basebackup -D - -Ft | bzip2 &gt; backup.tar.bz2</userinput>

</screen>

(this command will fail if there are multiple tablespaces in the

database)

</para>

For example, <parameter>source_sql</parameter> might produce a set

something like:

<programlisting>

SELECT row_name, extra_col, cat, value FROM foo ORDER BY 1;

row_name extra_col cat value

----------+------------+-----+---------

row1 extra1 cat1 val1

row1 extra1 cat2 val2

row1 extra1 cat4 val4

row2 extra2 cat1 val5

row2 extra2 cat2 val6

row2 extra2 cat3 val7

row2 extra2 cat4 val8

SELECT row_name, extra_col, cat, value FROM foo ORDER BY 1;

row_name extra_col cat value

----------+------------+-----+---------

row1 extra1 cat1 val1

row1 extra1 cat2 val2

row1 extra1 cat4 val4

row2 extra2 cat1 val5

row2 extra2 cat2 val6

row2 extra2 cat3 val7

row2 extra2 cat4 val8

</programlisting>

</para>