diff options
| author | Alvaro Herrera | 2005-09-16 03:12:32 +0000 |
|---|---|---|
| committer | Alvaro Herrera | 2005-09-16 03:12:32 +0000 |
| commit | 3e579cf3c09d98e7d78d8621520592a6c201b582 (patch) | |
| tree | 18cfd2992a6cbb3a610f0bbe5f91c4581cc02c7a | |
| parent | dc06734a7272ab1a3be3f6b86921b0a35008526a (diff) | |
Add note about pg_autovacuum settings not being saved on a dump, per
Robert Treat.
| -rw-r--r-- | doc/src/sgml/maintenance.sgml | 16 |
1 files changed, 13 insertions, 3 deletions
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml index d4b3f51d557..4f7c4d78243 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.46 2005/09/13 01:51:18 alvherre Exp $ +$PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.47 2005/09/16 03:12:32 alvherre Exp $ --> <chapter id="maintenance"> @@ -542,10 +542,20 @@ vacuum threshold = vacuum base threshold + vacuum scale factor * number of tuple values, the <varname>vacuum_cost_limit</varname> and <varname>vacuum_cost_delay</varname> values will be used instead. The other parameter, <structname>pg_autovacuum</>.<structfield>enabled</>, - can be used to instruct the autovacuum daemon to skip any particular table - by setting it to <literal>false</literal>. + can be used to instruct the autovacuum daemon to skip any particular table + by setting it to <literal>false</literal>. </para> + <note> + <para> + The contents of the <structname>pg_autovacuum</structname> system + catalog are currently not saved in database dumps created by + the tools <command>pg_dump</command> and <command>pg_dumpall</command>. + If you need to preserve them across a dump/reload cycle, make sure you + dump the catalog manually. + </para> + </note> + </sect2> </sect1> |