[postgis-tickets] r17104 - change "vacuum analyze verbose" to "vacuum (analyze, verbose)" - the old syntax was removed in PostgreSQL 11

Regina Obe lr at pcorp.us
Wed Dec 12 10:43:36 PST 2018


Author: robe
Date: 2018-12-12 22:43:36 -0800 (Wed, 12 Dec 2018)
New Revision: 17104

Modified:
   trunk/doc/installation.xml
Log:
change "vacuum analyze verbose" to  "vacuum (analyze, verbose)" -   the old syntax was removed in PostgreSQL 11

Modified: trunk/doc/installation.xml
===================================================================
--- trunk/doc/installation.xml	2018-12-12 06:04:16 UTC (rev 17103)
+++ trunk/doc/installation.xml	2018-12-13 06:43:36 UTC (rev 17104)
@@ -2047,17 +2047,17 @@
 			</listitem>
 			<listitem><para>After you are done loading all data or at a stopping point, it's a good idea to analyze all the tiger tables to update the stats (include inherited stats)</para>
 			    <programlisting>SELECT install_missing_indexes();
-vacuum analyze verbose tiger.addr;
-vacuum analyze verbose tiger.edges;
-vacuum analyze verbose tiger.faces;
-vacuum analyze verbose tiger.featnames;
-vacuum analyze verbose tiger.place;
-vacuum analyze verbose tiger.cousub;
-vacuum analyze verbose tiger.county;
-vacuum analyze verbose tiger.state;
-vacuum analyze verbose tiger.zip_lookup_base;
-vacuum analyze verbose tiger.zip_state;
-vacuum analyze verbose tiger.zip_state_loc;</programlisting>
+vacuum (analyze, verbose) tiger.addr;
+vacuum (analyze, verbose) tiger.edges;
+vacuum (analyze, verbose) tiger.faces;
+vacuum (analyze, verbose) tiger.featnames;
+vacuum (analyze, verbose) tiger.place;
+vacuum (analyze, verbose) tiger.cousub;
+vacuum (analyze, verbose) tiger.county;
+vacuum (analyze, verbose) tiger.state;
+vacuum (analyze, verbose) tiger.zip_lookup_base;
+vacuum (analyze, verbose) tiger.zip_state;
+vacuum (analyze, verbose) tiger.zip_state_loc;</programlisting>
 			</listitem>
 		</orderedlist>
 		<sect3 id="convert_tiger_geocoder_extension"><title>Converting a Tiger Geocoder Regular Install to Extension Model</title>



More information about the postgis-tickets mailing list