| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Michael Nolan <htfoot(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What Would You Like To Do? |
| Date: | 2011-09-24 13:51:38 |
| Message-ID: | 201109241351.p8ODpcU18153@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Joshua D. Drake wrote:
>
> On 09/13/2011 11:51 AM, Michael Nolan wrote:
>
> >
> > The ability to restore a table from a backup file to a different
> > table
> > name in the same database and schema.
> >
> >
> > This can be done but agreed it is not intuitive.
> >
> >
> > Can you elaborate on tha a bit, please? The only way I've been able to
> > do it is to edit the dump file to change the table name. That's not
> > very practical with a several gigabyte dump file, even less so with one
> > that is much larger. If this capability already exists, is it documented?
>
> You use the -Fc method, extract the TOC and edit just the TOC (so you
> don't have to edit a multi-gig file)
How does that work in practice? You dump the TOC, edit it, restore the
TOC schema definition, then how do you restore the data to the renamed
table?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2011-09-24 14:14:00 | Re: What Would You Like To Do? |
| Previous Message | Martijn van Oosterhout | 2011-09-24 13:45:26 | Re: Re: memory barriers (was: Yes, WaitLatch is vulnerable to weak-memory-ordering bugs) |