8.4.13 on Red Hat 6
I am doing a backup/restore test of a 'quite large' database
I ran the following backup
pg_dump -Fc testdb -U postgres > /var/lib/pgsql/backups/pg_testdb_backups/testdb_dev_backup$date_of_backup
Id I drop a table I can restore it by doing:
pg_restore -t i100 -d testdb -testdb_dev_backup201304141900
What's the best way to get the index backup?
Thanks again
Austen Birchall
Senior DBA
Met Office