Re: Restoring 2 Tables From All Databases Backup

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