PG_REWIND(1) PostgreSQL 18.6 Documentation PG_REWIND(1) (NAME) pg_rewind - PostgreSQL (SYNOPSIS) pg_rewind [...] {-D | --target-pgdata} {--source-pgdata= | --source-server=connstr} (DESCRIPTION) pg_rewind PostgreSQL . (primary) failover (standby) . (rewind) (base backup) . rsync pg_rewind (relation) . WAL . . pg_rewind WAL pg_wal . . failover WAL . WAL pg_wal pg_rewind -c WAL . pg_rewind failover standby (promote ) standby . pg_rewind (replay) WAL . (archive recovery) WAL . WAL pg_rewind pg_rewind . recovery.signal restore_command postgresql.conf . pg_rewind wal_log_hints postgresql.conf (data checksums) initdb ( ). full_page_writes on . : (Failures While Rewinding) pg_rewind . . pg_rewind standby . . pg_rewind . SSL . pg_rewind . . (OPTIONS) pg_rewind : -D directory --target-pgdata=directory . pg_rewind . --source-pgdata=directory . . --source-server=connstr libpq PostgreSQL . (-replication) pg_rewind ( ) (superuser) . . -R --write-recovery-conf standby.signal postgresql.auto.conf . dbname . --source-server . -n --dry-run . -N --no-sync pg_rewind . pg_rewind . . -P --progress . . -c --restore-target-wal restore_command WAL WAL pg_wal . --config-file=filename . pg_rewind postgres ( restore_command -c/--restore-target-wal ). --debug pg_rewind . --no-ensure-shutdown pg_rewind . pg_rewind (single-user) (crash recovery) . pg_rewind . . --sync-method=method fsync ( ) pg_rewind . WAL tablespace . syncfs WAL tablespace . syncfs recovery_init_sync_method . --no-sync . -V --version . -? --help . (ENVIRONMENT) --source-server pg_rewind libpq ( . ). PG_COLOR . always auto never. (NOTES) pg_rewind (superuser) pg_rewind . rewind_user : CREATE USER rewind_user LOGIN; GRANT EXECUTE ON function pg_catalog.pg_ls_dir(text, boolean, boolean) TO rewind_user; GRANT EXECUTE ON function pg_catalog.pg_stat_file(text, boolean) TO rewind_user; GRANT EXECUTE ON function pg_catalog.pg_read_binary_file(text) TO rewind_user; GRANT EXECUTE ON function pg_catalog.pg_read_binary_file(text, bigint, bigint, boolean) TO rewind_user; (How It Works) : 1. WAL . WAL . . WAL pg_rewind -c WAL . 2. (--source-pgdata) SQL (--source-server). WAL . 3. WAL pg_xact . pg_dynshmem/ pg_notify/ pg_replslot/ pg_serial/ pg_snapshots/ pg_stat_tmp/ pg_subtrans/ . backup_label tablespace_map pg_internal.init postmaster.opts postmaster.pid .DS_Store pgsql_tmp . 4. backup_label WAL failover pg_control LSN pg_current_wal_insert_lsn() LSN . 5. PostgreSQL WAL . PostgreSQL 18.6 2026 PG_REWIND(1)