HiveBrain v1.2.0
Get Started
← Back to all entries
snippetbashTip

pg_resetwal — Reset the write-ahead log and other control information of a PostgreSQL database cluster. More infor

Submitted by: @import:tldr-pages··
0
Viewed 0 times
thecommandpg_resetwalcliaheadlogwritereset

Problem

How to use the pg_resetwal command: Reset the write-ahead log and other control information of a PostgreSQL database cluster. More information: <https://www.postgresql.org/docs/current/app-pgresetwal.html>.

Solution

pg_resetwal — Reset the write-ahead log and other control information of a PostgreSQL database cluster. More information: <https://www.postgresql.org/docs/current/app-pgresetwal.html>.

Reset the WAL and control information for a specific data directory:
pg_resetwal {{[-D|--pgdata]}} {{path/to/data}}


Perform a dry run:
pg_resetwal {{[-D|--pgdata]}} {{path/to/data}} {{[-n|--dry-run]}}


Force the WAL and control information reset:
pg_resetwal {{[-D|--pgdata]}} {{path/to/data}} {{[-f|--force]}}


Display help:
pg_resetwal {{[-?|--help]}}


Display version:
pg_resetwal {{[-V|--version]}}

Code Snippets

Reset the WAL and control information for a specific data directory

pg_resetwal {{[-D|--pgdata]}} {{path/to/data}}

Perform a dry run

pg_resetwal {{[-D|--pgdata]}} {{path/to/data}} {{[-n|--dry-run]}}

Force the WAL and control information reset

pg_resetwal {{[-D|--pgdata]}} {{path/to/data}} {{[-f|--force]}}

Display help

pg_resetwal {{[-?|--help]}}

Display version

pg_resetwal {{[-V|--version]}}

Context

tldr-pages: common/pg_resetwal

Revisions (0)

No revisions yet.