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

FreeBSD Manual Pages

  
 
  

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

NAME
       CHECKPOINT - force a write-ahead	log checkpoint

SYNOPSIS
       CHECKPOINT

DESCRIPTION
       A checkpoint is a point in the write-ahead 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 28.5 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).  CHECKPOINT is
       not intended for	use during normal operation.

       If executed during recovery, the	CHECKPOINT command will	force a
       restartpoint (see Section 28.5) rather than writing a new checkpoint.

       Only superusers or users	with the privileges of the pg_checkpoint role
       can call	CHECKPOINT.

COMPATIBILITY
       The CHECKPOINT command is a PostgreSQL language extension.

PostgreSQL 17.5			     2025			 CHECKPOINT(7)

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

home | help