Re: Out of memory psql import!

[Dmitrii Golub <dmitrii.golub@xxxxxxxxx>]

2016-03-21 23:02 GMT+03:00 Edgar Delgado <edgdelgado@xxxxxxxxx>:

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