PG_RESETWAL(1) PostgreSQL 18.6 PG_RESETWAL(1) (NAME) pg_resetwal - (WAL) PostgreSQL (SYNOPSIS) pg_resetwal [-f | --force] [-n | --dry-run] [option...] [-D | --pgdata]datadir (DESCRIPTION) pg_resetwal (WAL) pg_control . . . --wal-segsize ( ) initdb . . pg_resetwal WAL . . pg_resetwal (unclean shutdown) -f () . WAL (partially-committed) . (dump) initdb (restore) . . pg_resetwal pg_control -f () . . OID (epoch) (multitransaction) WAL . . -f : . dump . / . (OPTIONS) datadir -D datadir --pgdata=datadir . . pg_resetwal PGDATA . -f --force pg_resetwal . pg_resetwal pg_control . -n --dry-run -n/--dry-run pg_resetwal pg_control . pg_resetwal . -V --version . -? --help . pg_resetwal pg_control . . (hexadecimal) 0x . 8 kB . -c xid,xid --commit-timestamp-ids=xid,xid (commit time) . ( ) pg_commit_ts . ( ) . . -e xid_epoch --epoch=xid_epoch (epoch) . pg_resetwal . Slony-I Skytools -- . -l walfile --next-wal-file=walfile WAL WAL . WAL WAL pg_wal . . "timeline ID" ( ) . 00000001000000320000004A pg_wal -l 00000001000000320000004B . WAL WAL LSN . WAL LSN. pg_resetwal pg_wal -l . -l WAL pg_wal pg_wal ..sp .5v -m mxid,mxid --multixact-ids=mxid,mxid (multitransaction ID) . ( ) pg_multixact/offsets 65536 (0x10000) . ( -m) 65536 . . -o oid --next-oid=oid OID . OID next-OID . -O mxoff --multixact-offset=mxoff multitransaction offset . pg_multixact/members 52352 (0xCC80) . . . -u xid --oldest-transaction-id=xid transaction ID (unfrozen). pg_xact 1048576 (0x100000) . . . 0007 pg_xact -u 0x700000 ( ). -x xid --next-transaction-id=xid transaction ID . pg_xact 1048576 (0x100000) . . . 0011 pg_xact -x 0x1200000 ( ). --char-signedness=option char. signed unsigned. pg_upgrade PostgreSQL 18 char . signed . pg_upgrade . --wal-segsize=wal_segment_size WAL . 2 1 1024 () . initdb(1) . WAL initdb . pg_resetwal WAL WAL WAL . WAL -l WAL . PG_COLOR . always auto never. (NOTES) . pg_resetwal . (crash) pg_resetwal . . pg_resetwal (major version) . (SEE ALSO) pg_controldata(1) PostgreSQL 18.6 2026 PG_RESETWAL(1)