| From: | Miguel Ramos <org(dot)postgresql(at)miguel(dot)ramos(dot)name> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_restore out of memory |
| Date: | 2016-07-12 15:33:00 |
| Message-ID: | 364d6f43-e5f2-12a2-7bda-a7179e725859@miguel.ramos.name |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Às 16:23 de 12-07-2016, Miguel Ramos escreveu:
>> It looks to me like this error is pg_restore itself running out of
>> memory,
>> not reporting a server-side OOM condition. You could verify that by
>> looking in the server log to see whether any out-of-memory error appeared
>> there. But assuming that I'm right, the other responses suggesting
>> tweaking server configurations are not on-point at all.
[...]
>>
>>> - PostgreSQL 9.1.8 custom compiled to get 32kB blocks
>>
>> 9.1.8 is pretty old ...
Of course, I could try a recent pg_restore.
That'll take me a bit of time too, but I can try.
--
Miguel Ramos
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-07-12 15:58:13 | Re: pg_restore out of memory |
| Previous Message | Miguel Ramos | 2016-07-12 15:23:58 | Re: pg_restore out of memory |