A J <s5...@yahoo.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
-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
