Re: Out of memory psql import!

From: Dmitrii Golub <dmitrii(dot)golub(at)gmail(dot)com>
To: Edgar Delgado <edgdelgado(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Out of memory psql import!
Date: 2016-03-21 20:13:17
Message-ID: CAN1orqm4VhYzL1e__VBzR9OX3SUeGqPK9=6=MpafkwwYADiQpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Edgar Delgado 2016-03-21 20:20:54 Re: Out of memory psql import!
Previous Message Edgar Delgado 2016-03-21 20:02:54 Out of memory psql import!