Raghu Ram wrote:
>Try with below work-around to restore only hosts table from compressed dump file:
>"pg_restore -t hosts -Fc /var/data/pgsql/backups/prodDB/20111017_puppet.pgdump > hosts_plaindump" [ i.e you'll get a human-readable dump ]
Did you actually try this ?
This does not include any references to indexes, constraints or sequences, all of which it might be useful to recreate.
What I am I missing ? Or is pg_restore just not capable of restoring the full definition of a table ?
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2011-10-25 01:10:44|
|Subject: Re: postgres 9.0.4, pg_restore and indexes |
|Previous:||From: raghu ram||Date: 2011-10-24 23:33:23|
|Subject: Re: postgres 9.0.4, pg_restore and indexes|