Re: Restoring 2 Tables From All Databases Backup

Thanks to all, the problem is solved now.

But Still I donot know how to use existing data directory (near about
110GB) in a new Postgres Installation.
I ask this in the list yesterday but still no clue on this.
Please guide if it is possible.

Best Regards
Adarsh

Raghavendra wrote:
> 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
> <mailto: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
> <mailto:listas(at)guedesoft(dot)net>>:
> > 2011/10/5 Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com
> <mailto: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 <mailto: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 <mailto: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
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>