Karl Wright <kwright(at)metacarta(dot)com> writes:
> (a) How do I get around the "out of memory" error for pg_restore?
Does this table have foreign key constraints? I imagine you're running
out of space for the deferred-trigger list.
> (b) How can I get the restore performance up to the level where it takes
> only a couple of hours at most to do this restore?
For both this and (a), the main thing is "avoid data-only restores".
particularly the last section about making efficient use of pg_dump.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2007-06-21 14:13:31|
|Subject: Re: initdb problem |
|Previous:||From: Karl Wright||Date: 2007-06-21 13:58:05|
|Subject: Re: Export/import issue/question|