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 <listas@xxxxxxxxxxxxx>: > 2011/10/5 Adarsh Sharma <adarsh.sharma@xxxxxxxxxx>: >> 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@xxxxxxxxxxxxx - skype: guediz > http://guedesoft.net - http://www.postgresql.org.br > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- ------------ pasman -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
