Postgres Pro
Downloads
Home   >   mailing lists

Another pg_restore question - indexes - Mailing list pgsql-novice

From Birchall, Austen
Subject Another pg_restore question - indexes
Date
Msg-id 4E154FB60786D74BB4DFDC97BF991CAC03A48E@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk
Whole thread Raw
In response to Roles and passwds  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
List pgsql-novice
Tree view 

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

pgsql-novice by date:

Previous
From: "Birchall, Austen"
Date:
Subject: Re: pg_restore - hangs or check on progress
Next
From: Richard Terry
Date:
Subject: Conversion from 8.4 to >9 version question