Re: Out of memory psql import!

Not yet!

doing a pg_dump right now...

also, the OOM occurs in a copy event of a 2gb table.

droped work_mem to 2gb and trying again with psql while doing a pg_dump

I just did "psql database < stuff.sql"

2016-03-21 17:13 GMT-03:00 Dmitrii Golub <dmitrii(dot)golub(at)gmail(dot)com>:

> 2016-03-21 23:02 GMT+03:00 Edgar Delgado <edgdelgado(at)gmail(dot)com>:
>
>> Hi,
>>
>> Im trying to import a 9.4 database to a 9.5.1 system with psql but after
>> few minutes I get OOM error...
>>
>> Have 15gb ram.
>>
>> Tried pgtune conf and still get error
>>
>>
>> shared_buffers = 3840MB
>> effective_cache_size = 11520MB
>> work_mem = 19660kB
>> maintenance_work_mem = 960MB
>> min_wal_size = 1GB
>> max_wal_size = 2GB
>> checkpoint_completion_target = 0.7
>> wal_buffers = 16MB
>> default_statistics_target = 100
>>
>>
>>
>>
> Please, tell us how are you doing this exactly.
> Did you try pg_dump, pg_restore?
>
> --
> Dmitrii Golub
>