logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

pg_restorecluster - Restore from a pg_backupcluster backup

Author

       Christoph Berg <myon@debian.org>

Debian                                             2025-02-20                               PG_RESTORECLUSTER(1)

Description

pg_restorecluster restores a PostgreSQL cluster from a backup created by pg_backupcluster. The cluster
       will be newly created in the system using the name provided on the command line; this allows renaming a
       cluster on restore.  The restored cluster configuration will be updated to reflect the new name and
       location.

       The backup name passed must end in either .basebackup or .dump; usually this will be the full path to a
       backup directory in /var/backups/postgresql/version-cluster/ as reported by pg_backupcluster...list.

       Basebackups are restored as-is. For dumps, pg_createcluster is used to create a new cluster, and schema
       and data are restored via pg_restore.

Files

/var/backups
           Default root directory for cluster backup directories.

       See pg_backupcluster(1) for a description of files.

Name

       pg_restorecluster - Restore from a pg_backupcluster backup

Options

-d--datadirDIR
           Use  DIR  as  data  directory  for  the  restored cluster (default per createcluster.conf, by default
           /var/lib/postgresql/version/cluster).

       -p--portN
           Use port N for restored cluster (default is next free port).

       -s--start
           Start cluster after restoring (default for restore from dump; off for basebackup restores).

           After the cluster has been started, ANALYZE is run on all databases.

       --archive
           Configure cluster for recovery from WAL archive. This sets restore_command to retrieve WAL files from
           backup/../wal.

       --pitrTIMESTAMP--recovery-target-timeTIMESTAMP
           Additionally to setting restore_command, set  recovery_target_time  to  TIMESTAMP  for  point-in-time
           recovery. Also sets recovery_target_action='promote'.

       --wal-archiveDIR
           For archive recovery, read WAL from archive DIR (default is backup/../wal).

See Also

pg_backupcluster(1), pg_restore(1), vacuumdb(1).

Synopsis

pg_restorecluster [options] versionclusterbackup

See Also