Re: Restore 1 Table from pg_dumpall? [RESOLVED]

On 01/22/2013 10:07 AM, Rich Shepard wrote:
>
> On Tue, 22 Jan 2013, 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.
>
> My solution: view the file in the pager I use (less), then copy relevant
> lines to another file opened in a text editor (joe).

Rich, the main problem is using pg_dumpall. Unfortunately pg_dumpall has
not kept up with all the other advances Postgres has had in the last
decade. To set up dump based backups properly I suggest reviewing:

http://www.commandprompt.com/blogs/joshua_drake/2010/07/a_better_backup_with_postgresql_using_pg_dump/

Sincerely,

Joshua D. Drake

>
> Rich
>
>
>

--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579