>ANALYZE</TT
> on each
   database so the optimizer has useful statistics. You
   can also run <TT
CLASS="COMMAND"
>vacuumdb -a -z</TT
> to analyze all
   databases.
  </P
><P
>   <SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> requires all needed
   tablespace directories to exist before the restore;  otherwise,
   database creation will fail for databases in non-default
   locations.
  </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="APP-PG-DUMPALL-EX"
></A
><H2
>Examples</H2
><P
>   To dump all databases:

</P>