Re: Restoring 2 Tables From All Databases Backup

2011/10/5 Adarsh Sharma <adarsh.sharma@orkash.com>:
> About 1 month ago, I take a complete databases backup of my Database server
> through pg_dumpall command.
> Today I need to extract or restore only 2 tables in a database.
>
> Is it possible or I have to restore complete Databases again. Size of backup
> is 10 GB in .sql.gz format.

If your dump was created using custom format [1] (pg_dump
--format=custom or -Fc)  you can do a pg_restore using --use-list and
--list [2].

[1] http://www.postgresql.org/docs/current/interactive/app-pgdump.html#PG-DUMP-OPTIONS
[2] http://www.postgresql.org/docs/current/interactive/app-pgrestore.html#APP-PGRESTORE-OPTIONS

--
Dickson S. Guedes
mail/xmpp: guedes@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br