A J <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
