Re: pg_restore out of memory - Mailing list pgsql-general

From Miguel Ramos
Subject Re: pg_restore out of memory
Date
Msg-id 364d6f43-e5f2-12a2-7bda-a7179e725859@miguel.ramos.name
Whole thread Raw
In response to Re: pg_restore out of memory  (Miguel Ramos <org.postgresql@miguel.ramos.name>)
List 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



pgsql-general by date:

Previous
From: Miguel Ramos
Date:
Subject: Re: pg_restore out of memory
Next
From: Tom Lane
Date:
Subject: Re: pg_restore out of memory