Re: Restore 1 Table from pg_dumpall? - Mailing list pgsql-general

From Kevin Grittner
Subject Re: Restore 1 Table from pg_dumpall?
Date
Msg-id 20130122183803.120590@gmx.com
Whole thread Raw
In response to Restore 1 Table from pg_dumpall?  (Rich Shepard <rshepard@appl-ecosys.com>)
List 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


pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Pg_xlog increase due to postgres crash (disk full)
Next
From: Steve Crawford
Date:
Subject: Re: Running update in chunks?