Raghu Ram wrote: <snip> > >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 ? TIA, Greg WIlliamson -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
