Re: Restore 1 Table from pg_dumpall?

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Rich Shepard" <rshepard(at)appl-ecosys(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: Restore 1 Table from pg_dumpall?
Date: 2013-01-22 18:38:03
Message-ID: 20130122183803.120590@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rich Shepard wrote:

> Is there a way I can extract a single table's schema and data from the
> full backup? If so, I can then drop the fubar'd table and do it correctly
> this time.

If you have a server with enough free space, you could restore
the whole cluster and then selectively dump what you need.

-Kevin

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2013-01-22 18:48:41 Re: proposal: fix corner use case of variadic fuctions usage
Previous Message Kevin Grittner 2013-01-22 18:34:43 Re: Pg_xlog increase due to postgres crash (disk full)