<para>

In the same connection as before, issue the command:

<programlisting>

SELECT * FROM pg_stop_backup(false);

SELECT * FROM pg_stop_backup(false, true);

</programlisting>

This terminates the backup mode and performs an automatic switch to

the next WAL segment. The reason for the switch is to arrange for

<function>pg_stop_backup</> terminates because of this your backup

may not be valid.

</para>

<para>

If the backup process monitors and ensures that all WAL segment files

required for the backup are successfully archived then the second

parameter (which defaults to true) can be set to false to have

<function>pg_stop_backup</> return as soon as the stop backup record is

written to the WAL. By default, <function>pg_stop_backup</> will wait

until all WAL has been archived, which can take some time. This option

must be used with caution: if WAL archiving is not monitored correctly

then the backup might not include all of the WAL files and will

therefore be incomplete and not able to be restored.

</para>

</listitem>

</orderedlist>

</para>

</row>

<row>

<entry>

<literal><function>pg_stop_backup(<parameter>exclusive</> <type>boolean</>)</function></literal>

<literal><function>pg_stop_backup(<parameter>exclusive</> <type>boolean</> <optional>, <parameter>wait_for_archive</> <type>boolean</> </optional>)</function></literal>

</entry>

<entry><type>setof record</type></entry>

<entry>Finish performing exclusive or non-exclusive on-line backup (restricted to superusers by default, but other users can be granted EXECUTE to run the function)</entry>

<function>pg_start_backup</>. In a non-exclusive backup, the contents of

the <filename>backup_label</> and <filename>tablespace_map</> are returned

in the result of the function, and should be written to files in the

backup (and not in the data directory).

backup (and not in the data directory). There is an optional second

parameter of type boolean. If false, the <function>pg_stop_backup</>

will return immediately after the backup is completed without waiting for

WAL to be archived. This behavior is only useful for backup

software which independently monitors WAL archiving. Otherwise, WAL

required to make the backup consistent might be missing and make the backup

useless.

</para>

<para>

if (waitforarchive&&XLogArchivingActive())

boolnulls[3];

boolexclusive=PG_GETARG_BOOL(0);

boolwaitforarchive=PG_GETARG_BOOL(1);

XLogRecPtrstoppoint;

stoppoint=do_pg_stop_backup(NULL,true,NULL);

stoppoint=do_pg_stop_backup(NULL,waitforarchive,NULL);

exclusive_backup_running= false;

nulls[1]= true;

stoppoint=do_pg_stop_backup(label_file->data,true,NULL);

stoppoint=do_pg_stop_backup(label_file->data,waitforarchive,NULL);

nonexclusive_backup_running= false;

cancel_before_shmem_exit(nonexclusive_base_backup_cleanup, (Datum)0);

RETURNS pg_lsn STRICT VOLATILE LANGUAGE internalAS'pg_start_backup'

PARALLEL RESTRICTED;

CREATE OR REPLACEFUNCTIONpg_stop_backup (

exclusiveboolean, wait_for_archiveboolean DEFAULT true,

OUT lsn pg_lsn, OUT labelfiletext, OUT spcmapfiletext)

RETURNS SETOF record STRICT VOLATILE LANGUAGE internalas'pg_stop_backup_v2'

PARALLEL RESTRICTED;

CREATEOR REPLACE FUNCTION

json_populate_record(base anyelement, from_json json, use_json_as_textboolean DEFAULT false)

REVOKE EXECUTEON FUNCTION pg_start_backup(text,boolean,boolean)FROM public;

REVOKE EXECUTEON FUNCTION pg_stop_backup()FROM public;

REVOKE EXECUTEON FUNCTION pg_stop_backup(boolean)FROM public;

REVOKE EXECUTEON FUNCTION pg_stop_backup(boolean,boolean)FROM public;

REVOKE EXECUTEON FUNCTION pg_create_restore_point(text)FROM public;

REVOKE EXECUTEON FUNCTION pg_switch_wal()FROM public;

REVOKE EXECUTEON FUNCTION pg_wal_replay_pause()FROM public;

DESCR("prepare for taking an online backup");

DATA(insert OID = 2173 ( pg_stop_backupPGNSP PGUID 12 1 0 0 0 f f f f t f v r 0 0 3220 "" _null_ _null_ _null_ _null_ _null_ pg_stop_backup _null_ _null_ _null_ ));

DESCR("finish taking an online backup");

DATA(insert OID = 2739 ( pg_stop_backupPGNSP PGUID 12 1 1 0 0 f f f f t t v r1 0 2249 "16" "{16,3220,25,25}" "{i,o,o,o}" "{exclusive,lsn,labelfile,spcmapfile}" _null_ _null_ pg_stop_backup_v2 _null_ _null_ _null_ ));

DATA(insert OID = 2739 ( pg_stop_backupPGNSP PGUID 12 1 1 0 0 f f f f t t v r2 0 2249 "16 16" "{16,16,3220,25,25}" "{i,i,o,o,o}" "{exclusive,wait_for_archive,lsn,labelfile,spcmapfile}" _null_ _null_ pg_stop_backup_v2 _null_ _null_ _null_ ));

DESCR("finish taking an online backup");

DATA(insert OID = 3813 ( pg_is_in_backupPGNSP PGUID 12 1 0 0 0 f f f f t f v s 0 0 16 "" _null_ _null_ _null_ _null_ _null_ pg_is_in_backup _null_ _null_ _null_ ));

DESCR("true if server is in online backup");