diff options
Diffstat (limited to 'doc/src/sgml/ref/pg_resetxlog.sgml')
| -rw-r--r-- | doc/src/sgml/ref/pg_resetxlog.sgml | 19 |
1 files changed, 18 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/pg_resetxlog.sgml b/doc/src/sgml/ref/pg_resetxlog.sgml index aba7185f355..59280f01cb1 100644 --- a/doc/src/sgml/ref/pg_resetxlog.sgml +++ b/doc/src/sgml/ref/pg_resetxlog.sgml @@ -22,6 +22,7 @@ PostgreSQL documentation <refsynopsisdiv> <cmdsynopsis> <command>pg_resetxlog</command> + <arg choice="opt"><option>-c</option> <replaceable class="parameter">xid</replaceable>,<replaceable class="parameter">xid</replaceable></arg> <arg choice="opt"><option>-f</option></arg> <arg choice="opt"><option>-n</option></arg> <arg choice="opt"><option>-o</option> <replaceable class="parameter">oid</replaceable></arg> @@ -79,9 +80,12 @@ PostgreSQL documentation <para> The <option>-o</>, <option>-x</>, <option>-e</>, <option>-m</>, <option>-O</>, + <option>-c</> and <option>-l</> options allow the next OID, next transaction ID, next transaction ID's - epoch, next and oldest multitransaction ID, next multitransaction offset, and WAL + epoch, next and oldest multitransaction ID, next multitransaction offset, + oldest and newest transaction IDs for which the commit time can be retrieved, + and WAL starting address values to be set manually. These are only needed when <command>pg_resetxlog</command> is unable to determine appropriate values by reading <filename>pg_control</>. Safe values can be determined as @@ -130,6 +134,19 @@ PostgreSQL documentation <listitem> <para> + A safe value for the oldest transaction ID for which the commit time can + be retrieved (first part of <option>-c</>) can be determined by looking + for the numerically smallest file name in the directory + <filename>pg_committs</> under the data directory. Conversely, a safe + value for the newest transaction ID for which the commit time can be + retrieved (second part of <option>-c</>) can be determined by looking for + the numerically greatest file name in the same directory. As above, the + file names are in hexadecimal. + </para> + </listitem> + + <listitem> + <para> The WAL starting address (<option>-l</>) should be larger than any WAL segment file name currently existing in the directory <filename>pg_xlog</> under the data directory. |