Out of memory psql import!

From: Edgar Delgado <edgdelgado(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Out of memory psql import!
Date: 2016-03-21 20:02:54
Message-ID: CAENQbUOZrvQtwBCBx+oPOaYL-PM61ux1LZnMgrZ7kPDTfeJx9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dmitrii Golub 2016-03-21 20:13:17 Re: Out of memory psql import!
Previous Message bricklen 2016-03-21 15:37:06 Re: vacuum analyse waiting