A J <s5aly(at)yahoo(dot)com> wrote:
> I think with pg_dump and pg_restore (or psql restore), the only
> option is to rebuild the indexes. Am I right or is it possible to
> backup indexes as well and restore them ?
With pg_dump it is copying in rows by value, so indexes must then be
built. If you use PITR backups, it is a block-by-block copy of the
files, including indexes -- no index rebuild is needed for that
technique.
-Kevin