Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
CHECKPOINT(7)		PostgreSQL 9.6.19 Documentation		 CHECKPOINT(7)

NAME
       CHECKPOINT - force a transaction	log checkpoint

SYNOPSIS
       CHECKPOINT

DESCRIPTION
       A checkpoint is a point in the transaction log sequence at which	all
       data files have been updated to reflect the information in the log. All
       data files will be flushed to disk. Refer to Section 30.4, "WAL
       Configuration", in the documentation for	more details about what
       happens during a	checkpoint.

       The CHECKPOINT command forces an	immediate checkpoint when the command
       is issued, without waiting for a	regular	checkpoint scheduled by	the
       system (controlled by the settings in Section 19.5.2, "Checkpoints", in
       the documentation).  CHECKPOINT is not intended for use during normal
       operation.

       If executed during recovery, the	CHECKPOINT command will	force a
       restartpoint (see Section 30.4, "WAL Configuration", in the
       documentation) rather than writing a new	checkpoint.

       Only superusers can call	CHECKPOINT.

COMPATIBILITY
       The CHECKPOINT command is a PostgreSQL language extension.

PostgreSQL 9.6.19		     2020			 CHECKPOINT(7)

NAME | SYNOPSIS | DESCRIPTION | COMPATIBILITY

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=CHECKPOINT&sektion=7&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help