Postgres Pro
Downloads
Home   >   mailing lists

Re: Restoring 2 Tables From All Databases Backup - Mailing list pgsql-general

From Dickson S. Guedes
Subject Re: Restoring 2 Tables From All Databases Backup
Date
Msg-id CAHHcreoH-QD2k9KaJ-HPZRPCkR8enfW3k6tzVgBaWBDpVhhMzw@mail.gmail.com
Whole thread Raw
In response to Restoring 2 Tables From All Databases Backup  (Adarsh Sharma <adarsh.sharma@orkash.com>)
Responses Re: Restoring 2 Tables From All Databases Backup  (pasman pasmański <pasman.p@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: null values in a view
Next
From: Tom Lane
Date:
Subject: Re: null values in a view