Hi Adarsh, Filip workaround is right approach, since its plain text format you need to play with SED/AWK to pull those two tables.
Following link will help you:- http://blog.endpoint.com/2010/04/restoring-individual-table-data-from.html --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ 2011/10/5 pasman pasmański <pasma...@gmail.com> > You should to create new database with two empty tables, set access > rights for all schemas readonly and pipe backup to this database. > > 2011/10/5, Dickson S. Guedes <lis...@guedesoft.net>: > > 2011/10/5 Adarsh Sharma <adarsh.sha...@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: gue...@guedesoft.net - skype: guediz > > http://guedesoft.net - http://www.postgresql.org.br > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > > > > -- > ------------ > pasman > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
