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