Another pg_restore question - indexes

From: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
To: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Another pg_restore question - indexes
Date: 2013-04-16 15:56:40
Message-ID: 4E154FB60786D74BB4DFDC97BF991CAC03A48E@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Terry 2013-04-16 22:21:06 Conversion from 8.4 to >9 version question
Previous Message Birchall, Austen 2013-04-16 14:24:50 Re: pg_restore - hangs or check on progress